# 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.

### 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.

### 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.

## 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

Get FREE Advanced Excel Exercises with Solutions!
Akib Bin Rashid

AKIB BIN RASHID, a materials and metallurgical engineer, is passionate about delving into Excel and VBA programming. To him, programming is a valuable time-saving tool for managing data, files, and internet-related tasks. Proficient in MS Office, AutoCAD, Excel, and VBA, he goes beyond the fundamentals. Holding a B.Sc in Materials and Metallurgical Engineering from Bangladesh University of Engineering and Technology, MD AKIB has transitioned into a content development role. Specializing in creating technical content centred around Excel and... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF