Sunday, May 27, 2012

How to Plot a Scatter Chart in Excel 2007


1. Enter labels into the first row of two columns and enter the data beneath it.
2. Click and drag the mouse over all of the data you entered into your spreadsheet to highlight it, including the labels.
3. Click the 'Insert' tab on the menu. Click 'Scatter' in the Charts section and select one of the five scatter chart types. Excel creates the scatter chart and displays it on the spreadsheet.

Blogger news