Bar charts are great for comparing things, because it’s easy to see how bar lengths differ.

This chart is an example of a clustered bar chart showing product units sold this year versus last year.

The data used for this chart looks like this on the worksheet:

How to make this chart

Data for clustered bar chart

Data for clustered bar chart

Data for clustered bar chart

Data for clustered bar chart

Data for clustered bar chart

Choose the basic 2D bar chart option

Right click data series and use fill tool to change color

Chart after data series color change

Show categories in reverse order

Select legend and move to top

Final clustered bar chart