Limit trend line to last 12 records
 

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

Limit trend line to last 12 records
 

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

wrote:

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