Step 1
To see how pH CaCO3 are related, we need to make a Chart. To insert a chart, move your cursor to the Insert Menu, and then select Chart from the list.
Step 2
Because you have two continuous variables, An X-Y Scatter chart will best represent your data. Select it in the Chart type list.
Step 3
For a chart sub-type, select the box shown. This will connect your data points with a smooth curve. When you have selected this, click the Next button at the bottom of the dialog box.
Step 4
If there is any text in the "Data range" field, remove it now. Also, be sure to set the "Series in" to Columns.
Step 5
Now, click on the Series tab at the top of the dialog. This will allow you to choose what data goes into your chart.
Step 6
There should be no items in the Series list, if there are, remove them. Now click on Add. An item, Series1, should have been created in the list.
Step 7
Click on the Collapse Dialog button at the right end of the X Values field. The dialog should now have collapsed into a small text field.
Step 8
Make sure the new field is empty. Now select all of your measured pH data, cells C2 to C6. Check your text field against the field shown in the Wetlab Guide Box. If the chart wizard is still collapsed, click on the button at the right end to enlarge it again.
Step 9
Now repeat Steps 7 and 8 for the Y Values field. Select the CaCO3 data for this field, cells B2 through B6. Again, enlarge the Chart Wizard if needed. Click Next when you are finished.
Step 10
We're almost done now! Click on the Titles tab and give the chart meaningful labels. You may want to customize your chart by changing some of the values in the other tabs. When you are done, click Finish.
Step 11
Put the chart "As an object in AMD Data. Position and resize the chart so that you can see all of the chart without covering up your data.
Step 12
If you want to change anything about the chart, then right-click on an empty area and select chart properties. You can remove the legend by selecting it and hitting delete. Labels can be changed by selecting the text, and from there you can also change the font and color. Feel free to experiment and explore. When you are ready, hit the Finish button on Wetlab Guide Box to return to its main menu.
