Current location - Recipe Complete Network - Complete cookbook - How to place category axis labels between bars in Excel tables
How to place category axis labels between bars in Excel tables
1. Make a bar graph according to the data source shown in the figure, and put the classification axis label between the bar graphs.

2. Select the data column in the data source, click the Insert tab, and then select Insert Bar Chart in the Chart Area.

3. Open Format Axis, check "Reverse Category" in the axis option to reverse the sort order, and then remove the axis on the left side of the chart.

4. Copy and paste the source data again and add it to the chart. The chart forms a clustered bar chart.

5. Select the series above, right-click, and then click Add Data Label.

6. Click on the added data label to open "Format Data Label" and set the label position in "Axis".

7. Set the series to be borderless and colorless, so that it can be hidden.

8. Select the following series, add data labels, adjust the spacing, etc. Finally, the classification axis label is located between bar charts.