6 Replies Latest reply on Jan 15, 2014 10:32 PM by sayidzulhusni tuansharif

# How to create dual axis

Hi, am still new on Tableau. I tried to create a secondary axis for my data. example, I have 4 variable with 1 variable data range from 100K to 500K but the other 3 is only range from 100-500. so if I just put it in ONE axis, then the other 3 will definitely looks like zero as the axis will be range in thousands.

• ###### 1. Re: How to create dual axis

Hi,

Check this link: - Dual Axes

But here you have 3 axis of approx same amount values & one is of different amount of values. For this put 3 different measures with Measure Values & one without Measure Values. Check the attached file for your answer.

Always try to attach a sample workbook (.twbx) & when you will get correct answer of your problem, just mark correct answer to correct.

Warm Regards,

Prashant Sharma - India | LinkedIn

• ###### 2. Re: How to create dual axis

Hi Prashant Sharma,

The link is for diff type of measures, correct?

This is actually the problem am facing now. Pls find attached sample:

I put "Res" as a dimension and group it into 4 groups. So the "Images" group have a big numbers while the other 3 are not. How I can move the other 3 to the secondary axis. Thanks

Thanks

• ###### 3. Re: How to create dual axis

Hi,

Check the file attached by me in previous reply. That solution may work for you. Following are the steps: -

1) First put dimension in column.

2) Put Measure Names from dimension section to filter & choose those 3 measures which are having small values.

3) Put Measure which is having large values in row.

4) Right click & choose Dual Axis.

For more check my attached file from previous reply. Hope this may work for you.

Warm Regards,

Prashant Sharma - India | LinkedIn

• ###### 4. Re: How to create dual axis

Still cannot be done. Your example is for two diff dimensions but mine is from one dimension which is "res".

Herewith I attached an images that I'm working at the moment. btw, how can I attached a worksheet since my data connection is from SQL server. If possible then more easier for you to see.

• ###### 5. Re: How to create dual axis

Hi there,

If what you want to communicate is whether the rate of change is similar for items in 'res', then the simplest would be to use a logarithmic axis - right click on the axis > Edit Axis > Scale >chose logarithmic.  Check out Stephen Few on Dual-Scaled Axis and Using Log Scales - great insight.

http://www.perceptualedge.com/blog/?p=24

Hope that helps!

• ###### 6. Re: How to create dual axis

Hi Kelly

Yeah, I also think this is the only way to do. Thanks everyone for sharing the info.