Arithmetic scale in charts
 

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.

Arithmetic scale in charts
 

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

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"André Crestani" <André wrote in message
...
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.

Arithmetic scale in charts
 

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