How to make a compliance chart in Excel 2013

The specific production method of the standard map:

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

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

3. Click the menu bar-Insert-chart, select the Clustered column chart in the column chart.

4. Right-click the vertical axis and choose Format Axis from the right-click menu.

5, pop-up Format axis formatting pane, Drop-down scroll bar, the horizontal axis cross set to 200.

6, and then click the Orange column in the chart, the Formatting Data series Format pane appears, the series overlay is set to 100%, and the category spacing is set to 150%.

7, complete, 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.

Note: More wonderful tutorials Please pay attention to the Triple Office software tutorial section, triple Computer office group: 189034526 welcome you to join