5 Replies Latest reply on Aug 28, 2018 11:23 AM by suvarshika.n

# Create a Dual Axis Bar chart in Tableau with one of the Axis being a Min/Max/Avg?

Hi All,

I'm trying to recreate this chart with a dual axis. The left is a count I have in Excel, while I want the right axis to be a range for the Min/Max/Avg for another measure within the data. Is there any way to do this in Tableau? I would ideally like the Min/Max/Avg also shown on the bar charts as shown below, as well.

• ###### 1. Re: Create a Dual Axis Bar chart in Tableau with one of the Axis being a Min/Max/Avg?

It will be easy to understand if you can attach workbook.

Guide to Attach Workbook

• ###### 2. Re: Create a Dual Axis Bar chart in Tableau with one of the Axis being a Min/Max/Avg?

Hi Zhasan,

It is possible to an extend. Below is what I created using Superstore Sales, (AVG) Profit, and Order Date - ideally both measures are bar Chart which Sales in Blue color (decrease Opacity to 25%) and for AVG Profit decrease the size of bar to make it thin.

Please review attached workbook and if you find this useful then please mark it as correct answer. Thank you.

Best regards,

Ankit

• ###### 3. Re: Create a Dual Axis Bar chart in Tableau with one of the Axis being a Min/Max/Avg?

Below is my workbook. I have the count to the left but the right side axis isn't pertaining to the Min/Max/Avg values, and I can't seem to find a way to show the Min/Max/Avg values like I'd like.

• ###### 4. Re: Create a Dual Axis Bar chart in Tableau with one of the Axis being a Min/Max/Avg?

Hi Ankit Patel,

I see that AVG is shown on that dashboard, but how can I put min/max on there as well and have the axis reflect that range?

• ###### 5. Re: Create a Dual Axis Bar chart in Tableau with one of the Axis being a Min/Max/Avg?

Hi Zhansan,

Below is what i created closer to your requirement , please find screenshot and twbx

Thanks

Suvi