Saturday, August 20, 2011

How to Make a Graph in MS Excel


Instructions
1. Input the graph data. For the purposes of this example, type 'Month' in cell A1, and type the months January through December in cells A2 through A13. In cell B1, type 'Applications.' For each month, increase the 'Applications' number by 200. In cell B2, type '200,' in cell B3 type '400' and so on. The last figure in the 'Applications' column -- '2,400' -- is in cell B13.
2. Place the cursor on a cell within the data table. If the cursor is not on an item in the table, the chart will not know where to access the data. Go to the 'Insert' tab. Click on the down arrow under the 'Column' option in the 'Charts' panel.
3. Select the first chart option under the '3-D Column' heading. A graph titled 'Applications' will appear in your work area, showing 12 columns that represent the 12 numbers you entered in Step 1.
4. Click on the border of the chart to drag it to the desired location. Change the size of the graph by grabbing one of its corners and dragging it.

Blogger news