LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 7
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
two questions, Yes/No form control, and how did they create this adjustable area on the sheet... Kelvin[_2_] Excel Discussion (Misc queries) 3 November 29th 07 05:49 PM
two questions, Yes/No form control, and how did they create this adjustable area on the sheet... Kelvin[_2_] Excel Worksheet Functions 3 November 29th 07 05:49 PM
Use values instead of labels on X-axis in Area/Stacked Area Charts Ryan Charts and Charting in Excel 1 November 21st 06 04:14 PM
Pivot Charts - 2 questions kkexcel Charts and Charting in Excel 0 October 16th 05 07:28 AM
Gridlines on Area/Stacked Area charts AgileDarrell Charts and Charting in Excel 1 August 6th 05 12:04 AM


All times are GMT +1. The time now is 11:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"