Trendline for months but not YTD

Hi,
I haven't spent a great deal of time on charts.
I have a range of figures for months and also a Year to date average figure.
my question is can I have all these data on the same chart, but add a trend line only for the months.
I have attached a sample workbook with a trend line, but which it to stop at the last month and not include the YTD figure.

Is this possible?

May,

This is only a sample of data, and will have to update it using formula etc to get ranges or via VBA.
But for now just trying to find out if this is possible? and if so how?

cheers

I don't use the chart trendlines much (preferring to perform regressions directly in the spreadsheet). From what I know of them, they cannot be configured to "ignore" data points that are part of the series they are based on. This means, to get a chart trendline to ignore a data point, you have to remove the data point from the data series. When I do it, that means having two data series in the chart (and two rows of data in the spreadsheet). One row would have your monthly data just like it, then another row that will be for the YTD series.

Please Login or Register  to view this content.

You lost me on the code tags part.
But I think I got it.

2 series of data
All = Jan to YTD
Months = Jan to May

then set trend line for Months data
then set shape fill for Months data as no fill to hide the bars for that data.

Seems to work but this maybe complicated for my project