Tom -

Post back if you need more that this:

http://peltiertech.com/Excel/Charts/Waterfall.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


"mr tom" <mr-tom at mr-tom.co.uk.(donotspam) wrote in message
...
I've come across waterfall charts (and read the various postings on this
forum, and the links to sites that tell you how to make them in excel)

So far so good.

The charts are great for clearly showing a single change (either a plus or
a
minus), and cope with occasions where plusses and minuses are shown on the
same column (the next column starts in the right place).

What they don't show in those circumstances is the aggregate value (i.e.
plus 3000, minus 2000, aggregate is 1000 (3000-2000!), so would ideally
show
as 1000 greater than the invisible.

Hope this makes sense.

Any ideas on how this can easily be achieved? (Without VBA as I'd like it
to keep up with changing data)

Ideally, I'd then simply show the aggregate section as a waterfall column,
but the plusses and minuses sticking out like stock market high and low
markers (whiskers).

Am I going too far, or is there any reasonably easily mantainable way of
building this in excel?

Many thanks in advance for any help you can provide.

Cheers,

Tom.