Hi Jon,

I have posted tonight a couple of times re waterfall charts. I am blonde
and exhausted, so maybe I don't get it...

I have:

Supplier Spent
Supplier1 149
Supplier2 140
Supplier3 75
Supplier4 23
Supplier5 13
Supplier6 11
Supplier7 42
Total 453

and wish to create a chart that shows the first value (149) as a column
beginning at 0. Then, the second column (140) beginning just above the first
column and so on. At the far right, I wish to see the total column.

I tried this (which I found at a Web site):

Supplier Spent Invisible
Supplier1 149 304
Supplier2 140 164
Supplier3 75 89
Supplier4 23 66
Supplier5 13 53
Supplier6 11 42
Supplier7 42 0
Total 453

But it didn't work... just kept my columns all starting at 0...

What am I missing?

I was also wondering if I could display both the value and the percentage of
the total above each bar without using an add-in.

Thanks so very much for any help you can provide.


--
Thanks!

Dee