Posted to microsoft.public.excel.programming

[email protected] DonFlak@gmail.com is offline

external usenet poster

Posts: 41

Trendline on only part of the data.

I have a chart with three years worth of weekly data points, 2 prior
years and the current year so I currently have approx. 128 data
points. I added a trend line. Again no problem. Know my boss wants
the trend line on only the current year or the last 24 data points as
it were.

Is there any way to trend only a portion of the data?

Thanks in advance for your assistance.

Don

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
trendline for part of data	terry	Charts and Charting in Excel	6	April 21st 23 06:10 PM
Trendline for a part of a data set ?	Muelleimer	Excel Discussion (Misc queries)	2	September 14th 07 01:12 PM
How do I set a trendline for only say the first 25% of the data s.	qwerty	Charts and Charting in Excel	2	April 11th 07 05:42 PM
Trendline Data	Chip Pearson	Excel Programming	1	August 19th 04 08:18 PM
Trendline Data	Tom Ogilvy	Excel Programming	0	August 19th 04 07:30 PM

All times are GMT +1. The time now is 08:00 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us