Creating a chart in Microsoft Office Excel is a very simple process. Excel provides a variety of chart types that you can choose from. A chart can be embedded as a graphic object on a worksheet page, or it can appear on a dedicated chart sheet.

For most charts, such as Column and Bar charts, you can create the chart by plotting the data displayed as rows and columns. However, some chart types, such as Radar, Pie or Bubble charts, require specific data arrangement.

To create a chart:

1. Select the cells that contain the data you want to use for the chart.

 

2. On the Insert tab, in the Charts group, either:

• Click the chart type, and then click the chart subtype you want to use
• Or, to see all available chart types, click on the small arrow in the bottom right corner to display the Insert Chart dialog box. Then scroll through and select the one you want to use.

The chart will be placed on the worksheet as an embedded chart

Once the chart is created you can modify its structure by using Design, Layout and Format tabs within the Chart Tools toolbar.