area graphs in excel

[Guest]

i want to porduce a graph that has an upper and lower quarile figure. I want
these to be block filled and then plot 3 lines against these. is this
possible? for example, i have a % scale on the X axis and can get the lower
quartile figure to block fill, the problem comes when i want to block fill
the upper quartile from it's data figure to the top of the X axis... is this
possible to do?

 

[Jon Peltier]

James -

Block fill the bottom quartile, the middle two quartiles (in a single
series, why not), and the top quartile. Format the top and bottom with
whatever color you want, and hide the middle one with no fill and no
borders.

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

 

[Jon Peltier]

James -

Doesn't matter what the axis scale is. It's up to you to provide data
that makes the dummy series (the area series that produce the background
effects) come out the way you want.

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