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
|
|||
|
|||
How do I shade in part of a graph?
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. |
#2
|
|||
|
|||
How do I shade in part of a graph?
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/...ackground.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 reid wrote: 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. |
#3
|
|||
|
|||
How do I shade in part of a graph?
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 "Andy Pope" wrote: 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/...ackground.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 reid wrote: 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. |
#4
|
|||
|
|||
How do I shade in part of a graph?
Hi,
See this, http://peltiertech.com/Excel/ChartsH...orizBands.html Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Marie B" wrote in message ... 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 "Andy Pope" wrote: 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/...ackground.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 reid wrote: 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. |
Thread Tools | |
Display Modes | |
|
|