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