Me again with more charting questions!

I have a column chart showing 6 months actual sales for a product followed
by the next two months forecast figures.

I want to show a trendline based only on the 6 months actual sales i.e. the
trend should not take into account our forecast. The trendline I normally
use is a linear trend.

Is there a way to do this?