Hi

Could anybody please assist me with creating and interpreting a "River
Diagram" in Excel. River Diagrams are mentioned in Collison & parcell's book
"Learning to Fly"

help would be appreciated.

Regards
Roland

On Tue, 15 Apr 2008, in microsoft.public.excel.charting,
Roland Wagner said:
Could anybody please assist me with creating and interpreting a "River
Diagram" in Excel.

A bit of googling gets me this page...

http://www.aidscompetence.org/conten...er_diagram.htm

....where it appears that a river diagram is an Excel Stacked Area Chart
type, where the first area is the minimum across all series, and the
second area is the range between minimum and maximum across all series.
Which makes the stacked sum, the maximum. Then a single series is
plotted as a Line Chart type, showing how close it comes to the "banks"
of the river.

You might want to try a parallel coordinates graph instead of, or in
combination with, the river graphic. Here is a good example from Jon
Peltier:

http://peltiertech.com/Excel/Charts/...#ParallelCoord

This gives you the same info, but a bit more richness. It's like it's
showing you the currents in the river as well as just its banks.

--
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.