In an ordinary Excel data table, it is not obvious where the data falls, especially when distinguishing the individual alert data, as shown in Figure 1
It is difficult to tell which points fall below the cordon 30, which falls above 60 points, how to solve such problems? We can divide the table horizontally by creating secondary data.
As shown in the figure, the establishment of secondary data 1 and auxiliary data 2, the secondary data is the need to alert the number of limits, of course, can also be three, four or more, where only three of the secondary data.
Copy and paste the secondary sequence into a data table, or select data and auxiliary data to create a stacked column chart, as shown in Figure 3
Left-Activates the data, which is the purple column, and then right click on the active section to select the chart type, as shown in the figure
Select the data point line chart, as shown in the picture:
Right-click the vertical axis and set the contents as shown in the picture:
Left to activate the bottom of the dark red column, right click to select the data series format, the specific selection of the following:
1, pattern------no;
2, pattern-color-arbitrary
3, Options-classification interval ――0