Excel profiled chart how to Do

There are a number of ways to make contrast charts in Excel, such as the one below, which is like the "non"-shaped graph of Chinese characters, which not only looks interesting but is also very intuitive. This kind of chart is difficult to achieve if it is made by conventional means. However, if you add a secondary column based on the original data, you can easily solve the production challenge.

To add a legend label to the left and right bar chart comparison chart, we first need to deal with the data source as necessary. Copy the data source and set the value of the male data to negative, insert 3 secondary columns to the right of the data source, and enter 10 in the cell of the column, which can be set according to the legend label content. and set the data for the "female" column to a negative value.

When the data source is ready, it's time to insert the chart. Select A2:a8, and hold down the CTRL key to select the F2:h8; click the "two-dimensional bar chart → stacked Bar" in the chart area of the Insert tab. Right-click the chart, select "Select Data", select the "Hollow" series on the left legend item in the pop-up window, and click the "Move Up" button to move the "hollow" series to the "Male , "female" series; double-click the vertical axis, and on the right axis options, tick the reverse category; Double-click the horizontal axis to set the maximum value of 100 at the boundary of the axes option, with a minimum of 90, and 10 for the unit (Figure 2).

When the parameters are set, remove the horizontal, ordinate, and gridlines. Right-click on the Gray Hollow label, select "Add Data Label", double-click the added data label, on the right, in the Format data label, select the Label Options tab, uncheck the value, check category name, select the gray-Hollow bar, set its fill to none, and double-click Hollow in the legend. Delete it (Figure 3).

Select the bar on the left to add a data label, double-click the added data label, select the Label Options tab in the Formatting data label format on the right, check the value, and select Custom at the category below the number. Similarly, the addition of the bar chart data label on the right side is also true.

Finally, the bar chart for the necessary beautification, adjust the location of the legend, set the title. In this way, a "non" font contrast chart is easily done.