View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Saran Saran is offline
external usenet poster
 
Posts: 18
Default 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