Saturday, August 11, 2012

How to Do a Scattergraph in Excel 2003


1. Click 'Start,' then 'All Programs,' then 'Microsoft Office,' then 'Microsoft Excel 2003.'
2. Click 'File,' then 'Open.' Locate the Excel document that contains the data in it which you wish to make a scatter chart from.
3. Highlight the cells that contain the data.
4. Click 'Insert,' then 'Chart' to launch the Insert Chart wizard.
5. Select 'XY (Scatter)' foam the list of options then click 'Next.' You can 'Press and Hold to View Sample' to see what the graph will look like. Click 'Next' then name the axes and the chart. Click 'Finish' when you have finished creating the graph.

Blogger news