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.
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: 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.
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.
Read More: How to Make Sales Comparison Chart in Excel (4 Simple Ways)
Similar Readings
- How to Make a Bar Graph Comparing Two Sets of Data in Excel
- Make a Price Comparison Chart in Excel (3 Suitable Examples)
- How to Make a Salary Comparison Chart in Excel (Create with Easy Steps)
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 (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.
- 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 (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.