Saturday, February 12, 2011

How to Plot Data Points in Excel 2007


1. Type your data points into two columns. One column will be the x-values and the other column will be the corresponding y-values.
2. Click on a corner of the data plot cells and drag your mouse, so that all the data plot cells are highlighted.
3. Click on the 'Chart Wizard' icon in the toolbar and then select 'XY(Scatter).' Click on the type of graph you want and then you will see your data points graphed.
4. Click 'Next' to label your graph and the x and y values.
5. Click 'Finish' when you are done labeling. Your graph will appear in the spreadsheet.

Blogger news