Arithmetic scale in charts

[André Crestani]

Hi, I'm having some trouble by changing the scale of a vertical axis into an
arithmetic scale, I don't know if it is possible on excel...I have tried a
lot of ways but none of then worked.
To simplify, here what I want to do:
Change the scale of a chart from
1, 2, 3, ......10
or
5, 10, 15, .....100
To a scale that goes like this
1, 2, 5, 10, 16, 20,............99,9 (it's on percents)
Thanks in advance.

 

[Andy Pope]

Hi,

For a scale like that you would have to create you own labeling.
See Jon's page
http://peltiertech.com/Excel/Charts/ArbitraryAxis.html

Cheers
Andy

 

[André Crestani]

Thank you very much Andy, your answer really helped me out.