You have come to the right place if you are looking for the answer or some unique tips to create a weekly comparison chart in Excel. There are some easy steps to create a weekly comparison chart in Excel. This article will walk you through each and every step with appropriate examples. As a result, you can use them easily for your purpose. Let’s move on to the article’s main discussion.
Download Practice Workbook
You can download the practice workbook from here:
Steps to Create Weekly Comparison Chart in Excel
In this section, I will show you the quick and easy methods to create a weekly comparison chart in Excel on the Windows operating system. This article contains detailed explanations with clear illustrations for everything. I have used the Microsoft 365 version here. However, you may use any other version depending on your availability. Please leave a comment if any part of this article does not work in your version.
📌 Step 1: Create a Dataset
First, create a dataset to create a weekly comparison chart in Excel. Here, I have created a dataset with sales data for 3 products over 4 weeks.
📌 Step 2: Insert a Column Chart
Then you will insert a column or bar chart to show the comparison of weekly sales data.
- First, select the cells of data table.
- Then, go to the Insert tab on the top ribbon.
- After that, click on the Bar Chart icon and select a 2D Column Chart from the lists.
- As a result, you will see a Bar chart created showing the weekly comparison for each product.
- How to Make a Bar Graph Comparing Two Sets of Data in Excel
- Make a Salary Comparison Chart in Excel (Create with Easy Steps)
- Year Over Year Comparison Chart in Excel (Create in 4 Ways)
📌 Step 3: Give a Title of the Chart
Then, you have to give a title for the chart. For this, just double-click on the chart title and rename it.
📌 Final Step: Switch Row/Column of the Chart
Here, the comparison of weekly sales for each product is shown in the created chart. So, you can monitor sales comparison of all products in each week. But if you want to show a sales comparison of weeks for each product then you have to switch the row and columns in Chart.
- To do this, click on the Chart.
- Then, go to the Chart Design
- After that, click on the Switch Row / Column
- Now, you will see that the chart is transformed and shows a weekly comparison of sales of each product individually.
Excel Chart to Show Difference Between Two Series
If you want to show the differences between the two data series then you can follow the below steps simply:
- First, create the dataset and a new column to calculate the difference between the columns.
- Then, insert the following formula into cell E5 to calculate the difference between cells C5 and D5:
- Now, select the full dataset including the difference column, and create a bar chart.
- So, now you can easily visualize the comparison of the selling price, cost price, and difference of prices of each product individually.
- Now, you can click on the Switch Row/Column to show the selling price, cost price, and differences of all products individually.
In this article, you have found how to create a weekly comparison chart in Excel. I hope you found this article helpful. You can visit our website, ExcelDemy, to get more Excel-related content. Please leave comments, suggestions, or queries if you have any in the comment section below.