Forum Discussion
How do I superimpose two MS Excel scatter plots?
Hi Dave,
You may copy data from your csv files into the workbook where you plot the graph; or import them https://support.office.com/en-us/article/import-data-from-a-csv-html-or-text-file-b62efe49-4d5b-4429-b788-e1211b5e90f6 to make data updatable, let say into two separate sheets. Insert empty scatter chart, right click on it to select data and add series for each your data set
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.
