Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Shading Between the Lines
Hello all. I am decently knowledgeable when it comes to Microsoft Excel, but
I have had the hardest time attempting to do what my Boss requested. I have made the following chart: http://home.gci.net/~clogic/Timing%20Curve.xls . It was destined to look like this example, though I can not figure out how to make the shading in between the lines for the life of me. Example: http://home.gci.net/~clogic/scan.jpg Any Ideas? I would have already used Photoshop to make the shades, but My Boss wants to be able to change the text and the lines effortlessly. Please include an explanation in your response, as I will have to repeat this on three other graphs. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Shading Between the Lines
Hi,
The normal work around would be to use a duplicate series plotted as an area chart. The problem with this approach and your chart is your have used the smooth line option. To make the area smooth you would need to calculate multiple points between each of your known data points. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Fodor" wrote in message ... Hello all. I am decently knowledgeable when it comes to Microsoft Excel, but I have had the hardest time attempting to do what my Boss requested. I have made the following chart: http://home.gci.net/~clogic/Timing%20Curve.xls . It was destined to look like this example, though I can not figure out how to make the shading in between the lines for the life of me. Example: http://home.gci.net/~clogic/scan.jpg Any Ideas? I would have already used Photoshop to make the shades, but My Boss wants to be able to change the text and the lines effortlessly. Please include an explanation in your response, as I will have to repeat this on three other graphs. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Shading between two lines | Charts and Charting in Excel | |||
Shading between two lines on a chart | Excel Discussion (Misc queries) | |||
Question Variation: Shading a portion of the space between two lines | Charts and Charting in Excel | |||
Shading a portion of the space between two lines | Charts and Charting in Excel | |||
Powerpoint Graph- Shading in between two linear graph lines | Charts and Charting in Excel |