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

Lu_zhang

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!

MichelleH

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

MichelleH

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

Lu_zhang

https://community-forums.domo.com/main/discussion/comment/96219#Comment_96219

thank you @MichelleH

Lu_zhang

@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

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

david_cunningham

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