A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Charts and Charting in Excel
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Stack bar charts with positive and negative numbers



 
 
Thread Tools Display Modes
  #1  
Old March 9th 10, 10:19 PM posted to microsoft.public.excel.charting
Jeannine
external usenet poster
 
Posts: 6
Default 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?
Ads
  #2  
Old March 9th 10, 11:24 PM posted to microsoft.public.excel.charting
Ed Ferrero[_3_]
external usenet poster
 
Posts: 108
Default Stack bar charts with positive and negative numbers

Hi Jeannine,

It sounds like you want a waterfall chart.

Go over to Jon Peltier's site and download his utility
http://peltiertech.com/Excel/Charts/...ive.html#Falls

Or take a look at my own, less conventional, way to do this at
http://edferrero.com/ExcelCharts/tabid/102/Default.aspx
(look for 'Waterfall Chart')

Ed Ferrero
www.edferrero.com


  #3  
Old March 10th 10, 05:43 PM posted to microsoft.public.excel.charting
Herbert Seidenberg
external usenet poster
 
Posts: 1,180
Default Stack bar charts with positive and negative numbers

Excel 2007 Chart
Stacked columns, with net total.
Superimposed charts.
http://www.mediafire.com/file/kdmmmnmjymu/03_10_10.xlsx
Pdf preview:
http://www.mediafire.com/file/tnnzdgx2znu/03_10_10.pdf
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel, change column of negative numbers to positive numbers? Nita New Users to Excel 3 November 27th 07 04:54 AM
Excel 2002 : Convert Positive Numbers to Negative Numbers ? Mr. Low Excel Discussion (Misc queries) 2 November 6th 06 03:30 PM
change 2000 cells (negative numbers) into positive numbers lisbern Excel Worksheet Functions 2 August 16th 06 05:54 PM
convert negative numbers to positive numbers and vice versa bill gras Excel Worksheet Functions 4 December 7th 05 01:39 AM
separate colors for positive and negative bars in bar charts? t killion Charts and Charting in Excel 1 August 26th 05 04:55 PM


All times are GMT +1. The time now is 04:23 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Copyright 2004-2014 ExcelBanter.
The comments are property of their posters.