[mso] Trendlines or trends in Charts

From: "McDonald, Christine, Ms, DCAA" <Christine.McDonald@xxxxxxxx>
To: <mso@xxxxxxxxxxxxx>
Date: Fri, 2 Jul 2004 17:48:47 -0500
Content-Type: text/plain;
        charset="us-ascii"
Content-Transfer-Encoding: 7bit
Hi all,

I have a chart with biweekly data for 2002, 2003 and 2004 and a 2004 goal.
I want to use a trendline predict if we will get to our goal for 2004,
based on the pattern of hours per biweekly period that was experienced in
2003.  I can insert a trendline using 2004 data, but it is straight line,
so it doesn't take into account upward or downward trends that we
historically experience during the next few months.  So basically, I want
to take the trendline from 2003 and apply it to the 2004 data, rather than
a straight line prediction based on the historical pattern for 2004.  Said
another way, if we follow the same pattern of hours per period as we did
last year, we will get to our goal.   It may involve some math that I've
been out of school way to long to remember.

Anyway, I hope I explained this well enough that someone can understand
what I need to do.

Thanks,

Christine McDonald
Technical Specialist
Western Regional Office
Information Technology Division (RSA-4)



IMPORTANT: This e-mail, including all attachments, constitute Federal
Government records and property that is intended only for the use of the
individual or entity to which it is addressed.  It also may contain
information that is privileged, confidential, or otherwise protected from
disclosure under applicable law.  If the reader of this e-mail
transmission is not the intended recipient or the employee or agent
responsible for delivering the transmission to the intended recipient, you
are hereby notified that any dissemination, distribution, copying or use
of this e-mail or its contents is strictly prohibited.  If you have
received this e-mail in error, please notify the sender by responding to
the e-mail and then delete the e-mail immediately.





-- Binary/unsupported file stripped by Ecartis --
-- Type: application/x-pkcs7-signature
-- File: smime.p7s


*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, send an email to 
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in 
the subject line.

Or, visit the group's homepage and use the dropdown menu.  This will also allow 
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group, send a 
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with 
instructions.  Once you are a member of the files group, you can go here to 
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
[mso] Trendlines or trends in Charts

Other related posts:
