Thanks Jon, but I don't see how a waterfall chart would help. We don't wan't
the hanging bar effect that a waterfall gives. Can you explain more?
Thanks!
--
maryj
"Jon Peltier" wrote:
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