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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|