background to clear it. You can also select and delete the label to the right of the graph. Save your graph before exiting Excel. Newer Excel versions: Proceed with number 1-3 above. For number 4 on - is a tab at the “Charts” top of the toolbar. Click that tab and the select the scatter plot with no lines connecting “Marked Select the correct that includes all title boxes before adding a trendline. scatter”. “Chart Quick Layout” Google Sheets To create a scatter plot: On your computer, open a spreadsheet at . Place your x-axis data in the first column and place your y-axis data in the second column. Click then select “Insert” “Chart” On the right side of Google Sheets a new window will pop up. (If it does not appear, double click the chart and it should appear.) By default a bar graph is automatically generated. To change that to a scatter plot select then click on down and select “Data” “Chart Type”. Scroll “Scatter Plot” To add title for the x and y axis and a chart title, select near the top and then click on “Customize” & axis Insert your chart title. Next to the chart title heading is a down arrow. Select “Chart titles”. that and then you can find the horizontal axis and the vertical axis options to give them titles. To add a trendline: In the side panel, click Customize Series. Check the box next to "Trendline." If you see the trendline option, it means don’t work with your data. Choose your trendline options. trendlines don’t There is a down arrow next to select that to add which gives “Label” “Use Equation” the linear line equation. Show R2 is an option where you click on the box. Your changes will be automatically saved.
background to clear it. You can also select and delete the label to the right of the graph. Save your graph before exiting Excel. Newer Excel versions: Proceed with number 1-3 above. For number 4 on - “Charts” is a tab at the top of the toolbar. Click that tab and the select the scatter plot with no lines connecting “Marked scatter”. Select the correct “Chart Quick Layout” that includes all title boxes before adding a trendline. Google Sheets To create a scatter plot: On your computer, open a spreadsheet at . Place your x-axis data in the first column and place your y-axis data in the second column. Click “Insert” then select “Chart” On the right side of Google Sheets a new window will pop up. (If it does not appear, double click the chart and it should appear.) By default a bar graph is automatically generated. To change that to a scatter plot select “Data” then click on “Chart Type”. Scroll down and select “Scatter Plot” To add title for the x and y axis and a chart title, select “Customize” near the top and then click on “Chart & axis titles”. Insert your chart title. Next to the chart title heading is a down arrow. Select that and then you can find the horizontal axis and the vertical axis options to give them titles. To add a trendline: In the side panel, click Customize Series. Check the box next to "Trendline." If you don’t see the trendline option, it means trendlines don’t work with your data. Choose your trendline options. There is a down arrow next to “Label” select that to add “Use Equation” which gives the linear line equation. Show R2 is an option where you click on the box. Your changes will be automatically saved.
Gen%20Chem%20Techniques%20Read%20Only%20F17.docx