[App attached] How can I get this Bar Chart to be a Stacked Bar Chart the way I want it?

[jblomqvist]

Hi all,

In the attached app I would like to show a stacked bar chart where each bar relates to a single selection in a list box.

Within each bar I would like to show number of sales checks that were Over 50 or Under 50.

I tried adding that as an additional dimension but that ruins the design of my chart.

I would like to ti stay as the chart it is at the moment but somehow create a stack within each bar that shows portion that is Over 50 or Under 50.

Is there a way to do this please?

Any suggestions would be great.

Here is the output I am looking for:

Each bar for each month represents one company selected from State A and State B list boxes (as shown in the app).

[jblomqvist]

Anyone?

[SreeniJD]

Hi John,

Can you please send me screenshots and required output

Sreeni

[#4]

Please share the desired output

[jblomqvist]

Hi, I have attached it with the original email

[MarcoWedel · Accepted solution]

Hi,

one solution could be:

hope this helps

regards

Marco

[jblomqvist]

Thank you Marco you are a star!

[MarcoWedel]

glad I could help ...

regards

Marco