Friday, May 25, 2012

How to Create a Linear Chart Using Excel 2007


1. Open Microsoft Excel from the 'Start' menu and wait for the application to load.
2. Enter the data you want to convert into a chart into cells on a spreadsheet. Include labels for each column in row 1. Ensure that the X and Y values are in their own columns and each row contains the X and Y value that should be graphed together on the chart.
3. Click and drag from the top-left cell to the bottom-right cell to highlight all the data you want to include in the chart.
4. Click the 'Insert' tab on the top of the screen.
5. Click 'Scatter,' and then choose the chart type you wish to use. As soon as you click a chart type, it will automatically be inserted into the spreadsheet.
6. Select the 'Layout' tab under Chart Tools. Click 'Trendline,' and then choose linear trendline from the drop-down menu.

Blogger news