2 colors in one line

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

Use separate columns with =NA() in the empty cells
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"vivi" wrote in message
...
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

Hi,

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

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"vivi" wrote in message
...
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