If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
why can I not format a secondary axis in excel x? | mackie99 | Charts and Charting | 3 | December 29th, 2004 02:21 PM |
WHY | General Discussion | 9 | December 16th, 2004 12:49 AM | |
Windows in Taskbar | Chevy | General Discussion | 8 | October 15th, 2004 03:57 PM |
outputting memo fields to excel | John Baker | Running & Setting Up Queries | 7 | August 12th, 2004 01:23 PM |
Excel 2000 X axis conundrum | Scott | Charts and Charting | 1 | March 29th, 2004 01:53 PM |