Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
two questions, Yes/No form control, and how did they create this adjustable area on the sheet... | Excel Discussion (Misc queries) | |||
two questions, Yes/No form control, and how did they create this adjustable area on the sheet... | Excel Worksheet Functions | |||
Use values instead of labels on X-axis in Area/Stacked Area Charts | Charts and Charting in Excel | |||
Pivot Charts - 2 questions | Charts and Charting in Excel | |||
Gridlines on Area/Stacked Area charts | Charts and Charting in Excel |