change color of curve line as time changes

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
 
B

Bernard Liengme

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

changing area color based on line value 2
Change color of point in series based on date 1
How do I change the color of ONE line on the y-axis in a chart? 1
Line fill graph. 2
change series or line color in excel 2007 vba 4
Hide data points prior to a certain date 1
Excel 2007 Line Chart with Markers 1
Help with Excel 2007 curve interpolation 1

Top