Excel2013 Chart Production example: Standard map

The case illustrates how to create a compliance chart by setting an axis overlap. A compliance chart can visually reflect whether the data meets the required standards. For example, the standard for compliance is 200, and when the totals for each month are below 200, they appear below the axis and above 200, just above the axis.

A compliance chart is made by combining a column chart with a secondary column and then setting the sequence overlap. For example, the standard for compliance is 200, and when the summary data for each month is below 200, it is displayed below the axis and above the axis, above 200.

① start Excel2013, first open the previously prepared data table source, we build a column of auxiliary columns, to determine the size of the aggregate data and standards, to see whether the standard.

② formula input finished, enter, get the result is 113, double-click the cell fill handle to fill the data intact. Hold down the CTRL key to select the A1:a7,f1:g7 area.

③ Click the menu bar-Insert-chart to select a clustered column in the column chart.

④ Right-click the vertical axis and choose Format Axis from the right-click menu that pops up.

⑤ The Format Axis Formatting pane, Drop-down scroll bar, cross axis set to 200.

⑥ then click the Orange column in the chart to show the Set data series Format pane, set the series overlap to 100%, and set the sorting spacing to 150%.

⑦ completed, we can beautify the chart to deal with, delete some unnecessary things, and finally, the completion of the production map. The blue in the picture indicates the standard, and Orange is not standard.