View Single Post
  #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