8 Replies Latest reply on Apr 25, 2017 11:41 AM by Luciano Vasconcelos

# Side-by-Side Bar Charts (not stacked)

Hello,

I'm finding difficulty with displaying my bar chart side-by-side rather than stacked on top of each other. The attached workbook contains 6 metrics - 2 under SUM(Mtd value) and the other 4 filtered through Measure Values. The chart is correct as I have it, except for the bars not being next to each other. This functionality is easy to create with Excel, so I'm sure it can be done with Tableau, though I have not seen anything that shows me how. Thank you for the help!!

Eddie

• ###### 1. Re: Side-by-Side Bar Charts (not stacked)

Hi. Is this what you need?

• ###### 2. Re: Side-by-Side Bar Charts (not stacked)

Hi Edward,

If this is what you are looking for, you can go to Show me in top right corner and press Side by Side Chart and take out My Measure Names from the Columns.

Hope it Helps!!!

Thanks

Deepak

• ###### 3. Re: Side-by-Side Bar Charts (not stacked)

Hi Deepak and Luciano,

Thanks for the suggestions but no, not exactly. I need the four measures (Itd CPI, Itd SPI, TCPI(b) & TCPI(e) to be displayed as line graphs overlapping the Mtd Metric (split into two, non-stacked bars). In the workbook I provided it was close, but the bars are stacked rather than side-by-side. Do either of you know if there's anyway to make just those two side-by-side bars with the rest as lines? Thanks!!

• ###### 4. Re: Side-by-Side Bar Charts (not stacked)

Hi Edward,

Then I suppose I got your question correct. There is small challenge here. Since In your data, when "My Measure Name" is MtdSPI, there is no value for the other four measure - (Itd CPI, Itd SPI, TCPI(b) & TCPI(e)) , It gives dots instead of lines.

I have attached the worksheet with three options possible.

Cheers!

1 of 1 people found this helpful
• ###### 5. Re: Side-by-Side Bar Charts (not stacked)

How do i split Mtd Metric into two, non-stacked bars?

Which criteria?

• ###### 6. Re: Side-by-Side Bar Charts (not stacked)

Hi Abhinav,

Yes, the reason I created that "My Measure Name" tab was so I could separate MtdSPI and MtdCPI as they were the two that would be displayed as bars while the others would be displayed as lines. They were originally separate columns in my excel spreadsheet like the others, but I changed them so I could create a comprehensive combination chart. The graph you provided with the dots is the closest thing to what I'm looking for - but like you said, it provides dots, not lines. Is there a way to make them connect? Would I have to manipulate my data source first, rather than on Tableau? Thank you! I really, really appreciate the help!

Best,

Eddie

• ###### 7. Re: Side-by-Side Bar Charts (not stacked)

Hi Edward,

I did try to connect a lot but couldn't connect the dots. The thing you are asking can be however achieved through a little more calculations.

Follow this Link: Bars and Lines | Drawing with Numbers

The thing you are looking for is explained in Sheet 5: Grouped Bar, Lines Discrete

Feel free to shoot any doubts that you may have.

Best,

Abhi.

• ###### 8. Re: Side-by-Side Bar Charts (not stacked)

Abhi's ideia doesn't work for you because measure names has to be in colors.

I only got to do using one bar and a reference line.