Create a Comparison Chart in Excel: A Step-by-Step Guide

Charts & pivot tables · Updated November 19, 2026

To create a comparison chart in Excel for Microsoft 365 on Windows, arrange the items you want to compare in one column and comparable numeric values in neighboring columns, select the data, then choose Insert > Insert Column or Bar Chart > Clustered Column. Add a clear title and labels, and make sure the chart compares values that use the same units and scale.

What a comparison chart shows

A comparison chart makes differences among products, periods, teams, locations, or other categories easier to see than they may be in a table alone. A column or bar chart is often a good fit when the question is, for example, which product has the highest rating or which branch recorded the most sales. A line chart can be more suitable when the categories are ordered in time and the goal is to show a trend.

There is no single chart type called a comparison chart in Excel. The phrase describes a purpose: using a visual display to compare categories or series. That distinction matters because the right chart depends on what the data represents. A chart that compares five products by customer rating is straightforward if all ratings use the same scale. A chart that compares price, weight, and battery life on one vertical axis is not: those measures have different units and ranges, so their bars cannot be interpreted fairly against one another.

Set up the comparison data

Put the information in a simple rectangular range with one header row and no blank rows or columns inside the data. For a product-rating comparison, use one row per product and one column for each rating category. For example, columns could be Product, Comfort, Durability, and Ease of use, with scores from 1 to 5 in the data rows. Each score then has the same meaning and scale, making the series suitable for a common chart.

For a single-measure comparison, a name column plus one value column is enough. A list of store locations and monthly sales, for instance, can become a bar chart with locations as categories and sales as the series. If the comparison includes several months, use one row per location and one column per month, or use dates as the categories and locations as separate series. Choose the layout that makes the question easiest to read.

  • Use descriptive, short column headings; Excel may use them as the chart legend labels.
  • Keep units consistent within a series. Do not mix dollars and percentages in one series.
  • Enter numbers as numbers, not text. A value typed with an unintended leading apostrophe may not plot as expected.
  • Use a consistent scoring scale, and explain what the endpoints mean, such as 1 = lowest and 5 = highest.
  • Include a time period or other context in the header when values could otherwise be ambiguous.

When data comes from different scales, do not make the values appear directly comparable just because Excel can draw them together. Consider separate charts, a carefully explained index, or a table that preserves the original units. Rescaling data changes what the numbers mean and should be disclosed rather than treated as a cosmetic adjustment.

Create the chart in Excel

  1. Click a cell in the data range. If Excel does not identify the full range correctly, select the headers and all the relevant data cells before inserting the chart.
  2. Open the Insert tab. In the Charts group, choose Insert Column or Bar Chart, then select Clustered Column for vertical bars or Clustered Bar for horizontal bars. For a trend across dates, use Insert Line or Area Chart and select a line option instead.
  3. Review the result. Excel uses the row and column headings to assign categories and series. If it has treated the rows as series when you intended them to be categories, select the chart and choose Chart Design > Switch Row/Column.
  4. Click the chart title and replace the generic title with a precise description, such as Customer ratings by product. If the title is not visible, use Chart Design > Add Chart Element > Chart Title.
  5. Check the legend, category labels, and axis values. Remove a legend if there is only one series and it adds no useful information. Add axis titles when readers might not know what the values or units represent.

Excel also offers Insert > Recommended Charts after you select the data. Its suggestions can be a useful starting point, not a decision rule: check that the proposed chart reflects the comparison you intend to make. If the chart button names appear differently in a release or window size, the Insert tab still provides chart choices. Excel for Mac has chart commands on the Insert tab as well, although the ribbon arrangement can differ. In Excel for the web, chart creation is available from Insert, but some editing and formatting controls may be more limited than in the Windows desktop app.

Choose a chart type that fits

Clustered columns or bars work well for comparing a modest number of categories side by side. A horizontal bar chart can be easier to read when category names are long. A clustered chart is especially useful when each category has a few related values, such as the ratings of several products across three criteria. Too many series, however, can make the bars narrow and the legend difficult to follow.

Use a line chart for ordered data such as months, quarters, or years when the sequence itself matters. Lines connect observations, so a line chart can imply continuity; it is usually not the best way to compare unrelated categories such as departments. A stacked chart shows how component values contribute to a total, but later segments do not share the same baseline, which makes direct comparisons between those segments harder. A pie chart is generally a poor choice for comparing many categories or values that do not make up parts of one whole.

Think about the reader’s question before choosing. If the question is which category is largest, sort the source data by value and use bars. If the question is how several groups changed over time, use dates in chronological order and consider lines. If the question is how each category is composed, a stacked chart may help, provided the components and total are meaningful.

Make the chart readable and fair

Formatting should make the comparison easier to interpret, not make one item seem more important than the data justifies. Use a concise title, readable labels, and a limited palette. If one category needs emphasis, highlight it deliberately and keep the other categories visually consistent. Avoid relying on color alone to convey meaning, especially if the chart may be printed in grayscale or viewed by someone with color-vision differences.

For a bar or column chart, check the value axis. A zero baseline is important for ordinary bars because bar length represents magnitude; starting the axis above zero can exaggerate differences. A line chart may sometimes use a narrower vertical range to show small changes, but the axis should be clearly labeled and the choice should not mislead. Add data labels when exact values matter and there are few marks. With many categories, labels can overlap and clutter the display.

Select the chart to use the Chart Design and Format tabs. Chart Design > Add Chart Element provides options such as axis titles, data labels, and gridlines. Use these selectively: gridlines can help readers estimate values, while unnecessary borders, effects, and repeated labels compete for attention. If category labels are crowded, try a horizontal bar chart, widen the chart, shorten labels in the source data, or show fewer categories.

Keep the chart connected to changing data

A chart created from a normal cell range generally reflects edits to values in that range. If you add new rows beyond the original selection, however, the chart may not include them automatically. One practical approach is to convert the source range to an Excel table: select a cell in the data and choose Insert > Table, confirming that the table has headers. Charts based on table data can expand as table rows are added, which is useful for recurring comparisons.

Before sharing a workbook, test the update process by adding a sample row and checking whether the chart includes it, then remove the sample. If the chart does not update, select it and use Chart Design > Select Data to inspect the chart data range. A chart can also appear unchanged if the new entry is outside the source range, stored as text, or excluded by a filter. Keep a copy of important workbooks before making extensive structural changes.

Common comparison-chart problems

  • The chart has the wrong categories or legend: Excel may have interpreted rows and columns differently from your intent. Try Chart Design > Switch Row/Column, then verify the labels.
  • Some values are missing: Check that the cells contain numeric values, that the chart data range includes them, and that filters have not hidden the corresponding rows.
  • The chart is too crowded: Reduce the number of categories, split the information into related charts, or use horizontal bars for long labels. Avoid shrinking the font until labels become unreadable.
  • One series dwarfs the others: The values may use different units or scales. Do not assume a secondary axis solves the interpretive problem; separate charts or a clearly explained transformation may be more honest.
  • The ranking looks wrong: Check whether values were sorted as numbers rather than text and whether the axis is reversed or begins at a nonzero value. Also confirm that the categories have not been sorted alphabetically when the comparison calls for ranking.

One common misconception is that a more elaborate chart is automatically more informative. A 3-D chart, for example, adds perspective that can distort apparent bar sizes and make comparisons harder. A simple two-dimensional chart with clear labels is usually easier to read. Another issue is treating small differences as meaningful without considering rounding, sample size, or how the values were measured; a chart displays the entered data but does not establish why the difference occurred.

When a table or another visual is better

A chart is not always the best comparison tool. If readers need exact values, a formatted table may be clearer than labels crowded onto bars. In Excel, select the cells and use Home > Conditional Formatting to apply options such as Data Bars or Color Scales. These visual cues can help scan a table while leaving precise numbers visible. Use a restrained scale and check how blanks and unusually large values affect the formatting.

For a presentation or a report, a chart can sit beside a small table containing the key figures. For many measures with different units, separate small charts can avoid misleading scale comparisons. If readers need to explore several combinations of categories, a PivotChart may help: select a suitable data range, then choose Insert > PivotChart and configure the fields. PivotCharts are useful for interactive summaries, but they require a well-structured source and may be more than a simple one-time comparison needs.

Frequently Asked Questions

How do I compare two sets of data in Excel?
Select a range containing the category labels and both data series, then choose Insert > Insert Column or Bar Chart > Clustered Column. Confirm that the legend names and category labels are assigned correctly. Use the same units and a meaningful axis scale for both series.

How do I make a comparison chart with different units?
A single shared axis is not suitable for values such as dollars and days because the units are not directly comparable. Use separate charts, or present a clearly explained normalized measure if that transformation fits the purpose. Keep the original values available so readers can understand the underlying data.

Can Excel automatically update a comparison chart?
Edits within the chart’s source range generally appear in the chart. For a growing list, convert the data to a table with Insert > Table and base the chart on that table. Check that newly added rows are included, particularly if the chart was created before the table or uses a fixed range.

How do I add values to the bars?
Select the chart and choose Chart Design > Add Chart Element > Data Labels, then pick a label position. Labels are most useful when there are few bars or exact values are important. If they overlap, remove them and let the axis communicate approximate values instead.

Should I use a bar chart or a line chart for comparisons?
Use bars to compare separate categories, such as products or departments. Use a line chart when the horizontal axis represents an ordered sequence, especially time, and showing the pattern of change is important. The chart type should follow the structure of the data and the question readers need answered.

Related

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.