How to make a bi-directional bar chart in Excel tutorial

Next, give a bit to share the following ways to make a two-way bar chart

Specific production process:

① start Excel2007, the simple production of data tables, D column as a secondary column, the data of the opposite number C column.

② Select a, B, and D table Data, click the menu bar-insert-bar-two-D bar, and select the first.

③ This bar chart is inserted, select the blue bar, right-click, and set the data series format.

④ in the Series Options tab, the series overlap is set to overlap, 100%, the spacing between categories is selected without spacing, 0%.

⑤ switch to the border color label, tick the solid line, select the color of the theme white.

⑥ the red bar on the left is the same as the blue setting, and I'm not going to say that again, and then select one of the columns to be vertical, right click, and format the axes.

⑦ in Axis options, first select the axis labels to be low.

⑧ in the Number tab, the category is selected as a custom, format code, 0%;0%;0%, click the Add button, and then close.

⑨ The final finish effect, as shown in the following figure.