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
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.