By following these steps you can add a chart/graph in your MS Excel
Instructions
- 1Type "Month" in cell A1, and type the months January through June in cell A2 through A7. In cell B1, type "Applications." For each month, increase the "Applications" by 100. In cell B2, type "100," in cell B3 type "200" and so on. The last month in the "Month" column should be in cell A7 and the last figure in the "Applications" column should be in cell B7.
- 2Place the cursor on a cell in the "Month" and "Applications" data table. If the cursor is not on an item in the table, the chart will not know where to access the data. Press the "Insert" tab. Click the down arrow under the "Column" option in the "Charts" panel.
- 3Click "Bar" from the "Charts" section, and then select the first column chart option under "3-D Bar." To change the bar graph to a pie chart, right-click the graph itself and select "Change Chart Type." Click "Pie" in the "Change Chart Type" dialog box and select the first option under the "Pie" row, then press "OK."
- 4Click the border of the chart and drag it to the desired location. You can change the size of the chart by grabbing a border of the chart and dragging it.
Walang komento:
Mag-post ng isang Komento