×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Shaded area under a curve
2

Shaded area under a curve

Shaded area under a curve

(OP)
I am currently devising an excel spreadsheet containg a graph of the data, is there a way to shade the area above (or below) the curve in a different colour?

RE: Shaded area under a curve

An area chart (under standard types) may give you what you want.

RE: Shaded area under a curve

I've been wanting to be able to do that for a long time!  Thanks for the great link...  star for Panars

RE: Shaded area under a curve

(OP)
I don't think that an area chart would suit, the problem is that my chart has two curves:
The Y axis shows positive values and negative values. The Y axis runs from -5 to +5 with the x axis starting at zero on the Y axis. X axis values run from 0 to 200. I have plotted two curves - one  is a positive curve and the other a negative curve. These two curves start at 0,0 and diverge as X increases. I want to shade the areas outside the part of the chart contained by the two curves.
These two curves show the limits of acceptability for a calibration sequence that will be plotted manually on a printed version of the chart. I want to show graphically that if any (manually) plotted point is in the area outside the two curves then that value will show an unacceptable condition.

RE: Shaded area under a curve

The standard Excel area chart won't work, but check out the website that Panars posted--it shows how to fake this for an X-Y plot.  The page for doing area between two curves is here:
http://peltiertech.com/Excel/Charts/XYAreaChart2.html
It looks like it's actually easier to show the area outside the curves than the area between them.

Hg

Eng-Tips policies:  FAQ731-376

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources