Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Vertical Axis With Negative Value
I have a negative value in the axis that I don't wish to display. Also the
horizontal line displays at 0 and I want it to be after the negative value. Any ideas? 4 2 0______________________________________ -2 Want it to display as 4 2 0 _______________________________________ |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Vertical Axis With Negative Value
A custom number format will hide the negative number:
0;0;;@ Move the horizontal axis down by double clicking on the vertical axis, and choosing an appropriate value for Category Axis Crosses At. You could enter the minimum of the Y axis, or to ensure it is always at the bottom, enter a very negative number, like -10000000. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Jan" wrote in message ... I have a negative value in the axis that I don't wish to display. Also the horizontal line displays at 0 and I want it to be after the negative value. Any ideas? 4 2 0______________________________________ -2 Want it to display as 4 2 0 _______________________________________ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2 Vertical Axis? Not sure what I am looking for... | Charts and Charting in Excel | |||
make chart with both horizontal-x axis vertical-y axis | Charts and Charting in Excel | |||
Only 2 vertical axis? | Charts and Charting in Excel | |||
Dual Vertical Y-Axis | Charts and Charting in Excel | |||
can I make the vertical axis the category axis in Excel line graph | Charts and Charting in Excel |