View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default 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