2 colors in one line

[vivi]

Hi there I am putting a chart together to show the performance trend for
Budget, Actual and Forecast

Budget will not change therefore will be one color
However, I would like to combined the Actual and Forecast together. So i
have the actual dor every months to current month and all future months are
figures from forecast.

I have created a table for the graph data and the user toggles to the month
required as "Current month" it will fill up all the data up to the month
required and taking the forecast numbers for another tab.

Any ideas how i can show the forecast months in another color automatically?

Thanks a lot

Vivi

 

[Bernard Liengme]

Use separate columns with =NA() in the empty cells
best wishes

 

[Andy Pope]

Hi,

Maybe something like this
http://www.andypope.info/ngs/ng45.htm

Cheers
Andy