+ Reply to Thread
Results 1 to 2 of 2

scatter plot with fitted straight line

  1. #1
    Registered User
    Join Date
    06-09-2009
    Location
    hk
    MS-Off Ver
    Excel 2003
    Posts
    4

    scatter plot with fitted straight line

    i want to create a scatter plot (plot a against b ) with fitted straight line
    i come up with these codes, but there are two errors occured , how can i solve these ???

    Please Login or Register  to view this content.

  2. #2
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: scatter plot with fitted straight line

    What are a and b? Arrays? If so, what sort of data is in them - there is a limit as to the length of the SERIES formula the chart uses, and when you assign an array, you add the literal values to the formula. That's not a problem if you are using a few integers, but it doesn't take many numbers with lots of decimal places before the formula becomes too long. If you can use a range to hold the data, I would do that.
    Remember what the dormouse said
    Feed your head

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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