View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
DEE DEE is offline
external usenet poster
 
Posts: 250
Default PLS HLP Waterfall doesn't display properly

I am following various instructions for creating a waterfall.

I have supplier names in column A, Values in column B and an additional
column C that will "disappear". I have followed the formula for column C so
that it ends up with a 0 value in the last cell, then created a stacked
column chart.

My bars don't seem to float - they are at the bottom of the chart.

I have tried different ways of rearranging, but to no avail, although I have
been at this for many, many hours and maybe am just exhausted.

I would like my largest segment to appear from 0, then the next largest
value to appear "stacked" above and to the right of this one, and so on.
Then, at the far right of the chart, I would like a column that represents
the total.

I also would like the value, plus the % of the whole, to appear above (and
outside) of each column.

Is this possible?? I have seen it on a hard copy, but am unsure as to how
to create it.

Here is my data:

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

I am under the gun time-wise and any help would be incredibly appreciated.
--
Thanks!

Dee