100% stacked column chart with negative numbers

  • Thread starter Thread starter Stuck
  • Start date Start date
S

Stuck

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.
 
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
 
Back
Top