Don't change where the category (X) axis crosses the value (Y) axis. Format
the category (X) axis, select the "Low" option for the tick labels.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. -
http://PeltierTech.com
_______
"DALLAS6570" wrote in message
...
I am having a problem that I think has a simple fix, but I can't figure
it out.
I have created a simple bar graph where one bar has a negative dollar
value and the rest have positive vales.
The problem is that I can't figure out how to leave the x axis at $0.00
value where it intersects the Y axis and have the column labels show at
the bottom of the chart.
If that makes no sense please see attached picture!!
If anyone can help I would be much appreciated!!
+-------------------------------------------------------------------+
|Filename: cHARTTTTTTT.JPG |
|Download: http://www.excelbanter.com/attachment.php?attachmentid=116|
+-------------------------------------------------------------------+
--
DALLAS6570