2 questions about area charts

[gak27]

Greetings!

1) I would like to create a chart where the area between two sets of data
(two curves showing pressure vs. flow, etc.) is shaded, indicating the region
of operation. How do I do this? I know Excel is rather limited in its
plotting ability but I would think that when using an area plot you would
have the option of setting the lower bound as another set of data, rather
than only using the X-axis. I can "force" it to give me what I want by
having overlapping areas and changing the data range formatting, but it's
hardly efficient.

2) How can I have the gridlines show up in front of the data sets? If I am
doing what I described above, I have to leave the shading at 100% and the
gridlines are hidden behind the data. Short of (again) "forcing the issue"
by artificially creating gridlines with fake data, how do I do this?

Greg

 

[Jon Peltier]

1. See this technique:
http://peltiertech.com/Excel/Charts/XYAreaChart2.html

2. Gridlines appear under just about any other chart element. To get them to
appear in front of an area chart series, you could use this approach:
http://peltiertech.com/Excel/Charts/ArbitraryGridlines.html
http://peltiertech.com/Excel/Charts/ArbGridLabel.html

- Jon

 

[gak27]

Thanks Jon! Your first technique is essentially what I wound up doing...