Stacked Grouped bar chart

Elnaz

Hello!

I have 5 columns in my dataset for 'province', 'city', 'A', 'B', and 'C'. I need a stacked-grouped bar chart such that the x-axis shows the province, for each province we have a category of 3 grouped bars for columns A, B, C and in each bar we have the cities by different colors. Could you please guide me with that?

Thanks!

MichelleH

@Elnaz Domo's out of the box chart types don't have a stacked/grouped option for more than 2 grouped bars, though you may be able to build your own card using Bricks. That said the graph you're describing sounds like it would be pretty busy, so I would actually recommend using a simpler chart type with drills or a collection of charts to display your data. Here is a graphic that I've found helpful for choosing the best chart type.

Choosing Chart Types (1).pdf

MichelleH

@Elnaz Domo's out of the box chart types don't have a stacked/grouped option for more than 2 grouped bars, though you may be able to build your own card using Bricks. That said the graph you're describing sounds like it would be pretty busy, so I would actually recommend using a simpler chart type with drills or a collection of charts to display your data. Here is a graphic that I've found helpful for choosing the best chart type.

Choosing Chart Types (1).pdf

MarkSnodgrass

Agree with @MichelleH that this sounds pretty busy. You might look into using the Trellis Categories on a bar chart to help break it up.