View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
David Biddulph David Biddulph is offline
external usenet poster
 
Posts: 620
Default Formatting axis decimals

On the Number tab under Format Axis, choose General, rather than Number
--
David Biddulph

"Don Culp" wrote in message
...
I have a chart that uses a log scale on the X axis. The axis values range
from 0.1 to 100. I'd like to have them displayed as 0.1, 1, 10, and 100
(i.e., any number greater than or equal to 1 should not display any
decimals). If I specify 0 decimals then the 0.1 displays only as 0;
however,
if I specify 1 decimal then the axis values are displayed as 0.1, 1.0,
10.0,
and 100.0.

Thanks,
Don Culp