How to make a graph in Excel 2007-1

How to make a graph in Excel 2007-1 - Enter your data....

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Enter your data. Column A will be the horizontal (x) axis and column B will be the vertical (y) axis. Highlight both columns, click ‘insert’ near the top of the screen. Click on ‘scatter’ and then click the box with only data points (no lines) on them (upper left option). Your data plot will appear. Click on ‘series 1’ and delete it. Next click on the tab labeled ‘Layout’, than go to ‘More Trendline Options’ near the bottom.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
You will be given several options for the type of trendlinethat you want to fit your data to. Spectroscopy lab (fall semester) and Hubble Red-Shift lab (spring semester) both use a ‘linear’ trendline. Be sure to have the linear trendline chosen. Near the bottom of the window, also click on ‘display equation on chart’ and ‘display R-squared value on
Background image of page 2
Background image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This document was uploaded on 11/03/2011 for the course PHY 122 at SUNY Buffalo.

Page1 / 3

How to make a graph in Excel 2007-1 - Enter your data....

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online