Browse » Home
Monday, January 24, 2011
How to Make a Scatter Plot in Excel 2007
1. Launch Excel 2007.
2. Create two columns of data, one for each variable, in an Excel spread sheet. These columns should be made up of a variable name as the header in the top row with the numerical data for the variable listed down the column below the header. It does not matter which order you list your variable data.
3. Highlight the two columns by dragging you mouse down from the header over all of the numerical data.
4. Click on the 'Insert' tab in the top menu bar, and select 'Scatter' from the Charts options.
5. Select the first chart style type from the drop down menu. Your scatter plot will now appear in Excel.
6. Select the 'Legend' with your mouse and click the 'Del' key on your keyboard to remove it from the graph.
7. Click on the 'Layout' tab in the top menu bar, and click 'Axis Titles' from the Labels option. Enter the variable names for your scatter plot. Keep in mind that Excel has placed the variable that was in the left column of the spread sheet on the x-axis and the second variable on the y-axis.
8. Change the scatter plot title by clicking on the current title in the graph, then typing in a new title in the text box above the plot and pressing the 'Enter' button on your keyboard.