How to make a pair bar chart with Excel

how to make a pair bar chart with Excel

The following is illustrated by the technical statistics for the Spanish derby (Real Madrid vs Barcelona), and the data and effects are as follows:

The chart production method is as follows:

Step One: Create a clustered bar: Select the range of data in the table a1:c6-> click "Clustered Bar" in the "Insert" bar chart to get it. This is the chart most people use.

The second step: Draw one of the data series on the secondary axis: Select the Red Series in the chart (that is, Barcelona), click the right mouse button, select "Format data series", the series is plotted on the secondary axis, at which point the secondary axis appears above the chart.

Step three: Separate the data bars from the two data series: Select the primary axis below the chart, right-click, select Format axis, and in axis options, check the reverse tick value. At this point you can see that the values of the primary and secondary axes are displayed in reverse, and the two-series data bars are separated.

Step Fourth: Set the range of values for the axis so that the two-series data bars appear back-to-back: Select the primary axis, click the right mouse button, select Format axis, the minimum value is set to "1" in the axis options, the maximum is set to "1", and the same is true for the secondary axis. You can see that the value of the primary and secondary axes is symmetric, with two series of data bars showing back-to-back, similar to the effect chart.

Fifth Step: Landscaping chart: This is mainly the setting of the axis labels. Select the vertical axis, click the right mouse button, select Format axis, in axis options, the major tick mark type select None, axis labels Select high, other settings are unchanged, you can see the vertical axis label left display. Finally, the primary and secondary axis of the label, the grid line delete, add data labels and chart title can get the effect chart.

If you set the minimum value of the primary and secondary axes to "1.5", you can also get the following effect chart: