Saturday, February 12, 2011

How to Graph a Function in Excel 2007


1. Start Microsoft Excel and type the following:In cell 'A1' type 'X.' In cell 'A2' type '1.'Type '2' in cell 'A3.'
2. Select cells 'A2' and 'A3' by clicking and dragging the bottom right corner then drag down column 'A' until you have the values 1 through 10.In cell 'B1' type 'Y.' In cell 'B2' type '=A2^2.' Press 'Enter.'
3. Select 'B2' and click the lower right corner and drag down column 'B' until you have the values 1 through 100.
4. Highlight 'A1' to 'B11,' click the 'Insert' menu, select 'Charts' and click 'Scatter.' Click 'Scatter with smooth lines' chart.

Blogger news