How else do you show the total amount when there are positive and negative
components to the total? Do you shrink the positives by a proportion to make
up the total? That distorts the data and doesn't show the negative data. Do
you show the positives at full size but offset the bottom of the stack to
where the negative component brings you? That hides the negative data. How
do you show the actual total without distorting and/or hiding data?

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


"maryj" wrote in message
...
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