Embedded Files
When do we present data in Multi-Series scatter plots?
When do we present data in Multi-Series scatter plots?
Scatter plots show the relationship between two numerical variables. One variable (typically the independent variable, which you control as the experimenter) is displayed along the horizontal X-axis and the second variable (typically the dependent variable), is displayed along the vertical Y-axis.
Sometimes you have multiple groups or treatments that you are measuring in your experiment. You would like to make a scatter plot that shows the data for all groups on the same graph, so that you can compare responses among your groups. This is done by displaying multiple data series at once. It is important to provide a legend on your graph so that your readers know which data series corresponds to each group.
How do we create Multi-Series Scatter Plots using Microsoft Excel?
How do we create Multi-Series Scatter Plots using Microsoft Excel?
Watch this video overview about creating Multi-Series Scatter Plots in Excel and follow the steps provided below
Watch this video overview about creating Multi-Series Scatter Plots in Excel and follow the steps provided below
1) Create a summary table with the independent variable data (X-axis) in the left column and the dependent variable data (Y-axis) in the right columns. Notice that there is a column of data measured from each bench.
2) Excel can only handle three columns of survival data initially. Highlight all of the data for the independent variable (time) and the columns of survival data for the first three NaCl concentrations (dependent variable), including the titles. Then from the top menu select Insert > Chart, and select Scatter with Straight Lines and Markers.
3) This should display a scatter graph with the correct units on the y-axis and x-axis. You will also see three data series ( for 0 g/L NaCl, 2 g/L NaCl, 5 g/L NaCl) and a legend telling you which data points correspond to which concentration.
4) Now we need to add the survival data for the remaining NaCl concentrations. We will use the "Select Data" menu, which you can access in 2 ways:
Option 1: Click on your graph. Go to the top menu titled "Chart Design" and click "Select Data"
Option 2: Right click on your graph and choose "Select Data from the menu. A new window titled "Select data source" will open.
Locate the "Legend Entries" box on the left. Click the "+" sign at the bottom and a new "Series" will appear in the "Legend Entries" box.
5) Enter data for the next concentration in the three boxes to the right of the "Legend Entries" box:
Name: Type the concentration name with units ( e.g. 10g/L NaCl)
X values: Highlight the set of times on the spreadsheet (0min through 20min)
Y values: Highlight the full set of survival values at all timepoints for the concentration group you are adding
6) Repeat data entry for all remaining concentrations until you have a survival curve for each. Click the "Ok" button.
7) Now you need to edit the graph:
Axis Labels: Click on your graph to get back to the “Chart Design” tab. Go to the “Add Chart Element” icon on the left and drop down to “Axis Titles”. This will allow you to label your vertical (Y) and horizontal (X) axes.
Remove Automatic Graph Title: Click on the automatic title that was generated on your graph. Press 'delete' on your keyboard. (You don't want this title because you will write a figure caption in your Word document that contains a more informative title).
Consider Moving the Legend Location: Because we have more than one group, or data series, we need a legend. You can edit the location of your legend by clicking on your graph to get back to the “Chart Design” tab. Go to the “Add Chart Element” icon on the left and drop down to “Legend”. This will allow you to choose your legend location.
Google Sites
Report abuse