Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Stack bar charts with positive and negative numbers
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel, change column of negative numbers to positive numbers? | New Users to Excel | |||
Excel 2002 : Convert Positive Numbers to Negative Numbers ? | Excel Discussion (Misc queries) | |||
change 2000 cells (negative numbers) into positive numbers | Excel Worksheet Functions | |||
convert negative numbers to positive numbers and vice versa | Excel Worksheet Functions | |||
separate colors for positive and negative bars in bar charts? | Charts and Charting in Excel |