Tuesday, July 12, 2011

How to Draw a Scatter Plot on Microsoft Excel


1. Open a blank worksheet in Microsoft Excel. Enter two columns of data you want to plot on a scatter chart. The data should be two sets of value that intersect. For instance, in column A, you could enter daily rainfall in inches, and in column B, enter temperature in degrees. These are two sets of data that intersect at single data points. Enter the title of each set of data in the first cell of each column.
2. Highlight the cells you want to plot on the chart.
3. Click the 'Insert' tab. In the 'Charts' group, select 'Scatter.'
4. Select a chart icon for the scatter plot you want to use. For instance, click the 'Scatter with Only Markers' icon to create a scatter plot without lines. The chart will appear in your workbook.
5. Click in the chart area to display the 'Chart Tools' tabs.
6. Click the 'Design' tab to select a chart style.
7. Select the chart title and type a new name for the scatter plot. Right-click the title. Use the context menu to change the font and font size of the title.
8. Click the chart area. Click the 'Layout' tab. Click 'Axis Titles' in the 'Labels' group to add both horizontal axis and vertical axis titles, and choose the type you want. Select each title, type the text and press 'Enter.'
9. Select the plot area, and use the 'Format' tab to select the shape style you want to use for the plot.
10. Click the 'Microsoft Office' button, and click 'Save As' to save the scatter plot in your workbook.

Blogger news