How does Excel make a two-color column chart?

Source: Internet
Author: User

How does Excel make a two-color column chart? In daily work, we often use the column chart + polyline graph to show the trend relationship between data and metrics, today I'm going to introduce you to a Two-color column chart (that is, a column chart that exceeds the metric is represented by a color, and a column of substandard columns is represented in another color), Data and indicators of the relationship between the show more intuitive and clear, the following for you to introduce a look at it!

Method 1

The original data is shown in the following figure, the original data is divided into 3 columns, the 1th column is the date, the 2nd is the evaluation index, and the 3rd column is the daily completion rate;

First, the original form of data processing

Enter a formula in the D2 cell =if (B2-C2>0,0%,C2)

Enter a formula in the E2 cell =if (b2-c2>0,c2,0%)

Then pull down the fill, separating the completion rate into the "compliance" and "nonconformance" columns by using the column D and E cell formulas

Second, the production of column chart

1. Hold down CTRL and select the A1:A13,D1:D13,E1:E13 three discontinuous areas of the left mouse button, respectively.

2. Click on the "Insert" tab, select "Column Chart", select "Two-dimensional Column Chart", the newly generated chart effect as shown in the following figure

Three, column chart horizontal axis adjustment

Because my date column data is incoherent, resulting in a newly generated column chart with 5-6 and 5-7 blank columns (as shown above), the adjustment method is as follows (this step can be ignored if the date is continuous)

Double-click the left mouse button on the horizontal axis, eject the Format Axis dialog box, and select the text axis option to complete the horizontal axis adjustment of the chart.

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.