How to Create Quarterly Comparison Chart in Excel

Excel is the most widely used tool for dealing with massive datasets. We can perform myriads of tasks of multiple dimensions in Excel. In this article, I am going to explain 5 easy methods to create a quarterly comparison chart in Excel.

How to Create Quarterly Comparison Chart in Excel: 5 Easy Methods

This is the dataset for today’s article. I have quarterly sales in London, New York, and Mumbai. I will use this dataset to explain the methods.

1. Use Pie Chart for One Set of Quarterly Data Comparison

The first method is the use of the pie chart. This is a good choice when you need to analyze one set of data. For example, let’s assume that you are going to analyze the quarter-by-quarter sales amount of London. In this case, you can go for a pie chart.

Steps:

• First, select the range B4:C8.
• Then, go to the Insert
• Then, choose a pie- chart.

• After that, Excel will create a pie chart.

Read More: Year Over Year Comparison Chart in Excel

2. Create Stacked Column Chart for Quarterly Comparison

The next method is to create a stacked column. This is a suitable one for multiple sets of data.

Steps:

• Select B4:E8.
• Then, go to the Insert
• After that, select the stacked column chart.

• Excel will create a stacked column chart.
• I have renamed the chart as Sales Comparison.

Read More: How to Create Month to Month Comparison Chart in Excel

3. Use Clustered Column Chart for Quarterly Comparison

This time, I will create a clustered column chart for multiple sets of data. This is the most suitable one for analyzing this type of data.

Steps:

• Select B4:E8.
• Then, go to the Insert
• After that, select the clustered column chart.

• After that, Excel will create a chart.

Read More: How to Create Weekly Comparison Chart in Excel

4. Create Pivot Chart for Quarterly Comparison

Now, I will show how you can use the pivot chart for quarterly comparison.

Steps:

• Select B4:E8.
• Then, go to the Insert
• After that, select PivotChart.

• A box will appear. I am choosing New Worksheet as the destination.
• Then, click OK.

• Now, drag the Quarter to the Axis
• Then, drag the other columns to the Values

• Excel will create the pivot chart.

• The biggest advantage of a pivot chart is you can filter the data to modify the chart.

Read More: Side-by-Side Comparison Chart in Excel

5. Use Recommended Charts Option for Quarterly Comparison

Now, to make your life easier, Excel has the option of recommended charts too. In this case, once you select your data, Excel suggests some charts that you may find useful.

Steps:

• Select B4:E8.
• Then, go to the Insert
• After that, select the Recommended Charts.

• Excel will show a list of recommended charts.

• Choose the one you find suitable. Excel will create that chart.

Read More: How to Use Comparison Bar Chart in Excel

Things to Remember

• You can create charts from the Recommended Charts
• Pivot Charts can help filter your data.

Download Practice Workbook

Download this workbook and practice while going through the article.

Conclusion

In this article, I have explained 5 easy methods to create a quarterly comparison chart in Excel. I hope it helps everyone. If you have any suggestions, ideas, or feedback, please feel free to comment below. Please visit Exceldemy for more useful articles like this.

<< Go Back to Comparison Chart in Excel | Excel Charts | Learn Excel