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?
Bookmarks