trendline equation updates

I am using copying a chart, which has trendlines dispalying the equations, 
from another spreadsheet and updating the chart for the new data.  I noticed 
some of the equations were not right.  Please be noted that these equations 
were formated for text size and colour.   

Could anyone suggest why the equations are not right and is there a way to 
get it right automatically?
0
ST (10)
10/7/2009 6:34:01 PM
excel.charting 18370 articles. 0 followers. Follow

1 Replies
575 Views

Similar Articles

[PageSpeed] 28

ST  -

You may need to provide more details before anyone has suggestions:

(a) What version of Excel? (For example, I mostly use Excel 2003 SP3 and 
Excel 2007 SP2.)

(b) Specifically, how are you "updating the chart for the new data"?

(c) In what way are the results "not right"?

In Excel 2003 SP3, I entered some data, created a Line chart, added a 
trendline, formatted the equation, copied the chart, opened a new workbook, 
pasted the chart, entered some data, selected the data series by clicking on 
a point, edited the formula bar =SERIES to refer to the new data, and the 
trendline equation changed appropriately.

-  Mike
http://www.MikeMiddleton.com



"ST" <ST@discussions.microsoft.com> wrote in message 
news:F41078DE-CC6E-4C65-B0F2-4B003C4E3E6C@microsoft.com...
>I am using copying a chart, which has trendlines dispalying the equations,
> from another spreadsheet and updating the chart for the new data.  I 
> noticed
> some of the equations were not right.  Please be noted that these 
> equations
> were formated for text size and colour.
>
> Could anyone suggest why the equations are not right and is there a way to
> get it right automatically? 

0
Mike9595 (20)
10/8/2009 12:49:58 AM
Reply:

Similar Artilces:

Trendline Function Extraction
Yet another forecasting question..... If given dates and amount of items received you can easily plot the data and have Excel produce a fitting formula that's linear, polynomial, logorithmic, etc. I am working with different types of data, some linear (which is easy) some cyclical. For the cyclical data I would like to use either a 3rd or 4th degree polynomial to approximate the upcoming volume. Again, Excel will plot the points and give you a formula, but you can't use it to forecast anything. I thought of using a linear algebra approach and using this formula: a1=INDEX(LIN...

Add trendline to PivotChart
Hello, can anyone tell me how to add a trendline to a pivot chart? No matter what I try I cannot add a trendline. I've tried clicking on a data series, right click then select add trend line but this option is greyed out I have also tried using the chart menu. This is realy getting on my nerves well only because I don't know how to do it but I can do it when the chart is not attached to a pivot table...Why? Adrian - Pivot charts do not have all the flexibility of a regular chart. While it's inconvenient, it's also necessary to ensure the integrity of the links to the...

Trendlines to ignore empty cells
Hi I have five years of data and the x axis is set for 6 years to allow the chart to fill up as new data is input. When I add a trendline it seems to include these empty cells. In fact, the cells contain a formula but have managed to get the data plot to not be zero by using the NA() function which I found in another thread. Any ideas how I can get the trendline to only use the actual data for its calc rather than plotting along the whole of the x axis? Much appreciate your advice Keith This example will allow you to have a dynamic linear trend line that recalculates and moves with the...

Set up an automate update on my database
HEllo, I have a database in Access to update every morning by hitting the update button. Is there anyway I can set up a clock in the databse and set up an automated update in a specific time. I mean, I would like to get the code to set up a specific time and the form has to update by itself on that time. Any help, really appreciated. Thank you ...

sum doesn't update total without double-click of cell
In a spreadsheet, using formula like "A1 + B1" to get the sum of values in cells A1 and B1 to show in a third cell. The total in the third cell does not update automatically after changing the value in one of the two cells (e.g., A1). Only after double-clicking the third cell, is the proper total displayed. Any ideas why this is happening? Set your calculations to automatic under tools>options>calculations -- Regards, Peo Sjoblom (No private emails please, for everyone's benefit keep the discussion in the newsgroup/forum) "David E. Gross" <David E. Gro...

Can I update?
Version: v.X Operating System: Mac OS X 10.5 (Leopard) Processor: Intel Hi, Sorry if this question has already been answered: Can I update Office v.X on my new MacBook? How do I go about it, and which is the latest version available to me? Many thanks in advance, Clumsy Chris Hi Chris - You can still obtain the 10.1.9 update for Office X here: http://support.microsoft.com/kb/930403/en-us However, this is the last update for that version and Office X is no longer supported by MS. Also, I've no experience with the combination myself, but I've seen a number of issues concerning it in...

OL2000 getting rid of "MS Update mail"
I have started making a filter using information from the header information. right click message | options, read 'return path address' and putting the domain only in the filter in 'specific words in message header. Works great, these go to permanent delete and gets around the fact OL2000 wont look inside htlm messages. Is there a way to make a list of these offending domains rather than making individual rules? The junk rule list won't send to permanent and using the suspected junk setting requires I reset it every time I add to the junk list. TIA Steve L. does it work...

Updating notebook
When I wish to update my notebook from my desktop, can I just overwrite Outlook.pst in my notebook with that from my desktop? "Bruce" <Bruce@discussions.microsoft.com> wrote in message news:E011FA26-DE62-4C97-BC91-955AF5213368@microsoft.com... > When I wish to update my notebook from my desktop, can I just overwrite > Outlook.pst in my notebook with that from my desktop? Only if you want to corrupt your mail profile. See this for other ideas: http://www.slipstick.com/outlook/sync.asp -- Brian Tillman [MVP-Outlook] ...

Linear Equations
I am having difficulty graphing a linear equation in two variables by using three ordered pair 1/2 y = 2x + My ordered pair x 0 1 y 2 6 10 see as follow Pairs x (0, 2 (1, 6 (2, 10 I am unable to graph this problem and need help!!! Just select the range containing the ordered pairs and Insert|Chart. Jerry Angela Mitchell wrote: > I am having difficulty graphing a linear equation in two variables by using three ordered pairs > > 1/2 y = 2x + 1 > > My ordered pairs > x 0 1 2 > y 2 6 10 see as follows > > Pairs: > x y > (0, 2) >...

CRM update 1.1
Is it supposed to come out in December? Does anyone know if it will incorporate any customer self service such as case initiation? Is there a list of features/enhancements to be included in the release? John update 1.1? I havn't heard about that.........where did you hear about that? Lord knows this CRM package is in dire needs of a massive service pack, and if indeed its coming in december, will..........great, only took a year. I too would like to see what features/enhancements it is attempting to resolve. -Gary "John Olinger" <jcolinger@deltyme.com> wrote in messa...

Text box that updates a control IF it is EMPTY or Has Text
I have created a red and green radio button. For a quick visual look, I want to be able to look at the form, which has multiple text boxes, to see if all the information has been entered. If the text box is empty, the red radio button is visible from the start. If the text box has the required info., the radio button (initial visibility set to false), becomes visible on the form next to my text box. So, as the information is entered into the text boxes, the red radio buttons change to green, indicating completed. In the form current event I'm using Private Sub Form_Current() ...

cannot install Office 2001 Combo update 9,0,4
When I try to launch it on my G4, the Classic Environment is automatically launched. Then I get the following message: "The default location for this install cannot be found.This install will be cancelled." I have no trouble with other installs. Hi It sounds like you may have put your Office 2001 installation in a place other than the default location and the updater can't find it. Is that possible? -Jim Gordon Mac MVP All responses should be made to this newsgroup within the same thread. Thanks. About Microsoft MVPs: http://www.mvps.org/ Search for help with the free Googl...

Windows Update error 80070005
I have error 80070005 in windows update Please always state what OS you're & service pack and what version of Internet Explorer? as it often does make a difference - Also, could you supply some information on what your firewall is, anti-virus, other R-TP programs, e.g. Spybot Search & Destroy (reduced functionality called "TeaTimer") Avira (From version 9) (Included in antivirus package), Ad-Aware, etc? http://support.microsoft.com/kb/555375 -=- Which update(s) ? -=- "Anas" wrote: > I have error 80070005 in windows update &...

Update Primary Supplier
Is it possible to prevent HQ from changing Primary Supplier at the store level? We have stores in multiple markets and they order the same SKU's but from different vendors. Whenever I issue a WS250 to update item information, there is always the risk that it will change the primary supplier at the store and often times, I don't want it to. I've worked around this problem temporarily using a custom table and DTS jobs, but is there a way to prevent WS250 from even changing Item.SupplierID ? Thanks No need to do anything, at the HQ level set the form level secruity and disabl...

how to update an XML table
Thanks in advance for any help... I have an .aspx file that I need to update a list of email addresses to receive my newsletter (doesn't have to be XML, an SQLserver table would work too I guess... are there any advantages to either). OK I have a textbox that the user types in their email address and a button to Submit it... then I want that email address submitted to go into my file... of course the file would reside on the hosting server in the same folder as the .aspx (?). Thanks for any clues on how to code this! Hallo, slinky: > Thanks in advance for any help... I have an .as...

Trendline error #2
Has anyone else found an error in the trendline tool in excel 07? I found that when transforming the x axis to logarithmic, the trendline stays linear, when it should curve with the axis. I think this started happening when I moved between 07 and 03 using the compatibility package. -- R Lawson Ann Arbor, MI Hi R, Yes this appears to be a bug! -- Cheers, Shane Devenshire "R Lawson" wrote: > Has anyone else found an error in the trendline tool in excel 07? I found > that when transforming the x axis to logarithmic, the trendline stays linear, > when it should c...

Update links prompt not wanted
I am posting a few files sayb File A and File B (Excel 2003) on a network drive. These files are password protected and are linked to each other where File A is the source file for File B. To suppress the prompt to update when I open File B, I went into Tools-Options-Edit and unchecked the 'Ask to update automatic links'. This has stopped prompting me for updating all files including these 2 files but I understand this is good only for my computer.I would also like all users of these files on the network not to be prompted for updating but that they open automatically File B wit...

I would Like to Receive the Windows Update Services for my Account
Thanks for your service... I would like to receive the Windows Updates for this acco unt at any time; please, take note about it. Thanks. -- FCAMPBELL01 Signatureship: ix/lc=1030 wcfla/lc=xxx-xx60310. fset/lc=xxx-xx25377. FCAMPBELL01 wrote: > Thanks for your service... I would like to receive the Windows > Updates for this acco > unt at any time; please, take note about it. I have taken note. Many others that are your peers likely will as well. However - I would bet the question would be, "Why should we care?" This is a peer-to-peer newsgroup - a foru...

Excell doesn't auto update cells anymore
Hello NG My Excel 2007 has stopped auto updating formula cells when one of the input cells are changed. It will only update the value if i mark the cell and press enter, or save the file. How do I make it auto update again? Martin Hi Martin, Formulas tab, Calculation Options, check Automatic -- Kind regards, Niek Otten Microsoft MVP - Excel "Martin Schou" <ingen@spam.nu> wrote in message news:46a46965$0$15392$9a6e19ea@unlimited.newshosting.com... | Hello NG | My Excel 2007 has stopped auto updating formula cells when one of the input | cells are changed. It will only...

Update attribute using ldp
Hi There, I have written an ldf script which creates few custom attributes and an auxilliary class which contains these custom attributes. Also this auxilliary class is part of Users and OrganizationalUnit classes. Now I want to update the values to the custom attributes. How do I do it using ldp? I can set values for the inbuilt attrbutes without any issues, however when I try to set the values for the custom attributes I get below error, Error 0x20B5 The name reference is invalid. Please advise. Thanks, Suresh -- sureshpalani ----------------------------...

update
it takes me about 20 goes to update my share portfolio, the internet is connected and can open other web sites, be it does not connect to Money for share update?? ...

recipient update service #5
Hi all When itry and create abother recipient update service on my 2003 sp1 server i cant, i get an error ("invalid argument") also when i go to the properties of my existing recipient update services for enterprise and domain I do not see the properties, all is see is the general, object and security tabs. I have two exchange 2003 servers that srte in the same admin and routing group, I get the same issue on the second server. Would running domain prep or forest prep help resolve this issue? Many thanks Hi Skip Why do you need to create a new Recipient Update Service? The...

Trouble with updateing Outlook
I am trying to do an update to my Outlook 2002. It appears that I have all the updates except for one titled "Outlook 2000 calibration data objects (CDO). Update security (English)" I assume that I am getting this because my 2002 install was an update from 2000. When I attempt to download this CDO, I get the following message: This machine does not have the microsoft outlook email security update installed. Please install the outlook email security update before running the CDO 1.21 email securiy update. I can not seem to find the update that this message referrs to. Wha...

Update Link
I have got a problem of Excel update link after upgrade to Office 2003. I have create 5 excel files which is linked togather. In the 1st one, it contains raw data, and each of the other make use of the result of the pervious file. 1 --> 2 --> 3 --> 4 --> 5 Data When I open the 5th file, it ask me to update link, form the background I can still see the values, however no matter I choose "update" or "do not update" the value turns into error. I have to open the 4th and 3rd file in order to give my value back. This does not happen when I open the fil...

Trendlines in graphs
Hi all! I have an interesting question. I am ploting a graph where the X axis is by months and the Y axis is the number of parts produced. Some months we do not produce any parts; therefore, the Y axis is "0" at that time. When I put a trend line on the chart, it sees the "0" as a computable data point. A line is then generated but is off from the true trend. The true trend can be generated if I remove all the non producing months. Is there a way to specify specific groups of cells in a column that you want to use in a trendline analysis--sort of hop scotch ...