Thread: waterfall chart
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
panks panks is offline
external usenet poster
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......................