How do I show negative numbers on a stacked graph

[Guest]

I am trying to develop a stacked graph that has a data string with negative
numbers. I can set the Y(Z) axis to show negative numbers but the data plots
as positive. IE. Data set may be -10,000 +10,000 12,000. The data plots
all numbers as a positive. Why, and how can I get the first number to plot
below 0. Thank you.

 

[Barb Reinhardt]

Check out

http://www.peltiertech.com/Excel/Charts/chartmisc.html#StakAboveBelow

by Jon Peltier.

 

[Guest]

I should have been more descriptive in my original post. I can do what you
sugest if I was using a stacked BAR chart. I am using a stacked AREA plot. I
tried using your data on my chart and get the sames results : ie. no data
below 0.

 

[Guest]

jmz,

Hopefully this area charting example might help. Please see Jon Peltier's
comment attached to the example too.

http://www.pdbook.com/index.php/excel/area_chart_that_changes_colors_crossing_zero/