This is what I have now, but am unsure how to populate the Invisible column;
Invisible Spent Percentage
Supplier 1 149 33%
Supplier 2 140 31%
Supplier 3 75 17%
Supplier 4 23 5%
Supplier 5 13 3%
Supplier 6 11 2%
Supplier 7 42 9%
Total 453 100%

Any help would be wonderful.
--
Thanks!

Dee


"Del Cotter" wrote:

On Tue, 24 Jul 2007, in microsoft.public.excel.charting,
dee said:

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

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

Let your "Invisible" column be to the left of the "Spent" column, not to
the right. Also, if you're using the Chart Wizard, omit the "Supplier"
heading to give the wizard a clue where the x-axis column and label row
are (you can put it back after you've built the chart)

This waterfall starts from a maximum and declines toward zero. It looks
fine to me, but if that's not the way you want it, calculate the
cumulative invisible from 0 at the top to 411 at the bottom, instead of
304 at the top and 0 at the bottom.

Select the word "Invisible" in the legend and press delete to get rid of
it (or just delete the whole legend)

For labels, create a third, invisible column (this time to the right),
make the values be something constant like 25 or 50. Give it data labels
and format it to be invisible, so the data labels are sitting on top of
the waterfall bars. Then (because you're short on time to learn new
techniques, and there are only seven data points here) I suggest you
just *manually* edit those data labels to say what you want them to say.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.