Thread: Line Graph and Shading

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

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

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
>