Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Shading a portion of the space between two lines
I need to graph a two lines that intersect. Each line has 13 points
and they intersect at point 6. I only want to shade the area between the lines from points 8-13 (This is where the points between the two groups differ significantly). My points for line 1 a 6, 6, 6, 5, 5, 5, 5, 4, 4, 4, 4, 4, 4 and the points for line 2 are 1, 1, 2, 3, 4, 5, 10, 16, 20, 25, 36, 49, 56. Does anyone have any advice on how to shade just the area between the lines from points 8-13? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Shading a portion of the space between two lines
Adjust the data in the following example so the duplicate values in column D
occur not at the first and last points but at points 8 and 13. http://peltiertech.com/Excel/Charts/XYAreaChart2.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ wrote in message oups.com... I need to graph a two lines that intersect. Each line has 13 points and they intersect at point 6. I only want to shade the area between the lines from points 8-13 (This is where the points between the two groups differ significantly). My points for line 1 a 6, 6, 6, 5, 5, 5, 5, 4, 4, 4, 4, 4, 4 and the points for line 2 are 1, 1, 2, 3, 4, 5, 10, 16, 20, 25, 36, 49, 56. Does anyone have any advice on how to shade just the area between the lines from points 8-13? |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Shading a portion of the space between two lines
Thanks Jon,
I'll give it a shot. Sure is alot to go through to shade a small area! No wonder I couldn't figure it out on my own! Lori Jon Peltier wrote: Adjust the data in the following example so the duplicate values in column D occur not at the first and last points but at points 8 and 13. http://peltiertech.com/Excel/Charts/XYAreaChart2.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ wrote in message oups.com... I need to graph a two lines that intersect. Each line has 13 points and they intersect at point 6. I only want to shade the area between the lines from points 8-13 (This is where the points between the two groups differ significantly). My points for line 1 a 6, 6, 6, 5, 5, 5, 5, 4, 4, 4, 4, 4, 4 and the points for line 2 are 1, 1, 2, 3, 4, 5, 10, 16, 20, 25, 36, 49, 56. Does anyone have any advice on how to shade just the area between the lines from points 8-13? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to fill or shade space between to trend lines? | Charts and Charting in Excel | |||
Conditional Cell Shading (based on the shading of other cells) | Excel Worksheet Functions | |||
Powerpoint Graph- Shading in between two linear graph lines | Charts and Charting in Excel | |||
how do i shade the space beween lines in a chart | Charts and Charting in Excel | |||
shading a rowwhen a time is entered but no shading when 0 is enter | Excel Worksheet Functions |