A Price Comparison Chart is a handy tool for many scenarios. In Microsoft Excel, you can make a Price Comparison Chart with the help of other chart types. Also, you can perform this task for a large set of data within a very short time. This article demonstrates how to make a price comparison chart in Excel.
Necessity of a Price Comparison Chart
A Price Comparison Chart is a very handy tool when you have a large number of choices to buy stuff from. Let’s say you are running a business and you need to buy a product in bulk. The price of the product varies from brand to brand and also over time. In this case, a Price Comparison Chart becomes a very important tool, if not the most necessary tool, for you to make your decision.
Moreover, a Price Comparison Chart saves you a lot of hassle and time. Also, a Price Comparison Chart can help you determine prices for your own products.
How to Make a Price Comparison Chart in Excel: 3 Examples
In Microsoft Excel, you can easily create a Price Comparison Chart. Although Excel doesn’t provide any direct way to insert a price comparison chart, you can use other chart types as a  Price Comparison Chart. In the following stages of this article, we will see three examples of how to make a  Price Comparison Chart in Excel.
Let’s assume you have a dataset where you have the prices of a product for different Months and for different brands named as Brand 1, Brand 2, and Brand 3. Right now, you want to make a Price Comparison Chart.
1. Using Clustered Column Chart to Make a Price Comparison Chart in Excel
In this example, we will create a Clustered Column Chart from the dataset, which will represent a Price Comparison Chart. This chart will give the prices as the heights of the columns. Now, to create a Price Comparison Chart using a Clustered Column Chart, follow the below steps.
Steps:
- Initially, select the whole dataset. In this case, we select the range B4:E10.
Here, cell B4 is the column heading of the Month column, and cell E10 is the last cell of the column Brand 3.
- Then, go to the Insert tab.
- After that, select Insert Column or Bar Chart.
- Next, click Clustered Column to insert a Clustered Column Chart.
In the next steps, we will format the vertical axis for a better Price Comparison Chart.
- Now, double-click on the Vertical Axis to open the Format Axis options.
- Subsequently, change the Minimum value in Bounds close to your minimum value in the dataset. In this case, we choose 40.
- In addition, you can also change the Maximum value in Bounds, if you prefer to do so.
- At this point, add axis titles to make the chart more understandable.
- Eventually, you will have your Price Comparison Chart as shown in the below screenshot.
The above chart clearly reveals the month-wise comparison of prices among the brands.
Read More: How to Make a Comparison Chart in Excel
2. Utilizing Line with Markers Chart in Excel
Besides, you can also utilize a Line with Markers Chart to make a Price Comparison Chart in Excel. A Line with Markers Chart will also give you an idea for comparison in any time between the months. Now, to make a Price Comparison Chart using this type of chart, you can follow the below steps.
Steps:
- First, select the whole dataset. In this case, we select the range B4:E10.
- Then, go to the Insert tab.
- After that, select Insert Line or Area Chart.
- Next, click Line with Markers to insert a Line with Markers Chart.
- Later, format the vertical axis of the chart as shown in the above example.
- Consequently, you will have an output as shown in the below screenshot.
In the above screenshot, you can clearly see the difference in the prices in the vertical axis. This represents a very clear month-wise comparison of prices among the brands.
Read More: How to Compare 3 Sets of Data in Excel Chart
3. Applying a Scatter Chart to Make a Price Comparison Chart in Excel
A Scatter Chart is also a very good way to represent a Price Comparison Chart. In a Scatter Chart, you will not have texts in the horizontal axis. Rather, it will show the Months on the horizontal axis as numerical values. Keeping this in mind, if you want to make a Price Comparison Chart in Excel, you can follow the below steps.
Steps:
- At the very beginning, select the whole dataset. In this case, we select the range B4:E10.
- Second, go to the Insert tab.
- Then, select Insert Scatter (X, Y) or Bubble Chart.
- Next, click Scatter to insert a Scatter Chart.
- Subsequently, format the vertical axis of the chart as shown in the first example.
- Finally, you will have your output as shown in the below screenshot.
The above screenshot shows the price point in each month for different months in the vertical axis. From the height difference in the vertical axis, the price comparison is clearly visible.
Read More: How to Compare Two Sets of Data in Excel Chart
💡 Things to Remember
- In Microsoft Excel, there is no direct way to insert a Price Comparison Chart.
- If you want to add another set of data to compare prices, just copy the column and paste it into the chart.
- After inserting the charts, you can add legends, data labels or other chart elements to make the chart more understandable and visually more appealing.
Download Practice Workbook
You can download the practice workbook from the link below.
Conclusion
In this article, I showed three examples of how to make a Price Comparison Chart in Excel. Each of these examples may serve separate purposes.
Last but not the least, I hope you found what you were looking for from this article. If you have any queries, please drop a comment below. Also, if you want to read more articles like this, you can visit our website, ExcelDemy.