This is a discussion on Reform x-axis within the Excel Questions forums, part of the Question Forums category; Hi, I have the following figure (version1) and I need to reform or shorten the x-axis to get the 100 ...
I have the following figure (version1) and I need to reform or shorten the x-axis to get the 100 closer to the 20.
Why? Becasue I need to make the figure smaller and the whole distance between 20 and 100 is not needed as the change is linear.
Hi and welcome to the Board
I cannot see your picture. Anyway, you could use a broken axis, logarithmic scale or a panel chart. See this page:
Broken Y Axis in an Excel Chart - Peltier Tech Blog
Excel 2013 / Windows 8.1 (home)
Excel 2013 / windows 7 (work)
Read Forum Rules here