How to put two sets of data on one scatter plot in Excel?

You can plot two different sets of data on a single scatter plot in Excel by clicking on the Select Data option in the Chart Design tab. Now, add the data range of your two data sets one by one, using the Add option .

How do I make a scatter plot with a lot of data in Excel?

Create a scatter chart Copy the example worksheet data into a blank worksheet or open the worksheet that contains the data you want to plot in a scatter chart. ... Select the data you want to plot in the scatter chart. Click the Insert tab, and then click Insert Scatter (X, Y) or Bubble Chart. Click Scatter. More items...

How to make a scatter plot in Excel with multiple lines?

To plot multiple lines in one graph in Excel, follow these steps: Select your data. Go to the “Insert” tab. Click on “Line Chart.” Excel will create a basic line chart with one line. Right–click on the chart, and select “Select Data.” Click “Add” to add additional data series. Select the range for the new data series. More items... May 14, 2024

How do I put multiple data sets on one graph in Excel?

How to show two sets of data on one graph in Excel Enter data in the Excel spreadsheet you want on the graph. ... Select the data you want on the graph. ... Click the "Insert" tab and then look at the "Recommended Charts" in the charts group. ... Choose "All Charts" and click "Combo" as the chart type. More items... Apr 8, 2024

How do I plot two variables on a scatter plot in Excel?

Highlight the two columns you want to include in your scatter plot. Then, go to the “Insert” tab of your Excel menu bar and click on the scatter plot icon in the “Recommended Charts” area of your ribbon. Select “Scatter” from the options in the “Recommended Charts” section of your ribbon.

How do you make a scatter plot with multiple data sets in sheets?

How can I make a scatter plot with multiple data sets? Select multiple data sets. Insert a scatter chart for those multiple data sets. Customize the scatter chart settings to add context. Add the Trendline, chart equation, and data analysis method. Mar 22, 2023

How to make a combo scatter plot in Excel?

On the All Charts tab, choose Combo, and then pick the Clustered Column - Line on Secondary Axis chart. Under Choose the chart type and axis for your data series , check the Secondary Axis box for each data series you want to plot on the secondary axis, and then change their chart type to Line.

How do you make a combo scatter plot in Excel?

On the All Charts tab, choose Combo, and then pick the Clustered Column - Line on Secondary Axis chart. Under Choose the chart type and axis for your data series , check the Secondary Axis box for each data series you want to plot on the secondary axis, and then change their chart type to Line.

How to create a scatter plot with two variables in Excel?

Highlight the two columns you want to include in your scatter plot. Then, go to the “Insert” tab of your Excel menu bar and click on the scatter plot icon in the “Recommended Charts” area of your ribbon. Select “Scatter” from the options in the “Recommended Charts” section of your ribbon.

How to Plot Multiple Data Series on a Single Excel Scatter Plot? (2024)

Forums
Mathematics
MATLAB, Maple, Mathematica, LaTeX

Thread starterZedCar
Start dateAug 7, 2012
Tags
ExcelGraph

In summary, the conversation discusses how to create a scatter plot with two lines on Excel. One person followed the steps from a YouTube video and was able to plot the lines in different colors, while the other person's original plot disappeared when they tried to add a second line. The solution suggested is to make a selection of three columns (x, y1, y2) and then insert a scatter plot.

Aug 7, 2012

ZedCar

: 354

: 1

I was watching this YT film about plotting on Excel.

I copied the numbers from the film into an Excel sheet and plotted x against y1 and got a blue coloured plot.

Then I plotted x against y2 and plotted a chart again. Though a second red coloured plot did not appear as in the film. Instead my original plot vanished and the second plot appeared, but again in blue.

How do I have both the x against y1 in blue, and the x against y2 in red on the same scatter plot?

Thank you.

Last edited by a moderator: Sep 25, 2014

Physics news on Phys.org

Aug 7, 2012

Integral

Staff Emeritus

Science Advisor

Gold Member

: 7,255

: 66

Related to How to Plot Multiple Data Series on a Single Excel Scatter Plot?

1. How do I create a simple graph in MS Excel?

To create a simple graph in MS Excel, first input your data into a spreadsheet. Then, select the data you want to include in your graph and go to the "Insert" tab. From there, select the type of graph you want to create and customize it by adding titles, labels, and formatting options.

2. Can I change the colors and layout of my graph in MS Excel?

Yes, you can customize the colors and layout of your graph in MS Excel. Simply select the graph and go to the "Format" tab, where you can change the colors, styles, and other design elements of your graph.

3. How do I add a trendline to my graph in MS Excel?

To add a trendline to your graph in MS Excel, select the graph and go to the "Layout" tab. Click on "Trendline" and select the type of trendline you want to add. You can also customize the trendline by right-clicking on it and selecting "Format Trendline."

4. Can I add multiple data sets to one graph in MS Excel?

Yes, you can add multiple data sets to one graph in MS Excel. Simply select the data you want to include and go to the "Insert" tab. From there, select the type of graph you want to create and your data sets will be displayed on the same graph.

5. How do I save my graph as an image or PDF in MS Excel?

To save your graph as an image or PDF in MS Excel, select the graph and go to the "File" tab. From there, click on "Save As" and choose the file format you want to save it as. You can also use the "Export" option to save your graph as an image or PDF.

Similar threads

Excel Graph Help: Plotting Experimental Data with Theoretical Model in One Graph

Apr 9, 2018

Replies: 6

Views: 1K

MATLABHow to plot flow data from an orifice in MATLAB without overlapping the plots?

Apr 21, 2022

Replies: 2

Views: 2K

How to get the equation of the plotted curve in Excel?

Dec 28, 2013

Replies: 1

Views: 3K

MATLABMATLAB-Plot two sets of data on the same graph with custom increments

Nov 20, 2013

Replies: 1

Views: 3K

Plotting a Difference wave in Excel

Nov 10, 2012

Replies: 1

Views: 2K

Graphing Elastic Potential Energy

Nov 3, 2023

Replies: 10

Views: 987

Plotting a Scatter Diagram from a Large Data Set

Sep 8, 2020

Replies: 4

Views: 1K

MATLABHow to plot 3d graphs from multiple .dat files in matlab?

Jan 20, 2014

Replies: 1

Views: 3K

MathematicaHow to label points in 3D Scatter Plot (Mathematica)

May 26, 2012

Replies: 1

Views: 6K

MathematicaHow Can I Generate and Plot Multiple Y Sets in Mathematica?

Mar 14, 2011

Replies: 2

Views: 4K

Forums
Mathematics
MATLAB, Maple, Mathematica, LaTeX