Limit trend line to last 12 records

[Guest]

Hi,
I have a bar chart which grows over time, but i only want the trend line to
reflect the last 12 records...

Is this possible?
Matt

 

[Jerry W. Lewis]

Use a second series that only contains the last 12 records, and fit the
trendline to that. You could use an if formula that that returns #N/A
for all but the last 12 records.

Jerry