2 questions about area charts
 

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

2 questions about area charts
 

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" wrote in message
...
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

2 questions about area charts
 

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" wrote in message
...
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