Looking to create a chart/graph in Microsoft Excel 2007 ? Follow the steps below and create your chart in just seconds
1 Create the Chart
1.1 Add data to your sheet
The first thing you must do is to add your data to the spreadsheet like in our example(see Figure 1)
Figure 1 Enter data
1.2 Select the Chart
Select the data that you wish to appear on the chart by holding down the left mouse button and dragging. Click on the Insert tab on the Ribbon and under the ‘Charts’ section you will see a number of charts(Figure 2).
Figure 2 Chart options on the Ribbon
Clicking on a chart icon will give you a choice of sub charts. Click on the chart you wish to use. You have now created a chart(see Figure 3).
Figure 3 The chart
Note: If you click on the ‘Next’ button on the above dialog it is possible for you to configure the chart. Clicking on ‘Finish’ will automatically give you the standard settings.
1.3 Move the Chart
If you wish to move the chart to somewhere else on your sheet left click on the chart with the mouse and drag the sheet to where you want it.
1.4 Configure the Chart
You may wish to configure the Chart after you have created it. For example you may want to include more cells, add a title, change the chart type and so on. To do this simply right click on the chart and select the option you would like.
1.5 Include more cells in the Charts
If you wish to include more cells in the Chart then right click on the chart and select ‘Source data’ from the menu. This will display the currently selected data for this chart and the source data dialog(see Figure 4). Select the data you wish to use and click ‘Ok’ the chart will be updated with the new data.
Figure 4 Change source data
