Thread: Axis Issues
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default Axis Issues

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