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 the space beween lines in a chart
I want to shade the area between 2 line plots i.e maximum curve and minimum
curve. Everything in between the two lines is valid. thus the area needs to be shaded to create an envelop effect. anyone ever done this before |
#2
|
|||
|
|||
how do i shade the space beween lines in a chart
Plot the lower threshold line and the *difference* between the lower and
the upper thresholds. Move each of these series to the secondary axis, change each to stacked area type of chart, add a secondary x axis (with the chart selected, select Chart | Chart Options... | Axes tab | check on the 'Secondary x axis'), format the secondary x-axis to *not* check 'Value (Y) axis crosses between categories', and format as desired. -- Regards, Tushar Mehta www.tushar-mehta.com Multi-disciplinary business expertise + Technology skills = Optimal solution to your business problem Recipient Microsoft MVP award 2000-2005 In article , =?Utf- 8?B?Si5TLiBSeWJhaywgUC5Fbmcu?= J.S. Rybak, P.Eng. @discussions.microsoft.com says... I want to shade the area between 2 line plots i.e maximum curve and minimum curve. Everything in between the two lines is valid. thus the area needs to be shaded to create an envelop effect. anyone ever done this before |
#3
|
|||
|
|||
how do i shade the space beween lines in a chart
New article this month:
http://pubs.logicalexpressions.com/P...cle.asp?ID=590 - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "J.S. Rybak, P.Eng." J.S. Rybak, wrote in message ... I want to shade the area between 2 line plots i.e maximum curve and minimum curve. Everything in between the two lines is valid. thus the area needs to be shaded to create an envelop effect. anyone ever done this before |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to get rid of 1.5 line space? The first three lines are 1.5. | Chris | General Discussion | 2 | June 15th, 2005 07:53 PM |
Missing lines in chart w/x-axis with months 1-24... | DendWrite | Charts and Charting | 2 | May 10th, 2005 09:04 PM |
Urgent Chart Questions | Brent E | General Discussion | 0 | May 9th, 2005 11:01 PM |
Lines no longer snap properly to grid. They snap to open space. | Bob the builder | General Discussion | 0 | January 27th, 2005 03:01 PM |
Styles for chart | Debra Dalgleish | Charts and Charting | 1 | October 3rd, 2003 12:27 PM |