Make a ranking bar chart

Uploaded time: October 14, 2021 Difficulty: Primary

Make a ranking bar chart

Make a ranking bar chart

Tips: After starting to play, you can adjust the video clarity, click


Auto 720p

Graphic skills

The bar charts use bars with the same width to indicate the amount of data. Therefore, we can compare data intuitively. By using a bar chart, it will be convenient for us to compare the differences between data.

Take this table as an example. This is the data of cumulative confirmed COVID-19 cases on April 9, 2020. If we want to see the difference in confirmed cases between countries more intuitively, we can use a bar chart.

1. Click any cell in the data area.

2. Click the Insert tab.

3. Then click the Insert Bar Chart drop-down button.

4. Select the Clustered Bar option. Now, we can see a new bar chart is created in the table.



In the newly created bar chart, we can make certain adjustments according to our actual needs.

To sort the data of the bar graph from highest to lowest:

1. Select the source data table

2. Click the right mouse button

3. Then select Sort in the popup shortcut menu.

4. Click Ascending to change the order of the bar chart.



The spacing between the bars is large by default, which is not convenient for us to view. We can click to select the bar. Select SERIES and adjust Gap Width to 40%. The smaller the value is, the closer the spacing will be.



To make the chart aesthetically pleasing:

1. Click Axis in Chart Elements at the upper right corner of the table.

2. Uncheck Primary Horizontal to cancel the abscissa.

3. Now check the Data Labels checkbox in Chart Elements at the upper right corner of the table. Then the data will be displayed on the right side of the bar.



4. Finally, we can uncheck Gridlines in Chart Elements

5. Then we can cancel the grid lines of the chart.

6. Now drag the control points outside the bar chart to adjust the chart to a suitable size.



Above are some basic methods for making bar graphs. Did you get it?

This skill could also be used in Microsoft Office Excel and OpenOffice.