60 likes | 73 Views
Things to Consider When Generating Graphs with Excel. Entering Data. When you enter a unit with the data, Excel will not plot the data but will plot the row number instead. Graph Size. Any graph should be full page. Right click on the graph and
E N D
Things to Consider When Generating Graphs with Excel CHM 1030 Prince George's Community College Gage
Entering Data When you enter a unit with the data, Excel will not plot the data but will plot the row number instead. CHM 1030 Prince George's Community College Gage
Graph Size Any graph should be full page. Right click on the graph and Select “Move Chart”. Select “New Sheet” to make the graph full size. CHM 1030 Prince George's Community College Gage
Graphing Selection When you select the chart type you must use an unconnected scatter plot. CHM 1030 Prince George's Community College Gage
Graph Labels Be sure that the axes are properly labeled and there is a title on the graph (y vs x). CHM 1030 Prince George's Community College Gage
Regression Equations A = 0.305 p R² = 0.996 Be sure to correct the regression equation with symbols of the actual variables and for significant figures. CHM 1030 Prince George's Community College Gage