Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Suppressed 0's on the vertical axis in Excel '97
I got an error the first time I tried to post this earlier this afternoon,
please accept my apologies if this is question is duplicated. The question has come up in a local users group: We are designing a column chart on excel 97, and we want to have a suppressed zero on the vertical axis. The automatic range comes up at 0 - 25. Individual data values are between 12 and 19. We want to make the vertical axis set at 10 - 20. Can this be done Thank you in advance for your thoughts, Gary |
#2
|
|||
|
|||
Double click on the axis, and on the Scale tab, enter 10 for minimum and
20 for maximum. Don't re-check the boxes in the Auto column next to the values you enter (believe it or not, some people check this and then don't understand why Excel goes back to autoscale mode). - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Literalgar wrote: I got an error the first time I tried to post this earlier this afternoon, please accept my apologies if this is question is duplicated. The question has come up in a local users group: We are designing a column chart on excel 97, and we want to have a suppressed zero on the vertical axis. The automatic range comes up at 0 - 25. Individual data values are between 12 and 19. We want to make the vertical axis set at 10 - 20. Can this be done Thank you in advance for your thoughts, Gary |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Installing: Microsoft Excel Feature | Excel Discussion (Misc queries) | |||
axis break graphing in excel | Charts and Charting in Excel | |||
Excel moving horizontal columns to vertical | Excel Discussion (Misc queries) | |||
sharing/using/saving Excel 2002 files in Excel 2003 | Excel Discussion (Misc queries) | |||
How do I get a second Y axis in Excel 2000 | Charts and Charting in Excel |