#1   Report Post  
Old October 22nd 09, 07:30 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2008
Posts: 4
Default waterfall chart

I want to create a waterfall chart wherein X axis is a time scale and Y axis
is % reduction in defects. there are say 50 initiatives which will reduce
over time of 2 years. the process will improve from 80% defects to say 5%
during this period. I want to create waterfall chart so that it will show
gradual reduction from 80% to 5% due to implementation of these initiatives.
The data is sorted with time line for implementation. so first bar will be of
initiative A and % improvement or reduction related with it and it will end
where the implementation date is. the second bar should start at this point
and have height equal to improvement potential and length upto its
implementation date. the data looks like this.

Initiative % time line
A 1.2 2nd Jan 2010
B 0.44 5th Feb 2010
C 4.2 4th April 2010
D 0.25 4th April 2010......................

  #2   Report Post  
Old July 20th 21, 09:52 AM
Member
 
First recorded activity by ExcelBanter: Jun 2021
Posts: 47
Default Waterfall Chart in Excel

A Waterfall chart in Excel is a chart showing how a change in positive and negative amounts affects the total amount. The positive and negative amounts can be based on a period of time (values in and out by quarter, yearly) or based on categories (per revenue source, per segment, per region, etc.) Excel Waterfall charts are also used to display the results of a financial model as it effectively illustrates the incremental impact of each period of time or category.

Just check the site above for more info, and I'm sure you'll know what to do! Good luck!


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
waterfall chart panks Charts and Charting in Excel 1 October 21st 09 11:19 PM
Pls Hlp - Urgent. Waterfall Chart dee Charts and Charting in Excel 0 July 25th 07 02:50 AM
Waterfall Chart Bogdan Vasile Charts and Charting in Excel 1 December 18th 06 09:41 PM
Waterfall chart add-ins? Miles Charts and Charting in Excel 4 July 27th 05 01:41 PM
waterfall chart ... once again ... SIGE Charts and Charting in Excel 9 May 1st 05 03:28 AM


All times are GMT +1. The time now is 11:36 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017