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
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
[email protected] 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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks