How to Make a Price Comparison Chart in Excel (3 Suitable Examples)

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.


Download Practice Workbook

You can download the practice workbook from the link below.


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.


3 Examples to Make a Price Comparison Chart in Excel

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.

Dataset


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.

Using Clustered Column Chart to Make a Price Comparison Chart in Excel

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.

format axis

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

Using Clustered Column Chart to Make a Price Comparison Chart in Excel

The above chart clearly reveals the month-wise comparison of prices among the brands.

Read More: How to Make a Comparison Chart in Excel (4 Effective Ways)


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.

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

Utilizing Line with Markers Chart to Make a Price Comparison Chart in Excel

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 Create Month to Month Comparison Chart in Excel


Similar Readings


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.

Using a Scatter Chart to Make a Price Comparison Chart in Excel

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

Using a Scatter Chart to Make a Price Comparison Chart in Excel

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: Side-by-Side Comparison Chart in Excel (6 Suitable Examples)


đź’ˇ 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.

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.


Related Articles

Sowmik Chowdhury
We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo