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?
Last edited by EsKay!; 11-23-2008 at 11:37 PM.
Plot as two series?
Microsoft MVP - Excel
Entia non sunt multiplicanda sine necessitate
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 ...
Microsoft MVP - Excel
Entia non sunt multiplicanda sine necessitate
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks