Monday, September 26, 2011

How to Scatter Plot Data on Excel


Scatter Plot Data in Excel 2003
1. Open Microsoft Excel 2003.
2. Place one set of data in one column and another set of data in an adjacent column. For example, place one set of data in column A, which will be your X values, and then place another set of data in column B, which will be your Y values.
3. Select the range of values to be included in the scatter plot chart. To select the range, click the first cell to be included and then drag your mouse towards the last cell to be included.
4. Click the 'Insert' menu and click 'Chart.'
5. Click 'XY (Scatter)' under the 'Chart Type' box. Select the chart sub-type you want to use under the 'Chart sub-type' box.
6. Click 'Next.' This will show you the data range and a view of your chart.
7. Click 'Next' to proceed to the 'Chart Options' window. Enter the information for 'Chart Title,' 'Value (X) axis,' and 'Value (Y) axis.' The 'Value (X) axis' is a descriptive title for the values of the X axis, while the 'Value (Y) axis' is a descriptive title for the Y axis. For example, if you're tracking weekly expenses, you can use 'Days' for the title of the X axis and 'Total Daily Costs' for the title of the Y axis.
8. Click 'Next' to proceed to the 'Chart Location' box. You have the option of placing the chart in the same worksheet as your data or in a separate worksheet.
9. Click 'Finish' to exit and display the scatter plot chart.
Scatter Plot Data in Excel 2007 or 2010
10. Open Microsoft Excel.
11. Place one set of data in one column and another set of data in an adjacent column. For example, place one set of data in column A, which will be your X values, and then place another set of data in column B, which will be your Y values.
12. Select the range of values to be included in the scatter plot chart. To select the range, click the first cell to be included then drag your mouse towards the last cell to be included.
13. Go to the 'Insert' tab. Click 'Scatter' under the 'Charts' group menu.
14. Click 'Chart Area' for the XY chart. This displays the 'Chart Tools,' 'Design,' 'Layout,' and 'Format' tabs specific to the XY chart.
15. Go to the 'Design' tab and click the chart style you want to use.
16. Type the title for your chart under 'Chart Title.'
17. Go to the 'Layout' tab and click 'Axis Titles.' Click the 'Primary Horizontal Axis Title' to place a title for the horizontal axis. Click the 'Primary Vertical Axis Title' to place a title for the vertical axis.
18. Press 'Enter' to exit and show the chart.

Blogger news