Forum Discussion
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...
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.
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.