Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
Jim
 
Posts: n/a
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope
 
Posts: n/a
Default 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
  #3   Report Post  
Posted to microsoft.public.excel.charting
Jim
 
Posts: n/a
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 01:31 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"