How to Make a Double Bar Graph in Excel (Easiest Way in 2025)

In this article, we will show you how to make a double bar graph in Excel. Simply follow the steps below.

Double Bar Chart in Excel

To insert a double bar graph in Excel, simply follow the steps below.

1. Prepare Your Data to Make a Double Bar Graph

Organize your data into columns with clear labels. For this example, let’s say you have months listed in Column A, sales for Product X in Column B, and sales for Product Y in Column C.

2. Insert a Blank Chart

Select the data range that includes your months and both products’ sales. Click on the ‘Insert’ tab, and choose ‘Bar Chart’ from the Chart options. Select ‘Clustered Bar’ to insert a blank double bar graph.

3. Adjust the Chart Design

Once your chart appears, use the ‘Chart Design’ tab to refine its look. You can change the chart style, colors, and layout to make your data more readable and visually appealing. Choose a style that makes the differences between Product X and Product Y easy to distinguish.

4. Edit the Chart Title

Click on the default chart title to edit it. Type a new title that reflects the data in your graph, such as “Monthly Sales Comparison of Product X and Product Y”.

5. Label Your Axes

To make your graph clearer, add labels to your axes. Click on the graph, then select ‘Add Chart Element’ from the ‘Chart Design’ tab. Choose ‘Axis Titles’ and add a title for the horizontal and the vertical axes, like “Months” for horizontal and “Sales Figures” for vertical.

We hope you now have a better understanding of how to make a double bar graph in Excel. If you enjoyed this article, you might also like our article on how to color bar charts by category in Excel or our article on overlapping bar charts in Excel.

Similar Posts