Excel2013 Chart Production example: Standard map

Source: Internet
Author: User

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.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.