To create a chart, you must first enter the data for the chart on an Excel worksheet. Select that data, and then use the Chart Wizard to step through the process of selecting a chart type and the various chart options for your chart. To do this, follow these steps:
Start Excel, and then open your workbook.
Select the cells that contain the data that you want to display in your chart.
On the Insert menu, click Chart to start the Chart Wizard.
In the Chart Wizard - Step 1 of 4 - Chart Type dialog box, specify the chart type that you want to use for your chart. To do this, do one of the following:
Click the Standard Types tab. To view a sample of how your data will look when you select one of the standard chart types that Excel provides, click the chart type, click the chart subtype that you want to view, and then click Press and Hold to View Sample.
To select a chart type, click the chart type, click the chart subtype that you want, and then click Next.
Click the Custom Types tab. To select a built-in custom chart type, or to create your own chart type, click User-defined or Built-in. Select the chart type that you want, and then click Next.
