Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Formatting axis decimals
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formatting : amount of decimals | Excel Discussion (Misc queries) | |||
Formatting cells for decimals and hyphens | Excel Discussion (Misc queries) | |||
Formatting X-Axis in Chart | Excel Discussion (Misc queries) | |||
Formatting X and Y axis' | Charts and Charting in Excel | |||
Formatting of x axis | Excel Discussion (Misc queries) |