bar chart with 2 dimensions and 2 formulas

[#1]

Hello everyone

Is it possible to create a bar chart with 2 dimensions, say business unit and year and compare the sum of the earnings from the current and the last year?

When I try to create this chart the two sums are stacked. I am not able to separate the two sums. They remain stacked in the same bar...

Thank you for your help!

Jan

[#2]

Hi,

Could you post a sample if possible??

Kiru

[#3]

Hi Kiru

maybe these screeshots help to explain:

[#4]

If I understood your problem correctly, I have done a sample example, please have a look at it.

Let me know if I am wrong.

Kiru

[#5]

Justo go to Properties of the chart, select STYLE, and then in SUBTYPE select GROUPED.

Like this:

[#6]

Hi Ramiro

Weired thing is, "grouped" is selected...

Best

Jan

[#7]

Ok, i've solved you problem

Go to the dimentions tab, "edit groups", create a new "drill-down-group" with the dimentions of the chart. Delete the dimentions and add the group as the only dimention.

It should work!

Editing with images in german:

[MarcoWedel]

Hallo Jan,

one possible solution might be:

hope this helps

Gruß

Marco

[#9]

True, thank you.

[MarcoWedel · Accepted solution]

Hi,

please mark this thread answered, if there are no further questions.

thanks

regards

Marco