Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Format Y-Axis
I am trying to get my Y-axis to go from 1-30 with major unit gridlines at 5
and no minor units. The Format Axis / Scale Tab reads: Minimum=0 Maximum=30 Major Unit=5 Minor Unit=1 (have marked no gridlines and it can't be 0) When I do this, it throws out 0's and 1's on the Y-axis...how can I fix this problem? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Format Y-Axis
Bethieppooh:
Your post raises at least two questions: 1.***** Y Axis range & interval You have told Excel that you want Y axis from 0 to 30 with major interval of 5. Excel expects uniform Y axis intervals like: 0-5-10-15-20-25 or 1-6-11-16-21. Trying to get Excel to start at 1 then go to 5-10-15 etc is a non-uniform Y axis interval. Excel can give you 1-6-11 etc or 0-5-10 etc, it can't give you 1-5-10-15, etc unless you create a dummy series. ..Kelly "Bethiepooh" wrote in message ... I am trying to get my Y-axis to go from 1-30 with major unit gridlines at 5 and no minor units. The Format Axis / Scale Tab reads: Minimum=0 Maximum=30 Major Unit=5 Minor Unit=1 (have marked no gridlines and it can't be 0) When I do this, it throws out 0's and 1's on the Y-axis...how can I fix this problem? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom Format Cell | Excel Discussion (Misc queries) | |||
Conditional Format Not Working | Excel Discussion (Misc queries) | |||
Secondary Axis Match Primary Axis Gridlines | Charts and Charting in Excel | |||
Pivot Table, Line Chart with Secondary Y axis, Page Field selection destroys Y2 axis | Charts and Charting in Excel | |||
Formatting dates on x axis of chart...! | Excel Discussion (Misc queries) |