Forum Discussion

Dave Alvarado's avatar
Dave Alvarado
Copper Contributor
Aug 06, 2018

How do I superimpose two MS Excel scatter plots?

I'm using Excel for Mac (v 16.15).  I have two CSV files -- each with "day" and "number of logins" columns.  Both CSV files have the same values for the "day" column.  I want to create a scatter plot with both sets of data in it.  How do I do that?  I know how to create a single scatter plot by selecting data from one sheet and then creating a chart with that data (Insert -> Chart -> X Y (Scatter)).  But I can't figure out how to merge the two graphs I've created, if that's indeed the way to do it.

    • Dave Alvarado's avatar
      Dave Alvarado
      Copper Contributor

      Hi, FOllowing the link you included, I tried to import both CSV files into the same sheet -- I assume this is how I would make the scatter plot.  When I went to import the second sheet (after following all the prompts and clicking "OK"), I got the error

       

      The start of the destination range specified lies within an existing External Data Range.  Please choose another destination.

       

      This is from step #6 on the link you sent.

      • SergeiBaklan's avatar
        SergeiBaklan
        MVP

        Hi Dave,

         

        That means what the range into which you tried to import second file overlaps the range into which first one was loaded. Try into another sheet first. If works, check carefully your ranges in the first sheet.

Resources