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.

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.

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