How can I display negative numbers in a floating bar graph?

[Guest]

I have two categories where the minimum value is a negative number. When
Excel graphs these two categories, it starts at zero, rather than the
negative number. I can't figure out how to get Excel to display the numbers
accurately.

 

[Jon Peltier]

Keeping in mind that a floating chart is a stacked chart, follow the procedures on this page:

http://peltiertech.com/Excel/Charts/StackedColumnsAboveAndBelow.html

In short, the bars cannot cross the axis, so you need two series, one for the positive part of a
bar, and another for the negative part.

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