Hi,

To do this without code you can use 2 data series to give the appearance
of a single line.
In this previous example I posted the future data was a dotted line but
you can just change the formatting to another colour.
http://www.andypope.info/ngs/ng45.htm

Cheers
Andy

Sarah wrote:
Hi there
I have a single line chart, with dates on the X axis. After a certain date,
I would like the line to be a different color. Is this possible? Without
having to edit the color of each datapoint? And when I add new data, it
should appear in that same second color. Thanks!

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info