Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Scales on Charts.
I created a chart but the scale on the Y axis increments by .5 (1 to 1.5 to 2
to 2.5 to 3 to 3.5) How can I change it to increment by whole numbers, 1, 2, 3, 4, ,5, etc.... |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Scales on Charts.
Right click on the axis and click Format Axis. Then on the Scale tab change
whatever is in Major unit to 1, then click OK. Regards, Tom "GEM" wrote: I created a chart but the scale on the Y axis increments by .5 (1 to 1.5 to 2 to 2.5 to 3 to 3.5) How can I change it to increment by whole numbers, 1, 2, 3, 4, ,5, etc.... |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Scales on Charts.
Thanks!!!
"Tom-S" wrote: Right click on the axis and click Format Axis. Then on the Scale tab change whatever is in Major unit to 1, then click OK. Regards, Tom "GEM" wrote: I created a chart but the scale on the Y axis increments by .5 (1 to 1.5 to 2 to 2.5 to 3 to 3.5) How can I change it to increment by whole numbers, 1, 2, 3, 4, ,5, etc.... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
scales on surface / contour charts | Charts and Charting in Excel | |||
Time Scales on Horizontal Axis - Excel Charts | Charts and Charting in Excel | |||
Radar charts with unequal scales along the axes | Charts and Charting in Excel | |||
How do I create different scales on Excel charts? | Charts and Charting in Excel | |||
Disappearing scales on bar charts with multiple series | Charts and Charting in Excel |