Special Graph (Name & how-to)

[JPetrilla]

Hello,

I am doing some predictive analysis and would like to show them the range of values graphically. I have found an example graph here and would like to produce something similar. I however do not know the name of this type of graph (if there is one), and I did not see anything similar in Excel 2010. Any Information anybody can provide would be awesome.

Thanks!

 

[RickXL]

Hi,

A Stacked Area Chart is quite close. Could you use that?

You will need to subtract some columns from each other because the Area Chart will accumulate all the values.
The other slight problem might be that you might need to plot the data against an X value and not an evenly spaced Category value.

To see some charts that go the extra step look at Jon Peltier's site: Fill Under or Between Series in an Excel XY Chart - Peltier Tech Blog


Regards,

 

[JPetrilla]

That looks like an excellent start, and I think I can do something with that link.

Thanks!

 

[RickXL]

You're welcome.

Jon Peltier's site has lots of neat ways to chart in Excel. Well worth a look.

Regards,