Thread: Multiple colour line graph

Hi Guys

Is it possible for a single series line graph to have multiple coulours?

I have attached a workbook, showing a chart. I want the line graph to be green from the 10/03/2010 and anything previous to that date should be red.

Hi climaxgp

you need to plot two data series.
The empty cells need to be included in the series. Also, you need the one row overlap for the lines to connect.

Important: empty cells must be plotted as gaps or interpolated. If empty cells are plotted as zeros, the connection between the two series will have spikes to the zero line.

see attached.