Can I design the kind of chart with 3 bars stacked and 2 lines

Options
Lu_zhang
Lu_zhang Member
in Dashboards

I want this kind of chart in DOMO.

below is the excel chart.

there are 3 bars stacked and 2 lines.

need help! thank you so much!

image.png
Tagged:

Best Answer

  • MichelleH
    MichelleH Coach
    Answer ✓

    @Lu_zhang You can use the "Line bar" chart type to achieve this. These charts default to one line metric and bars for the rest, but you can change the "Series on left scale" (found under General chart properties) to 2 to display a second line.

    image.png

Answers

  • MichelleH
    MichelleH Coach
    Answer ✓

    @Lu_zhang You can use the "Line bar" chart type to achieve this. These charts default to one line metric and bars for the rest, but you can change the "Series on left scale" (found under General chart properties) to 2 to display a second line.

    image.png
  • Lu_zhang
    Lu_zhang Member
    https://community-forums.domo.com/main/discussion/comment/96219#Comment_96219

    thank you @MichelleH

  • Lu_zhang
    Lu_zhang Member
    image.png

    @MichelleH I don't find it "Series on left scale" (found under General chart properties) , please see above picture. Need help. what's wrong with it?

  • david_cunningham
    david_cunningham Coach

    @Lu_zhang - you're looking at period over period cards. You'll want to use the line + stacked bar option, which will have the ability to set the number of series you want on the left scale. You can find this by going to "Vertical Bar" and then looking for Line + Stacked Bar.

    Keep in mind that for this to work, you'll need to have all of these in a single series. In other words, the series groups must be defined in a single column.

    When you accept an answer, please accept @mcih and not mine. Just wanted to chime in so that you could continue to make progress.

    Screen Shot 2024-05-30 at 10.34.11 PM.png

    David Cunningham

    ** Was this post helpful? Click Agree 😀, Like 👍️, or Awesome ❤️ below **
    ** Did this solve your problem? Accept it as a solution! ✔️**

  • david_cunningham
    david_cunningham Coach
    edited May 2024

    @mcih = @MichelleH - there's some weird bug going on where it isn't letting me edit my previous comment, so wanted to clarify what was meant.

    Also, in terms of series, I mistyped and now can't edit my previous column. What I meant to say is it's probably easiest if each of these columns is it's own series. So the 2 lines would be generated via their own beast mode/column, and the 3 bars would be generated via their own beast modes / columns.

    You can have them all in a single series, but then you will need to define their sort order to make sure that the values you want on the line vs bar are mapped correctly.

    David Cunningham

    ** Was this post helpful? Click Agree 😀, Like 👍️, or Awesome ❤️ below **
    ** Did this solve your problem? Accept it as a solution! ✔️**

Categories