How Excel creates a chart

These four commonly used charts do not have specific data limitations:

First, create a column chart

1. Position the cursor in the data area where you want to create the chart, and then switch to the Insert tab and select a column chart type that you want to create under Column chart in the diagram group.

Create a Column chart

2, now the worksheet has inserted a column chart we have chosen.

Insert Column Chart

Second, create a bar chart

1. Position the cursor in the table area and select an appropriate bar chart type to create it.

Create a bar chart

2, now the worksheet has inserted a bar chart of our choice.

Insert Bar Chart

Third, create a line chart

1. Position the cursor in the table area and select a line chart insert.

Create a line chart

2, now the worksheet has inserted a line chart of our choice.

Insert Line Chart

Create a pie chart

1, because the general pie chart can only represent a single data change, so we select the data area to create pie chart, and then select a pie chart insert.

Create a pie chart

Insert Pie chart

Excel's other type of chart creation method is similar to these four, see the above method, you can understand.