Stack bar charts with positive and negative numbers

J

Jeannine

I am preparing a comparative stack bar graph in which both sets of data have
positive and negative numbers. I would like the sum of the each data set
(both positive and negative) to be reflected in the Y axis values. For
example, I am graphing the gross profit of various components. The total of
that gross profit in year one is $1,000. The components values are 500, 700
and -200. Is there a way to graph that in Excell 2007? The total gross
profit in year two is 1,500. The component values are 1000, 700 and -200.
Is there a way to grah this so that the total values on the Y axis reflect
1,000 and 1,500?
 

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.

Ask a Question

Similar Threads

Graph Negative Values as Positive Values 0
Negative Values in Stacked Bar Charts 3
Excel chart with positive and negative values 1
2 axis chart stacked bar next to bar with line 1
Bar charts with negative values and label position 3
showing negative values as positive in a bar graph 4
How do I show negative numbers on a stacked graph 3
Labels on Chart with Negative Value Axis 6

Top