Thanks for your reply.

Yeah, but I was hoping to keep the x-axis in the middle of the screen.
Otherwise, as you say, the graph look strange when the bars come up from the
bottom of the screen. It loses the whole "positive/negative" effect I was
going for.


"Jon Peltier" wrote:

You have to move the category axis to the bottom. Do this by double
clicking the other axis, the Value axis, and changing the Crosses At
setting. There's no Crosses At Minimum setting, but I've found that I
can enter a ridiculously low value for Crosses At, way below any minimum
that chart will encounter, and the axis will always cross at whatever
minimum appears on the scale.

However, this is likely to mess up your columns, which Excel likes to
start at the axis. So your bars will go from the bottom of the chart up
to the value, even if the value is negative.

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


J. McAdams wrote:

I have a bar graph with both negative and positive values. I found out how
to move the category labels from the middle to the bottom, but I can't seem
to figure out how to move the tick marks from the middle to the bottom (next
to the labels).

Any suggestions?