#1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 4
Default waterfall chart

I want to create waterfall chart, where the x axis is time scale. and Y axis
is % reduction of defects due to different improvment programs. there are
approximately 50 improvement programs. and the time spread for implementation
of those is approximately 2 yrs. I want to track it in waterfall way so that
as time progresses I can see improvement by a program. the data is sorted
with implementation date in asending order and looks like
program name % improvement time line for implementation.
A 3 4th Jan
2010
B 0.34 6th Feb
2010
C 1.03 24th
march 2010 etc..
I will start the chart with say 60% defects. and gradually reach to 2% by
implementaion of each program. so each colum will be having height equal to %
improvement. the length of bar is also a problem since the division on time
scale is not consistent so the chart looks like having breaks in continuty.
since in week there will be 2 prorams implementing and for next 4 weeks there
wont be any.I would like to see start point of 2nd(B) program mathcing with
end of 1st program (A) so I can see waterfall chart and see it with time
scale as well as intiative name.
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 461
Default waterfall chart

What you're describing sounds like a gantt chart.

Gantt Charts in Microsoft Excel
http://pubs.logicalexpressions.com/P...cle.asp?ID=343

Advanced Gantt Charts in Microsoft Excel
http://peltiertech.com/Excel/Charts/GanttChart.html

I would think a regular old line chart would be best. Date vs. %
Defects. Do you expect defects to remain constant between changes?


- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



panks wrote:
I want to create waterfall chart, where the x axis is time scale. and Y axis
is % reduction of defects due to different improvment programs. there are
approximately 50 improvement programs. and the time spread for implementation
of those is approximately 2 yrs. I want to track it in waterfall way so that
as time progresses I can see improvement by a program. the data is sorted
with implementation date in asending order and looks like
program name % improvement time line for implementation.
A 3 4th Jan
2010
B 0.34 6th Feb
2010
C 1.03 24th
march 2010 etc..
I will start the chart with say 60% defects. and gradually reach to 2% by
implementaion of each program. so each colum will be having height equal to %
improvement. the length of bar is also a problem since the division on time
scale is not consistent so the chart looks like having breaks in continuty.
since in week there will be 2 prorams implementing and for next 4 weeks there
wont be any.I would like to see start point of 2nd(B) program mathcing with
end of 1st program (A) so I can see waterfall chart and see it with time
scale as well as intiative name.

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
Creating a waterfall chart Joe L Excel Discussion (Misc queries) 1 August 14th 07 09:51 PM
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
negative waterfall chart Pablo Charts and Charting in Excel 3 January 27th 05 09:30 PM


All times are GMT +1. The time now is 12:21 PM.

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

About Us

"It's about Microsoft Excel"