<span>Select the block of cells to be included in the scatter plot by clicking and dragging, then from the Insert ribbon under Chart drop down the Scatter or Bubble menu and select Scatter. A chart will appear on the spreadsheet.
</span><span>
To set up a scatter plot in Excel, enter the pairs of data in two columns with each value of a pair on the same row. By default, Excel considers the column on the left to contain the horizontal (X) values and the column on the right to contain the vertical (Y) values.
</span><span>If you click on the + sign at the upper right of the chart, a list of checkboxes will appear. Check Axes, Axis Titles, and Trendline. Uncheck everything else. You should edit the Axis Titles to include the name of the factor and any units associated with it. Double-click on the Axis numbers to bring up the Format Axis dialog, then click on the bar-graph icon to access Axis Options. Set the bounds and units appropriately and set the tick marks to something sensible.</span><span>
</span>
Plants combine water and Carbon dioxide from the air to make glucose for themselves, and giving off oxygen in the process. So CO2 and H2O would be on ther reactant side (left) with O2 and C6H12O6 being on the product side (right).
