+ Reply to Thread
Results 1 to 2 of 2

Plotting a line over a scatter graph

  1. #1
    Registered User
    Join Date
    10-30-2009
    Location
    Rochester, NY
    MS-Off Ver
    Excel 2007
    Posts
    2

    Plotting a line over a scatter graph

    I have data that i need to segregate after comparing it with a line. The line is a particular linear function. I need to plot my data on a scatter graph and then plot the line over it. I have been able to do both the activities separately. But i want the line to be on the same graph as the scatter graph. That would make it easier to understand and explain. How do i go about doing it??

  2. #2
    Registered User
    Join Date
    12-22-2003
    Location
    Texas
    Posts
    90

    Re: Plotting a line over a scatter graph

    in a column adjacent to the y data that is used for the graph, calculate the points of the straight line using the linear function you mention. paste the linear data into the scatter plot. next highlight the linear data set, then right click on it and select chart type. Choose the line chart type.

    see attached example
    Attached Files Attached Files
    Barrfly

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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