Limit trend line to last 12 records

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
Back
Top