How to make Excel bar chart

How to make Excel bar chart

Data source table

Production steps:

Step 1: Modify the data source. Add a column of 2, copy the data in column C and keep it exactly the same. Then select the b:d column Insert-bar chart.

Step 2: Set up two series data labels, one is the display value, the other is the display category.

Step 3: Set the 2 series to completely overlap, and then reduce the sorting spacing. Finally, the x-axis, y-axis, and gridlines are removed and the plot area adjusts to fit the size.

Step 4: Set character format (Microsoft Jas) and bar fill color (double-click to set the fill color individually).

Step 5: Add a chart title, font to bold, resize to fit, and the final result is shown in the beginning of this article.