+ Reply to Thread
Results 1 to 3 of 3

How do you plot 2 sets of data on the same scatter graph?

  1. #1
    Registered User
    Join Date
    03-17-2010
    Location
    durham
    MS-Off Ver
    Excel 2007
    Posts
    7

    How do you plot 2 sets of data on the same scatter graph?

    I have plotted data A and thought it would be a case of drag and drop when plotting data B on the same graph

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: How do you plot 2 sets of data on the same scatter graph?

    Hi,

    Right click on the chart>Select Data>Add and then select the B series range, and the same x range as the A range

    HTH
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: How do you plot 2 sets of data on the same scatter graph?

    xl2007 does not support the drag/drop of data.

    As see as Richard's suggestion you could try copy, select chart and Paste Special.
    Cheers
    Andy
    www.andypope.info

+ 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