 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Charting / October 2006How to fill or shade space between to trend lines?
Hi, I have an excel diagram showing two trend lines. Ones for the target and one for actual. I would now like to shade the space between those lines in order to highlight the B/W situation. Any idea who do this?  SignatureThorsten Hi, Shading between 2 lines is normally worked around by using dummy series plotted as area chart types. Are those trend lines created using cell formula or adding Trend Lines to existing series? If the later you will first need to create cell formula to plot values for the trend lines. Post back if you need more information. Cheers Andy > Hi, > > I have an excel diagram showing two trend lines. Ones for the target > and one for actual. I would now like to shade the space between those > lines in order to highlight the B/W situation. Any idea who do this? SignatureAndy Pope, Microsoft MVP - Excel http://www.andypope.info Thorsten Wrote: > Hi, > > I have an excel diagram showing two trend lines. One for the target an > one for actual. I would now like to shade the space between those line > in order to highlight the B/W situation. Any idea how to do this? Thanks for the answer Pete but I am still struggling a bit with this. attach an example of the database I meant. Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Target heads 89 85 85 83 83 80 80 80 80 70 70 70 Actual heads 100 100 100 90 90 90 90 85 85 85 85 8 -- Thorsten Pete ?!? Anyway, with you chart that has 2 lines series add 2 more data series based on exactly the same set of data. This will add 2 lines sitting on to of the existing lines. Select 1 of the new lines and change the chart type to area. Repeat for 2nd extra series. You should now have a shaded area below the top line. Double click the area chart series and on the series order tab of the format dialog reverse the order of the 2. You should now have a shade up to the bottom line. Format both areas to have no border and the lower area to have the same fill colour as the plot area. If you want the lines to move away from the edges of the plot area double click the x axis scale and on the scale tab check Value(Y) axis crosses between categories. Here is an example using the technique http://www.andypope.info/ngs/ng21.htm Cheers Andy > Thorsten Wrote: > [quoted text clipped - 12 lines] > Target heads 89 85 85 83 83 80 80 80 80 70 70 70 > Actual heads 100 100 100 90 90 90 90 85 85 85 85 85 SignatureAndy Pope, Microsoft MVP - Excel http://www.andypope.info |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.