How can change the color of the data series from one point onwards
 

I am currently using the line chart to project the # of bugs on a daily basis
which go e.g. from 1 Jan to 31 Jan.

I however want to show the Bugs from 1 Jan to 24 Jan (today) in one color
and the remainder of the series in a different color as this would allow me
to easily segregate the actual vs the projected.

Any help is appreciated

How can change the color of the data series from one point onwards
 

The easiest way is to plot them as two series:

Actual Projected
01/01/07 xxxx
01/02/07 xxxx
01/03/07 xxxx
etc
01/24/07 xxxx
01/25/07 xxxx
01/26/07 xxxx
01/27/07 xxxx

Leave all the blanks in place and include them in the chart's source data,
so the series will line up.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Saran" wrote in message
...
I am currently using the line chart to project the # of bugs on a daily
basis
which go e.g. from 1 Jan to 31 Jan.

I however want to show the Bugs from 1 Jan to 24 Jan (today) in one color
and the remainder of the series in a different color as this would allow
me
to easily segregate the actual vs the projected.

Any help is appreciated