First, you want to set up your columns. Make column A "mL NaOH" and column B "pH".



Next, simply enter your data.



Now, click oustide of your data. Column D should be fine.



Choose the "Insert" tab at the top.



You want a scatter plot.



Specifically, one with only markers.



Now you need to get your data.



When you click "select data" you'll be taken to this screen. Click the box that looks like a tiny spreadsheet with a red arrow. It's at the right of the text that is highlighted in black.



Now click on your first data point in either column and just drag down until you get to your last data point.



Click the little box with a red arrow in it. It's the one at the right of this graphic.



Once you're back at this screen, make sure "Series 1" is selected, then click "Edit."



Here is where you can fine-tune things, and why it didn't matter which column you used earlier. Once you're here, you want to make sure your mL of NaOH, your A column, is selected for your X values, and your pH, your B column, is selected for your Y values. This is a little different from Excel 2003, where you could select X and Y right off. You click the same little boxes with red arrows as before, just pay attention to which set of values you're selecting. Don't worry about the series name.



This is what it should look like when you're done selecting your X and Y values, just with different numbers since you'll have a different number of data points than I do. Click "OK."



You'll be back at this box. You can click "OK" here as well.



You'll have a graph that is similar to this one.



Right-click somewhere in the middle of the plot area to get this menu. Choose "Format Plot Area." This will take you to a window where you can fine-tune the look of the plot area to your liking. I would prefer if you didn't turn in graphs with strange backgrounds or anything, though.



Once you've tweaked the plot area, if you wish, right click on either the X-axis or Y-axis and choose "Format Axis."



Here you can change several things. I like to have my tick marks "inside" as this screen shows. You also want to change the "Display units" box to "hundreds" instead of the default "none." Once you have finished with one axis, do the same with the other.



These next couple steps are more of a personal preference than an absolute. Blame it on the professor I used to work for. At the top if you choose "layout" under "chart options" you can mess with the gridlines.



As this screen shows, you can turn the gridlines off. Unless the gridines are needed for something.. I prefer to have them turned off. Again, not necessary. I just think it looks neater, like having the tick marks inside looks neater as well.



Now, under the same area, you'll need to add a title to your chart. If you want something simple, yet descriptive, the standard "Y vs X" title works just fine. Meaning, if your Y-axis is pH and your X-axis is V NaOH, your title is simply "pH vs V NaOH."



From the same window, you'll now need to click on Axis Titles and label your X and Y axes. You want the titles below each axis.



You'll get something that looks like this. For general purposes, such as the strong acid/strong base titration, you can stop here. If you want to learn how to alter the look of your data points and your connecting line, the last few steps will outline that process. Sometimes you will need to change your data points, sometimes you will need to remove a line, sometimes you'll want to change things for the heck of it.



Right-clicking on one of your data points brings up this menu. Select "Format Data Series."



You'll be brought to this set of menus. First thing I chose to do was remove the line completely. This makes it easier to see the changed size of the data points a couple screen shots from now. You can also change the color of the line. Other options let you change the style of the line, the thickness of the line, etc.



Marker options is where you can change the size and/or shape of your data markers. The "Built-in" bullet is the one you want here. I left the type alone, but I changed the size from 7 to 4. When you're done playing with all the different things you can do to make your data points look different, you can exit from this menu.



Which will take you back to your graph. Viola.. Excel 2007 in.. Under 30 steps.