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

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/...Gridlines.html
http://peltiertech.com/Excel/Charts/ArbGridLabel.html

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


"gak27" <(E-Mail Removed)> wrote in message
news:A8830FFC-4E34-4826-8E3C-(E-Mail Removed)...
> 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

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

"Jon Peltier" wrote:

> 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/...Gridlines.html
> http://peltiertech.com/Excel/Charts/ArbGridLabel.html
>
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> Tutorials and Custom Solutions
> Peltier Technical Services, Inc. - http://PeltierTech.com
> _______
>
>
> "gak27" <(E-Mail Removed)> wrote in message
> news:A8830FFC-4E34-4826-8E3C-(E-Mail Removed)...
> > 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
>
>
>