3 Replies Latest reply on Oct 16, 2018 3:08 PM by Gerardo Varela

# How do I make the bar chart in a dual axis graph with two measures side by side instead of stacked?

I am beginning to see the differences between Excel and Tableau, what would be easier in one and not the other. Unfortunately, this has been something I've been stuck on for a while. I have the measures Quantity and Sales, with Quantity as the bars and Sales as the lines. Applying the filter of segment for consumer and corporate, I wish to have the bars side by side instead of stacked. How can I accomplish this while keeping the lines?

Attached is the workbook with supermarket data.

Thank you!!

• ###### 1. Re: How do I make the bar chart in a dual axis graph with two measures side by side instead of stacked?

Hi Edward - like this ?

Should be self-explanatory, the key part of the logic was that Segment needed to be on columns to make it a side by side bar

HTH

Peter

• ###### 2. Re: How do I make the bar chart in a dual axis graph with two measures side by side instead of stacked?

Thank you! The bars are side by side, but how can I accomplish that while also preserving the lines? Because this way it connects the two points between consumer and corporate within each month, while I want a cohesive line for consumer and corporate separately while spanning the months.

• ###### 3. Re: How do I make the bar chart in a dual axis graph with two measures side by side instead of stacked?

Educational Brain Teaser : Grouped Bars (again)     - The most polished one I've seen to date.

Bars and Lines | Drawing with Numbers   - Here is a great blog that explains several ways of reaching your end goal.

Suggestions   - Shameless plug were I applied what I learned from the above link.

Combo Chart off of a single measure - HELP!!??   - Another plug with a slightly different approach.

Give those a read and if you get stuck or need more help. Please post back.

All of the links above have the same basic concept, telling tableau to plot the bars in ever so slightly different spots so it splits them up.

Regards,

Gerardo