Grouped AND Stacked in the same Graph

[cristian_av]

Hi

I have three expressions: A,B and C.

A + B Compose Item1, and C is Item2.

I would like to show Item1 and Item2 as a Stacked Bar, and in the same graph Item 3 Grouped with Item2.

As you can see in the image, What I need is the Graph 1, But Replacing the green Bars with the Bars of Graph 2

Any idea how to do that?

Thanks!!

[cristian_av]

Any idea how to do that?

If not... any Idea about how can I represent that kind of data in a decent style?

Thanks!!

[JonnyPoole]

If your 1st dimension doesn't have many values try the 'trellis' option on the dimension tab of the chart properties. It will create a new chart for each unique value of the 1st dimension in the list.

Also worth reading about use of combo charts and toggle stack vs group in this thread.

is it possible to grouping and stacking of bars in single barchart

[cristian_av]

Thanks! But my dimension has about 50 values, so I think Trellis doesn't looks so good..

The link you post help a bit!

😃