How do I shade in part of a graph?

G

Guest

I am trying to graph an inequality, and to do so I need to shade just a
specific part of the graph above the line.
 
A

Andy Pope

Hi,

You can use additional series to provide the shading, which combination
of chart styles you use depends on the type of line and shade.

With a flat line you could use columns as in this example. In your case
the lower parts of the columns would have no fill pattern.
http://peltiertech.com/Excel/Charts/ColoredQuadrantBackground.html

For more complex lines you can use area charts
http://www.andypope.info/ngs/ng21.htm

And for really complex shape you may need to resort to a VBA solution.
http://peltiertech.com/Excel/Charts/VBAdraw.html

Cheers
Andy
 
M

Marie B

Hi,

Is there a trick to using this technique for shading part of the plot area
for a bar chart? I've had a couple of goes using the info from the link you
provided for line graphs, but had no luck so far.

My chart has 20-ish bars, with a y-axis that's 0-100% in 10% intervals. How
can I shade the 40-70% plot area? Got the feeling I might be missing
something obvious...

Many thanks,

Marie B
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create a solution region on a chart 3
How can I shade one half of a graph? 1
Line graphs; excel 2007 1
Graph formatting 1
Trying to color every other X axis interval... 6
Template for graphing algebra inequalities and easy to shade the . 1
How do i show the gap between two lines of a chart 4
Shading on a scatter graph 1

Top