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%

100% stacked column chart with negative numbers
 

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%

100% stacked column chart with negative numbers
 

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
...
How do you create a 100% stacked column chart with negative numbers?
After I
create the chart it only goes up to 80%