100% stacked column chart with negative numbers

How do you create a 100% stacked column chart with negative numbers? After I
create the chart it only goes up to 80%

How do you want it to show? The total length (including negative amount) of
the column should equal 100%. (make sure you haven't limited the scale of
your y-axis) What the graph is showing you is that the positive numbers do
not account for 100% of your data.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Stuck" wrote:

How do you create a 100% stacked column chart with negative numbers? After I
create the chart it only goes up to 80%

By definition you cannot (or at least should not) have negative numbers in
this type of chart. It's like trying to show negative numbers in a pie
chart. You could expand the Y axis of your chart so it shows negative
numbers, and the chart will show X% negative and (100-X)% positive. In your
case, 100% doesn't go from 0% to 100%, it goes from -20% to 80%.

Without knowing more about your data, it's anyone's guess how better to show
the data. Perhaps a clustered chart.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"Stuck" wrote in message
news
How do you create a 100% stacked column chart with negative numbers?
After I
create the chart it only goes up to 80%