Last answered:

21 Feb 2023

Posted on:

16 Feb 2023

0

Discrepency between Excel and Tableau instructions

Why is there emphasis on the "Python Users" axis equaling 100% in the Excel instruction for Combo Charts, but it okay for the same axis in the Tableau chart to equal 60%? 

1 answers ( 0 marked as helpful)
Instructor
Posted on:

21 Feb 2023

1

Hi Shawn, 

thanks for reaching out! 

The emphasis on the Excel chart was mainly to ensure the scales and proportions of the chart are correct. Tableau usually rescales automatically with combo charts, however in other software we need to adjust manually. If you wish you can change the axis range of the Tableau chart as well, you can do so with a right click on the axis and by manually changing the axis range. 

It's not a strict requirement that the scale goes to 100% on a dual chart, especially if say we have only very low percentages, like conversion rates, in the range of 5% - 10%. Then we can opt for a scale of 20% maximum. What we need to consider is how this line chart will overlap another, in the case of combo charts, and some rescaling might be needed for the sake of readability of both charts. 

If you have any other questions or doubts, don't hesitate to reach out!


Best, 

365 Eli


Submit an answer