As you have hopefully now seen, making a basic scatterplot in Excel is easy. The time consuming part is formatting your scatterplot. How to you go from the raw graph shown below to the finalized graph shown below that?
The screencast at the top of this page will walk you through many of the details. And, here are step by step directions:
Delete chart title and legend by highlighting them and hitting delete (you should add a figure number and title BELOW your graph after pasting it into Word, PowerPoint, etc.)
change the scale of each axis by double clicking the numbers along each axis and using the Axis Options features as shown in the screenshots below
Add axis titles by using either the "plus button" when you click within your graph (if available) or by using the Chart Design tab along the top of your menu and then the Add Chart Element tool (see screenshots below)
Once your generic "Axis Title" appears, if it's highlighted, you can simply start typing to give it the appropriate title
The most annoying formatting step when you use "dummy variables" is to change the "1s" and "2s" along the x axis to labels that represent what you are graphing
To do this, click and delete the numbers
You will then need to make room between the bottom of your x-axis and your x-axis title by clicking in your graph, moving up the bottom of the x-axis, then clicking and moving down your axis title to make space
Then, go to your insert tab on your menu, insert a text box, type in the appropriate labels with space between them, and then move the text box below your x-axis
This step may take a bunch of tweaking, but you should be able to get it to look like the final example shown below
