Trending September 2023 # Create Comparison Chart In Excel: Product, Sales, Budget Analysis # Suggested October 2023 # Top 17 Popular

You are reading the article Create Comparison Chart In Excel: Product, Sales, Budget Analysis updated in September 2023 on the website Khongconthamnam.com. We hope that the information we have shared is helpful to you. If you find the content interesting and meaningful, please share it with your friends and continue to follow and support us for the latest updates. Suggested October 2023 Create Comparison Chart In Excel: Product, Sales, Budget Analysis

What is Comparison Chart in Excel?

A comparison chart is a graphical representation of different informational values associated with the same categories, making it easy to compare values. It shows how different things are performing relative to each other.

For example, to compare the profits of Tesla for the years 2023–2023, use a comparison chart to display information. Additionally, a comparison chart can help compare sales figures for a particular product in different regions or compare how much profit a business is making in two different regions for the same product. Therefore, by using a comparison chart, you can better understand the data and make informed decisions about your business strategy. In this article, we will see the process of creating a comparison chart in Excel step by step.

How to Create a Comparison Chart in Excel?

To create a comparison chart, follow these basic steps:

Select the data for comparison.

Choose a chart type like a column or bar chart.

Customize the chart with titles, legends, labels, design, colors, and layout.

Save your Excel workbook.

Now, let’s explore how to create a comparison chart in Excel using sales data associated with different regions, as depicted in the screenshot below.

Now, we need to add Data to this blank chart to see the sales values for countries in a comparative manner. Follow the steps below:

This window helps you modify the chart by allowing you to add the series (Y-Values) and Category labels (X-Axis) to configure the chart as per your need. Under Legend Entries (Series), inside the Select Data Source window, select the sales values for 2023–2023. Follow the step below to get this done.

NOTE: You can add Sheet 1 or Sheet 2 under Series Value.

Now, on the right-hand side, there is a Horizontal (Category) Axis Labels section. Here you must edit the default labels to segregate the sales values column Country wise.

Please note that there is no such option as Comparison Chart under Excel to proceed with. We added a bar/column chart with multiple series values (2023 and 2023). However, adding two series under the same graph automatically makes it look like a comparison since each series value has a separate bar/column associated with it.

Examples of Comparison Charts in Excel #1 Sales Comparison Chart

In this example, a sales comparison chart displays the sales figures of MacBook and iPhone products by three different sales executives in a firm. It helps identify the top-performing sales executive for each product and the overall sales. For instance, the chart shows that Peter sold the most iPhones, while John sold the most MacBooks.

#2 Budget Comparison Chart

For example, in a monthly budget comparison chart, each column would represent a different month, with the budgeted amount represented by a dark-shaded column and the actual expenses represented by a light-shaded column.

The chart helps quickly identify areas where actual expenses are higher or lower than the budgeted amount for each month. In the above example, the actual expenses in March, April, and June exceed the budgeted expenses by $120 (750-630), $50 (600-550), and $20 (720-700), respectively.

#3 Market Share Comparison Chart

For example, a market share comparison chart for automobile companies may show the market share of different companies for 2023 and 2023, with dark-shaded bars representing the market share for 2023 and light-shaded bars representing the market share for 2023.

In the above example, the market share of BMW reduced to 2.95% from 3.10%, and the market share of Toyota increased from 10.80% to 11%.

#4 Product Comparison Chart

In this example, the product comparison chart shows the sales of four different products over four months, from January to April. We can easily see which product had the highest sales in a particular month and which had the lowest. For instance, in April, Product 4 had the highest sales of $355, while in March, it had the lowest sales of $280.

Types of Comparison Chart in Excel 1. Column Chart

A column chart is a type of chart used to display data in columns, where the height of each column represents the value of the data shown. It is identical to a bar chart but with the bars oriented vertically. Column charts are also useful for comparing values across different categories or periods.

In this example, the horizontal axis represents LED Lamp Sales in different locations in 2023, and the vertical axis represents the number of sales made by each area. The columns show the number of sales for each site, with the height of the column corresponding to the number of sales made. Thus, by comparing the sizes of the columns, it is easy to understand that the location “Southeast” had the most sales ($478,683), and West had the least ($255,986).

2. Bar Chart

In this example, the horizontal axis represents the number of sales made by each area, and the vertical axis represents LED Lamp Sales in different locations 2023. Further, the bars show the number of sales for each region, with the length of the bar corresponding to the number of sales made. Therefore, comparing the bar measurements makes it easy to see which location had the most and the least sales.

3. Line Chart

A line chart is a powerful tool for visualizing trends and changes over time. It displays data as a series of points connected by straight lines, making it easy to see trends over time. It is also useful for showing changes over time or comparing multiple data sets.

4. Pie Chart

A pie chart is an easy way to show how each category contributes to the aggregate. Moreover, it is useful for showing data distribution or the relative size of different categories. It displays data as a proportion of a whole, making it easy to see the relative size of each type.

In this example, each slice of the pie represents a different location, and the size of each portion corresponds to the percentage of total sales made by that area. The chart shows that the biggest share of sales comes from the Southeast area, i.e., 26%.

5. Scatter Chart

In this example, the scatter chart represents the relationship between LED Lamp sales by different locations in 2023 and the number of sales made by each area. Each point on the graph represents one region, and the position of the point shows the number of sales made by a particular site. Therefore, the chart facilitates the correlation between the aggregate LED Lamp sales and the number of sales in each location.

When to Use it?

You can use comparison charts to visually display and compare various data types, as seen in the table below.

Type of Data

Examples

Financial Monthly revenue, stock prices, sales figures

Academic Student grades in exams

Sports Performance of sports teams over the years

Web Analytics Monthly website traffic

Business Number of employees for different businesses

Technology Market share of different software over the years

Things to Remember

Although there is no “Comparison Chart” chart in Excel, you can create one by adding multiple series under a bar/column chart to achieve a comparison view.

A comparison chart is best suited for situations where you have different/multiple values against the same/different categories and want a comparative visualization.

Comparison Charts are also known as Multiple Column Charts or Multiple Bar Charts.

Although there is no “Comparison Chart” chart in Excel, you can create one by adding multiple series under a bar/column chart to achieve a comparison view.

Choose the right type of chart for the data you want to display. Also, ensure the data is easy to understand, accurate, and complete.

Further, use formatting options like labels, legends, and colors to make the chart visually appealing.

Add a chart title and axis titles to help the audience understand the chart’s purpose.

Lastly, update your chart regularly to keep it relevant and up-to-date with the latest data.