1. Open PPT and create a blank presentation.
2. Click Insert-Chart-Cluster Column Chart.
3. Click OK to get the cluster column chart with default data and style.
4. Enter the source data in the automatically opened Excel table, and the histogram will be automatically generated. It can be seen that most of the data are close, but one of the data is particularly large, which makes the column shape very high, and the changing trend of other columns cannot be reflected.
5. Therefore, the data of category 1 can be regarded as a data column alone, and the original data column is left blank.
6. Then select the chart and click Change Chart Type.
7. In the open window, click the combination on the left, select the cluster column chart of two data columns on the right, and check the secondary axis of the series 1 where the normal data is located.
8. Click OK to get the combination diagram.
9. It can be seen that the column type of abnormal data just now has become almost as high as other normal data, and the column type of normal data also reflects the changing trend of data.
10. However, it is still necessary to reflect the fact that the abnormal data is particularly large. Double-click the ordinate axis where the normal data is located, and the setting window will automatically open on the right, and increase the maximum value of the coordinate axis to make the column slightly shorter.
1 1. So that the columns of all data are close, and then mark the data to get the final rendering.