Thread: One Line Graph with 2 colours

I have data as follows:

From July to Oct, I have actual data and from Nov to Jun, I have forecast data. I want one line graph which shows one colour for period from July to Oct and other colour for the period from Nov to Jun.

Is there any way I can do it?

Plot as two series?

You could change the segment colors manually, or write code to do so -- one tedious, one needlessly complicated with side effects, IMO, compared to plotting two series with dynamic ranges that can change automatically. But, hey ...

Here is an example of what you describe.
http://www.andypope.info/ngs/ng45.htm

As shg points out using 2 series to plot the format variation is the simplest approach.