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 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.
Download Practice Workbook
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.
Steps to Create Month to Month Comparison Chart in Excel
In order to make month to month comparison, 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:
- Create an organized dataset
- Build a month-to-month chart
- 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.
Steps:
- 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
- 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-C5
Here,
D5 = Sales Amount
C5 = Production Cost
- Press ENTER to have the revenue.
- Use Fill Handle to AutoFill the rests.
Read More: How to Compare Two Sets of Data in Excel Chart (5 Examples)
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.
Steps:
- Select the entire table.
- Go to the Insert
- Next, click on Recommended Charts from the ribbon.
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 Clustered Column option.
- Finally, click on OK to finish the process.
Thus, we can have a month-to-month comparison chart with columns.
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: How to Make Sales Comparison Chart in Excel (4 Simple Ways)
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.
Steps:
- 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.
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.
Read More: Year Over Year Comparison Chart in Excel (Create in 4 Ways)
Conclusion
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.