View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope Andy Pope is offline
external usenet poster
 
Posts: 2,489
Default 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.