Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Charting / April 2008

Tip: Looking for answers? Try searching our database.

How do I create and interpret a river diagram?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Roland Wagner - 15 Apr 2008 09:39 GMT
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
Del Cotter - 15 Apr 2008 19:34 GMT
>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/content/2.13_river_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/NewStuff.html#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.

Signature

Del Cotter
NB Personal replies to this post will send email to del@branta.demon.co.uk,
   which goes to a spam folder-- please send your email to del3 instead.

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.