How to Make a Scatterplot Graph With Two Sets of Data in Excel 2007
Use a scatter plot when you want to display relationships between two sets of numeric data. (ref 1) The procedure for plotting two sets of y-values differs only slightly from the procedure for plotting one set. Excel 2007 makes creating a scatter chart largely automatic, but you still need to add information to make your chart more intelligible to viewers. Make sure both sets of data use the same values for the x-axis, otherwise the plot will not display properly.
Arrange your data in columns so the values you want to plot on the x-axis are in the leftmost column. Place one set of y-axis values in the second column and the other set in the third column.
Click the upper-left cell of the data range you want to plot. Hold down the left mouse button and drag to the bottom right cell to select the data.
Click the "Insert" tab at the top of the toolbar. Select the "Scatter" drop-down menu in the "Charts" section and click the type of scatter chart you want -- markers only, lines only or markers and lines. A scatter chart containing both sets of data should appear.
Click anywhere within the chart to select it, then click the "Layout" tab at the top of the toolbar. Select the "Chart Title" drop-down menu and click the type of title you want. Triple-click the words "Chart Title" at the top of your chart to highlight them and type your title.
Select the "Axis Titles" drop-down menu on the "Layout" tab. Move the mouse over "Primary Horizontal Axis Title" and click "Title Below Axis." Triple-click the words "Axis Title" at the bottom of your chart and type your x-axis label.
Select the "Axis Titles" drop-down menu on the "Layout" tab. Move the mouse over "Primary Vertical Axis Title" and click the title style you want. Triple-click the words "Axis Title" at the left of your chart and type your y-axis label.
Tips & Warnings
- Edit the plot area, data labels, legend and the scale of the axes from the "Layout" tab. Edit the data or the chart style from the "Design" tab.
- Add a second vertical axis if the two data sets have different values -- if one set is a ratio and the other is a percent, for example. You can also use two horizontal axes, but only if you have two vertical axes. (see resource)