How to Graph Worksheets

Different types of graphs created for the example worksheet

A worksheet is a set of data organized in columns and rows. Examples of data that can be organized as worksheets are a set of data, bank balances or financial reports. Microsoft Excel is an application designed to work with worksheets that also allows to make worksheet graphs.

Things You'll Need

• Microsoft Excel 2007

Instructions

1. Launch Microsoft Excel 2007.

2. 

   Press "Ctrl+O" on the keyboard to bring up the "Open" window. Browse your computer and find a worksheet file. Double-click on the file to open it in Excel.

3. Holding the mouse left button, select worksheet cells (or the entirle worksheet) you wish to plot.

4. Click the menu "Insert" and choose a desired graph style under the section "Charts" to insert a graph object in the current Excel sheet. The common choices are "Line," "Bar," Column or "Pie" charts (see figure).

5. Place the mouse cursor inside the graph box, and move the graph to a desired position while holding the mouse left button.

Tips & Warnings

• You can insert multiple graphs within the same Excel sheet as shown on the figure.

References

• "Excel 2007: The Missing Manual", Matthew MacDonald, Pogue Press, Dec. 27, 2006.