RE: Shading only part of the area between the axes in a 2D line graph.

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: John Mansfield (JohnMansfield_at_discussions.microsoft.com)
Date: 02/06/05 

Date: Sun, 6 Feb 2005 09:19:02 -0800

Mzee,

Take a look at Jon's site for some examples:

http://www.peltiertech.com/Excel/Charts/FloatingColumns.html

If this link doesn't fit your needs, be sure to look at Jon's entire site:

http://www.peltiertech.com

If you still can't get the answer, post back to the Excel charting newsgroup
with an example of your data. Sounds like the task shouldn't be too
difficult. 

----
Regards,
John Mansfield
http://www.pdbook.com
"Mzee" wrote:
> I am trying to format a 2D line graph with points that lie either within or 
> outside an upper and a lower limit.
> How do I shade the area between the upper and lower limits a different 
> colour from the rest of the plot area?

Relevant Pages

  • Shading only part of the area between the axes in a 2D line graph.
    ... outside an upper and a lower limit. ... How do I shade the area between the upper and lower limits a different ... colour from the rest of the plot area? ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Programmable Counter
    ... and lower limit, which can be programmed when enable is low. ... upper limit and lower limit? ... limit which is only enabled at the appropriate time when not counting. ...
    (comp.lang.verilog)
  • Re: What if there was no dark matter?
    ...   Bound on the dark matter density in the Solar System ... to see except with really specialized instruments. ... According to the abstract, which is all I could read, this is an upper ... They didn't give a lower limit. ...
    (talk.origins)
  • Re: Creating 2D graphic strip chart with trace wrapping
    ... The dynamic range of some of the data traces is quite large, ... "shoots through" the upper limit, it re-enters from the lower limit. ... somehow possible to reflect the 2D line at the upper and lower bounds, ...
    (comp.graphics.api.opengl)
  • Re: Using CountIf with criteria on another sheet
    ... perfect match. ... >> fall between upper and lower limit values on another sheet? ... >> Where a1:z1 are values to be compared against the upper and lower limit ... >> then counted if they meet the criteria ...
    (microsoft.public.excel.worksheet.functions)