how to create charts based on data excel

1. On the worksheet, arrange the data that you want to plot in a chart.

2. Select any cell within the data range that you want to use for the chart.

3. On the Insert tab, in the Charts group, do one of the following

4. By default, the chart is placed on the worksheet as an embedded chart.

5. Excel automatically assigns a name to the chart, such as Chart1 if it is the first chart that you create on a worksheet. To change the name of the chart, do the following:
Click the chart.

a. On the Layout tab, in the Properties group, click the Chart Name text box.

Tip If necessary, click the Properties icon in the Properties group to expand the group.

b. Type a new name.

c. Press ENTER.