Excel trending

I have a 'totals' sheet and to the right individual sheets with stat reports for matches over the past several weeks.
What I'd like to produce is a trend report that takes the 2nd sheet through the last sheet and shows for every statistic, how each stat has improved (or not).
Hoping there's an easier way than the manual method I'm aware of...
LVL 67
sirbountyAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

xtermieCommented:
can you please post a sample of the data?
sirbountyAuthor Commented:
Here's one sheet (saved as csv)

jersey,MatchGamesPlayed,TotalServes,ServingAces,ServingErrors,ServingPoints,AttacksAttempts,AttacksKills,AttacksErrors,ServingReceivedSuccess,ServingReceivedErrors,BlocksSolo,BlocksAssists,BlocksErrors,BallHandlingAttempt,Assists,AssistsErrors,Digs,DigsErrors
1,5,26,4,2,4,2,0,2,34,6,0,0,0,1,0,1,10,2
4,5,8,1,2,1,1,0,1,16,6,0,0,0,0,0,0,12,1
6,1,0,0,0,0,3,0,1,2,1,0,0,0,0,0,0,2,0
7,5,12,2,0,2,18,5,4,6,0,1,1,0,0,0,0,3,1
8,5,19,1,3,1,3,0,2,0,0,0,0,1,32,16,16,7,2
9,5,12,2,2,2,0,0,0,5,2,0,0,0,1,0,1,5,2
10,5,5,0,0,0,13,4,2,3,1,1,0,0,0,0,0,2,1
12,3,0,0,0,0,6,1,1,0,0,0,2,1,0,0,0,2,0
13,3,6,0,0,0,0,0,0,4,1,0,0,0,0,0,0,6,1
15,1,0,0,0,0,7,1,1,1,0,0,1,0,0,0,0,0,0
16,5,0,0,0,0,13,4,1,0,1,1,2,0,0,0,0,0,0
17,4,6,0,0,0,12,4,4,1,1,0,0,2,1,0,1,4,1
22,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
xtermieCommented:
You can try and use the TREND function of excel which
Returns values along a linear trend. Fits a straight line (using the method of least squares) to the arrays known_y's and known_x's. Returns the y-values along that line for the array of new_x's that you specify.

Just remember that the TREND function is an array function which means once you input all the variables and references you need to press CTRL+SHIFT+Enter to enter it as an array formula.
sirbountyAuthor Commented:
I don't believe that's what I was looking for - I tried it but it seemed to only give me a single number.
I ended up titling my totals sheet's column headers with the other sheets exact names and using the
Indirect function to grab the name/value from the corresponding sheet.
I had to manually increment the row portion, unfortunately.  And then I used the Excel charting trend line feature to graphically represent the trend.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
sirbountyAuthor Commented:
Manual solution, rather than the automated one that I wanted, but it works.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.