ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Chart Help (https://www.excelbanter.com/charts-charting-excel/128611-chart-help.html)

J Streger

Chart Help
 
I'm looking for a way to have a column chart show positive numbers both above
and below the 0 line on the chart. So from Top to bottom would read 200, 100,
0, 100, 200 etc. Is this possible?

--
*********************
J Streger
MS Office Master 2000 ed.
MS Project White Belt 2003


Jon Peltier

Chart Help
 
Custom number format. Double click the axis, and on the Numbers tab of the
dialog, enter this:

0;0

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"J Streger" wrote in message
...
I'm looking for a way to have a column chart show positive numbers both
above
and below the 0 line on the chart. So from Top to bottom would read 200,
100,
0, 100, 200 etc. Is this possible?

--
*********************
J Streger
MS Office Master 2000 ed.
MS Project White Belt 2003





All times are GMT +1. The time now is 06:35 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com