Limit trend line to last 12 records

M

mstride

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
 
J

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
 
Top