How to Create Month to Month Comparison Chart in Excel

People like to keep their records for the future. In business, it is a must to keep records and make a comparison to find out the business growth. It could be a day-to-day, month-to-month, or year-to-year comparison. In this article, I am going to explain the whole procedure of Month to Month comparison chart in Excel with simple steps.

Watch Video – Create Month to Month Comparison Chart in Excel

What Is Comparison Chart?

A comparison chart is a graphical depiction of several data values connected to the same set of categories that can be compared for various contexts, such as distinct categories or geographical locations.

How to Create Month-to-Month Comparison Chart in Excel: Easy Steps

In order to make month to monthly comparisons, we need to gather data, organize them and visualize them in a chart. We have to follow the following steps to make it perfectly.
They are as follows:

  1. Create an organized dataset
  2. Build a month-to-month chart
  3. Change the type of month-to-month chart

Step-01: Create an Organized Dataset

It is the first and foremost need to have a decorated and organized dataset to represent them as a chart.


  • Gather a dataset based on the month-to-month data. Here, I have gathered data on cost in production and gain in sales with respect to every month of the year. I have also organized them into the Month, Production Cost, and Sales

Month to Month Comparison Excel Chart

  • You can create a new column to compare the profit or loss. I have created a column named Revenue to find the profit or loss.

I have used the following formula to find the revenue.


D5 = Sales Amount
C5 = Production Cost

  • Press ENTER to have the revenue.

Month to Month Comparison Excel Chart

  • Use Fill Handle to AutoFill the rests.

Read More: How to Use Comparison Bar Chart in Excel

Step 02: Build a Month-to-month Chart

You can create a month-to-month chart quite easily if you have an organized dataset. Let’s build the chart.


  • Select the entire table.
  • Go to the Insert
  • Next, click on Recommended Charts from the ribbon.

Month to Month Comparison Excel Chart

An Insert Chart wizard will appear.

  • Click on the All Charts tab.
  • Sequentially, click on the Column option.
  • Select a pattern of chart type. I have chosen the Clustered Column option.
  • Finally, click on OK to finish the process.

Thus, we can have a month-to-month comparison chart with columns.

Month to Month Comparison Excel Chart

In this chart, I have tried to show Production Cost in the Blue column, Sales in the Orange column, and Revenue in the Ash column. The Revenue column that is facing upwards signifies the Profit and the downwards signifies the Loss.

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

Step-03: Change the Type of Month to Month Excel Chart

In the previous type, I have represented data all in the columns chart.
You can change the type in other patterns too.
I have shown another type of month-to-month comparison chart where Production Cost and Sales as columns and Revenue as Line.


  • Follow the same procedure till the opening of the Insert Chart wizard.
  • Then, select the All Charts tab.
  • Next, click on the Combo option.
  • Select the Revenue as Line from the Chart Type option.
  • Finally, press OK to finish the process

Thus, we will have a month to month comparison where revenue is shown in line and other factors as columns.

Month to Month Comparison Excel Chart

The best thing about showing the Revenue in Line is that it helps to visualize the growth or downfall quite easily and more elegant fashion.
You can edit the column colors, and add a chart title according to your need.

  • Right-Click on the mouse putting the cursor on one type of column.
  • Click on the Fill option.
  • Choose your color.

Thus, you can create a month-to-month comparison chart in Excel according to your preferences.

Month to Month Comparison Excel Chart

Read More: Year Over Year Comparison Chart in Excel

Download Practice Workbook


That’s all for the article. In this article, I have tried to explain the whole procedure of a Month to Month comparison chart in Excel with simple steps. It will be a matter of great pleasure for me if this article could help any Excel user even a little. For any further queries, comment below. You can visit our Exceldemy site for more details on Excel.

Related Articles

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

Get FREE Advanced Excel Exercises with Solutions!
Naimul Hasan Arif
Naimul Hasan Arif

Naimul Hasan Arif, a BUET graduate in Naval Architecture and Marine Engineering, has been contributing to the ExcelDemy project for nearly two years. Currently serving as an Excel and VBA Content Developer, Arif has written more than 120 articles and has also provided user support through comments His expertise lies in Microsoft Office Suite, VBA and he thrives on learning new aspects of data analysis. Arif's dedication to the ExcelDemy project is reflected in his consistent contributions and... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF