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. |
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. |
All times are GMT +1. The time now is 04:39 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com