Results 1 to 4 of 4

Why does my trendline equation change?

Threaded View

  1. #1
    Registered User
    Join Date
    06-21-2014
    Location
    Wyoming, United States, Earth, Milky Way Galaxy
    MS-Off Ver
    2007
    Posts
    4

    Why does my trendline equation change?

    I've got a somewhat complicated XY Scatter chart. When I view one data series, the linear trendline equation is 'y=-30.179x+5427.5'. When I add a 2nd data series, it changes to 'y=95.117+331.52'. The 2nd trend line is correct.

    Why would this happen? The data set for the 1st series has not. When I add a 3rd, 4th, ... 7th series, they too are messed up.

    The data subset is generated by a VBA search macro. I have confirmed the data is not different. Anyone have any clues here? I have plotted the data on the scatter chart, then manually added the trend lines, with the same results.

    Thanks for any help.
    Last edited by AngryRat77; 11-29-2014 at 08:26 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 2
    Last Post: 11-03-2014, 08:04 PM
  2. Replies: 3
    Last Post: 03-06-2011, 01:38 PM
  3. Replies: 1
    Last Post: 04-23-2009, 08:23 PM
  4. Trendline equation
    By safdarhassan in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 09-11-2007, 08:51 AM
  5. [SOLVED] Trendline Equation- value of x?
    By bastien86 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-07-2006, 10:25 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1