Stacked Grouped bar chart

Options

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!

Best Answer

  • MichelleH
    MichelleH Coach
    Answer ✓
    Options

    @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.

Answers

  • MichelleH
    MichelleH Coach
    Answer ✓
    Options

    @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.

  • 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.

    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.