change color of curve line as time changes

  • Thread starter Thread starter cliffordjf
  • Start date Start date
C

cliffordjf

I have a series of values associated with dates; the values in the past are
fact, the values in the future are estimates. When I graph the data, the
line is all the same color throughout the series. Is there a way to have the
color of the line change as the dates become past, rather than future....

in other words, the line is black through todays data, but turns to red from
tomorrow on, then as tomorrows comes, that part of the line turns from red to
black...

thanx

cjf
 
You will need two series. Suppose dates are in A2:A100, values to plot in
B2:B100
In C1 use =IF(A1<=TODAY(),B2,NA())
In D1 use =IF(A1>TODAY(),B2,NA())
Copy both down their columns
Quickest way is to select all data and make your chart, then delete the line
in the cart for column B (or use CTRL to select A, C and D)

Visit Jon Peltier and look at his 'conditional chart' material
http://peltiertech.com/Excel/Charts/ConditionalChart1.html

best wishes
 
Back
Top