How to Create Quarterly Comparison Chart in Excel

Get FREE Advanced Excel Exercises with Solutions!

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.


Download Practice Workbook

Download this workbook and practice while going through the article.


5 Easy Methods to Create Quarterly Comparison Chart in Excel

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.

dataset for quarterly comparison chart excel


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.

pie chart quarterly comparison excel

Read More: How to Compare Two Sets of Data in Excel Chart (5 Examples)


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.

Stacked Column chart quarterly comparison excel

Read More: How to Make a Comparison Chart in Excel (4 Effective Ways)


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.

Clustered Column chart quarterly comparison excel

Read More: How to Make Sales Comparison Chart in Excel (4 Simple Ways)


Similar Readings


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.

Pivot chart quarterly comparison excel

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

  • Excel will create the pivot chart.

Pivot chart quarterly comparison excel

  • 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 (6 Suitable Examples)


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.

recommended chart quarterly comparison excel

  • Excel will show a list of recommended charts.

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

recommended chart quarterly comparison excel

Read More: How to Use Comparison Bar Chart in Excel (2 Practical Examples)


Things to Remember

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

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.


Related Articles

Akib Bin Rashid
Akib Bin Rashid

Hi, this is MD Akib Bin Rashid. I completed my BSc in Engineering back in 2019. After that, I did an MBA. Then, I joined as an Excel and VBA Content Developer at SOFTEKO Digital. Being passionate about data analytics and finance, I will try to assist you with Excel

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo