Reform x-axis

[Taiseer]

Hi,

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.
Any help.

Thank you
Taiseer

 

[Worf]

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