Line Graph and Shading
 

Here is what I would like to do; Id like to shade the area following the
crossing of Line1 and Line2 in a different color and highlight and label the
point at which the lines cross. Line1 is €œCurrent Cost€� and Line2 is
€œProjected Cost€�, the area following the crossing Id like to highlight as
the €œProjected Savings€�.

Now maybe a line graph isnt what Im looking for, any other recommendations?

For example; x axis values of 1, 2, 3 and y axis 1-100 step 10 and Line1
values 0, 50, 100, Line2 values 25, 50, 75. From the point at which the
lines cross, value 50, Id like to highlight the between the lines from this
point to the end of the lines and label it €œProjected Savings€�.

Thanks in advance,

Jim

Line Graph and Shading
 

Hi,

This may be what you are looking for.
http://www.andypope.info/ngs/ng21.htm

Cheers
Andy

Jim wrote:
Here is what I would like to do; Id like to shade the area following the
crossing of Line1 and Line2 in a different color and highlight and label the
point at which the lines cross. Line1 is €œCurrent Cost€� and Line2 is
€œProjected Cost€�, the area following the crossing Id like to highlight as
the €œProjected Savings€�.

Now maybe a line graph isnt what Im looking for, any other recommendations?

For example; x axis values of 1, 2, 3 and y axis 1-100 step 10 and Line1
values 0, 50, 100, Line2 values 25, 50, 75. From the point at which the
lines cross, value 50, Id like to highlight the between the lines from this
point to the end of the lines and label it €œProjected Savings€�.

Thanks in advance,

Jim


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Line Graph and Shading
 

Andy,

YES! Thanks alot, this is exactly what I was looking for!

Thanks again,

Jim

"Andy Pope" wrote:

Hi,

This may be what you are looking for.
http://www.andypope.info/ngs/ng21.htm

Cheers
Andy

Jim wrote:
Here is what I would like to do; Id like to shade the area following the
crossing of Line1 and Line2 in a different color and highlight and label the
point at which the lines cross. Line1 is €œCurrent Cost€� and Line2 is
€œProjected Cost€�, the area following the crossing Id like to highlight as
the €œProjected Savings€�.

Now maybe a line graph isnt what Im looking for, any other recommendations?

For example; x axis values of 1, 2, 3 and y axis 1-100 step 10 and Line1
values 0, 50, 100, Line2 values 25, 50, 75. From the point at which the
lines cross, value 50, Id like to highlight the between the lines from this
point to the end of the lines and label it €œProjected Savings€�.

Thanks in advance,

Jim


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info