Hi Ed,

You are my life saver. Thank you very much for the help.

Tim.

"Ed Ferrero" wrote:

Hi Tim,

You are describing a waterfall chart.
I have a sample here http://edferrero.m6.net/charting.aspx
but you might find Jon Peltier's example at
http://peltiertech.com/Excel/Charts/Waterfall.html
a bit easier to follow (and less buggy :^)

Ed Ferrero
http://edferrero.m6.net


Hi folks,

I spent a lot of time on this project but I couldn't figure out the
solution
for it? Is it possible to be done? Please help.... This is an urgent
and
very important to me.

Here is my data:

M1 M2 M3 M4
100 10 -15 95

The M2 value is not 10. It is an increase 10 from M1. The M3 value is a
decrease 15 from M2. The M4 value is equal to 95.

I need a column chart:

Column1 shows M1 value 100.

Column2 shows M2 value 10 but not from 0 to 10. It is from 100 to 110
with
a horizontal line connect to column1. In other word, the ending point of
column1(100) has a line connect to the starting point of column2(100).

Column3 shows a drop from 110 to 95. There also has a horizontal line
between the ending point of column2 and the starting point of column3.

Column4 shows the true value of 95. Its starting point also has a
horizontal line connect back to the ending point of column3.

Please show me how to do it? Any help will be appreciated.

Thanks in advance.

Tim.