#1   Report Post  
Kirsten
 
Posts: n/a
Default Bar Charts

I have a bar chart that has all the information on it I need. I need to take
the information and build it on top of each other (i.e. 10 is the first value
and the second...need to show the first to 10 and the second from 10-20).
But, the last bar can't be a part of the build. The last value is the total
of them all. Is there a way to do this?
  #2   Report Post  
Andy Pope
 
Posts: n/a
Default

Sounds like you are describing a waterfall chart.

Here are some resources.
http://peltiertech.com/Excel/Charts/Waterfall.html
http://tushar-mehta.com/excel/charts...fall/index.htm
http://edferrero.m6.net/Charting.aspx

Cheers
Andy

Kirsten wrote:
I have a bar chart that has all the information on it I need. I need to take
the information and build it on top of each other (i.e. 10 is the first value
and the second...need to show the first to 10 and the second from 10-20).
But, the last bar can't be a part of the build. The last value is the total
of them all. Is there a way to do this?


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Charts won't update pwermuth Charts and Charting in Excel 8 July 15th 05 07:32 PM
Excel Charts Linked to Spreadsheets Rich Charts and Charting in Excel 1 July 4th 05 04:36 PM
linkingof charts in worksheets to cells steve Excel Discussion (Misc queries) 0 May 6th 05 01:44 AM
Working with Charts J. Stone Excel Discussion (Misc queries) 1 April 6th 05 09:06 AM
Can't create dynamic charts Brian Sells Charts and Charting in Excel 7 March 22nd 05 04:23 AM


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

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

About Us

"It's about Microsoft Excel"