A column chart won't do this justice, but you could try a variation on a
waterfall chart.
http://peltiertech.com/Excel/Charts/...lcrossing.html
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. -
http://PeltierTech.com
_______
"maryj" wrote in message
...
Is there a way to have a stacked column chart show each series but only
have
the total height of the positive numbers would take into account the
negative?
For example:
Q1 - US 59, Asia 45, Europe -30
Q2 - US 45, Asia 50, Europe -25
For Q1 - we would like the positive stack to reach 74 and Q2 - 70. But we
would still like to have it broken down by the individial series.
Thanks!
--
maryj