If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
shaded region on a graph
Hello to all
I have three data series. One representing an upper specified limit, one representing a lower specified limit, and the third being the actual results taken off a sample being tested. I would like to shade the area between the upper and lower limits, and then have the line depicting the actual recorded values placed on the chart. This explanation makes sense to me... but I'm accustomed to being told I live on a planet all alone... so I'll try to explain another way... I'm have results from a sample. The acceptability of the sample is based on whether the results fall within the specified limits. As such, I want to graphically display 1. A line graph for the upper limit 2. A line graph for the lower limit 3. A shaded region for the acceptable area between the upper and lower limits 4. A line graph of the actual results found Thanks in advance for any help /kevin --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.521 / Virus Database: 319 - Release Date: 23-Sep-2003 |
#2
|
|||
|
|||
shaded region on a graph
-----Original Message----- Hello to all I have three data series. One representing an upper specified limit, one representing a lower specified limit, and the third being the actual results taken off a sample being tested. I would like to shade the area between the upper and lower limits, and then have the line depicting the actual recorded values placed on the chart. Sounds like you want to start with a stacked area chart for the upper and lower limits, then format the lower data series and remove its colour. Then add the actual results as a line graph, (edit paste special [?] and then format the series and change it to be plotted on the secondary axis). (PS Nice to know someone else has trouble explaining things simply.) H |
#3
|
|||
|
|||
shaded region on a graph
Kevin -
Welcome to my planet! This page on my web site describes how to get a vertical band on a chart. You can probably figure out how to adjust it to make a horizontal band: http://www.geocities.com/jonpeltier/...ticalBand.html If not, post back with what progress you made, and where you got stuck. - Jon ------- Jon Peltier, Microsoft Excel MVP http://www.geocities.com/jonpeltier/Excel/index.html _______ Kevin Wooding wrote: Hello to all I have three data series. One representing an upper specified limit, one representing a lower specified limit, and the third being the actual results taken off a sample being tested. I would like to shade the area between the upper and lower limits, and then have the line depicting the actual recorded values placed on the chart. This explanation makes sense to me... but I'm accustomed to being told I live on a planet all alone... so I'll try to explain another way... I'm have results from a sample. The acceptability of the sample is based on whether the results fall within the specified limits. As such, I want to graphically display 1. A line graph for the upper limit 2. A line graph for the lower limit 3. A shaded region for the acceptable area between the upper and lower limits 4. A line graph of the actual results found Thanks in advance for any help /kevin --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.521 / Virus Database: 319 - Release Date: 23-Sep-2003 |
Thread Tools | |
Display Modes | |
|
|