Common Excel chart type detailed explanation

In the last two lessons, our main use of the Excel chart type is the column chart, we also initially understand that for the same data, if you choose a different chart type, then the resulting chart appearance is very different, in order to use the chart to accurately express our views, complete the creation of the datasheet, The most important thing is to choose the right type of chart. The end of the article provides the original document for everyone to download reference.

Objective: To familiarize yourself with the commonly used chart types, including column, Pie, line, and area charts, through practical examples.

One, familiar with the sub-type of column chart

The main purpose of a column chart is to display or compare multiple data sets. The subtypes include clustered column charts and stacked column charts, which are used by default in clustered column graphs, and the following are familiar with stacked column graphs and percent-stacked column-shape subtypes.

1. Open the "Familiar chart type (original file)" Workbook file and go to the column and PIE worksheet and select the data area "A1:d4" where the chart is generated.

2. Click the Chart Wizard button on the Standard toolbar. or select the Insert → chart command for the menu. Opens the Chart Wizard dialog box.

3. In the chart type area, select Column chart, select the first row in the sub chart type area, the stacked column chart (Figure 1), and click the Press and View Sample button at the bottom of the wizard to see how the chart appears.

4. Click the Next button two times to go to the chart Options step and select the Title tab. In the Chart Title box, enter the new Hyatt advertising department, enter quarterly sales in the category (X) axis box, and enter performance (million) in the value (Y) axis box (Figure 2).

5. Click the Finish button to insert the chart as an object into the worksheet that currently has the datasheet (Figure 3).

As we can see, the appearance of this chart differs from the appearance of the "clustered column" subtype used in the first two lessons. In the x category axis, the column of each month is changed from three to one, representing the actual total sales per month, and the different color blocks in the column represent the actual sales for each department.

Practice: Refer to the previous steps to create the chart shown in Figure 4 by using the Percent Column chart subtype of the column chart.

As you can see, the column for each month of the percent stacked column chart subtype extends to the top of the chart, and each color block represents the proportion of that Department's sales during the month.

Second, create a pie chart

Pie charts represent data by dividing and populating a pie of color or pattern. Pie charts are usually used to represent a set of data, such as a percentage of the total number of readers per reader's literacy. If necessary, we can create multiple pie graphs to display multiple sets of data.

Below we continue to use the data table above to find out the total sales performance of each department in the last quarter, and then make a pie chart to compare the proportion of each department's sales volume in the quarter's total sales.

1. In the column chart and pie chart sheet, select E1 cell to enter total, select E2 Cell, click the Auto Sum button on the Common toolbar, and automatically show the formula "=sum (B2:D2)" (Figure 5) in the formula bar to sum the B2, C2, D2 cells.

2. After carriage return, use the formula fill handle to copy the formula to the E4 cell.