Line Graph and Shading

[Jim]

Here is what I would like to do; I�d 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 I�d like to highlight as
the �Projected Savings�.

Now maybe a line graph isn�t what I�m 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, I�d 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]

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; I’d 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 I’d like to highlight as
> the “Projected Savings”.
>
> Now maybe a line graph isn’t what I’m 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, I’d 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

[Jim]

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; I’d 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 I’d like to highlight as
> > the “Projected Savings”.
> >
> > Now maybe a line graph isn’t what I’m 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, I’d 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
>