Excel Comparison Chart Examples and How to Build Them

Charts & pivot tables · Updated November 19, 2026

Excel comparison chart examples include clustered column charts for comparing sales across products, bar charts for ranking categories, line charts for tracking trends, and combo charts for comparing values measured on different scales. In Excel for Microsoft 365 on Windows, arrange categories and series in a table, select the data, then choose a chart from Insert; the best type depends on what you want readers to compare.

What an Excel comparison chart shows

A comparison chart makes differences between two or more groups easier to see than a table alone. The groups might be products, regions, employees, time periods, or planned and actual results. Excel charts use categories and data series: categories commonly appear along the horizontal axis, while each series is a set of related values shown with a distinct color or marker.

Start by deciding what comparison matters. Comparing several products in one quarter is different from comparing each product’s monthly performance over a year. The first question calls for a chart that emphasizes product differences; the second calls for one that makes change over time visible. A chart can contain correct data and still be misleading if its design makes the intended comparison difficult.

Make the source table simple: put one label row at the top, one category per row or column, and numeric values in the remaining cells. Avoid merged cells and decorative blank rows inside the data range. For example, use columns named Product, North, South, and West, followed by one row per product. Clear labels help Excel assign series and categories correctly, and they make the chart easier to update.

Example 1: Compare products with a clustered column chart

Suppose a business wants to compare sales of three products in three regions. A table can have Product in the first column, then North, South, and West in the next three columns. A clustered column chart places three bars beside one another for each product, one bar per region. Readers can compare regions within a product and compare the same region across products.

In Excel, select the table, including its headings, then choose Insert > Insert Column or Bar Chart > Clustered Column. This chart works well when there are a few categories and a small number of series. If the chart has many products, long labels, or many series, the bars can become crowded; a clustered bar chart may fit better because its category labels run vertically along the left side.

For a fair comparison, check that the values use the same unit and that the vertical axis is appropriate. A column chart’s value axis commonly starts at zero, which preserves the visual proportion between bar heights. If you need to emphasize small changes with a truncated axis, make the scale clear and consider whether the visual effect could exaggerate the difference.

Example 2: Rank categories with a clustered bar chart

A bar chart is useful for comparing values across categories when labels are long or when the main question is which category is larger. Imagine a department comparing the number of support requests for twelve service types. A clustered bar chart keeps the service names readable on the vertical axis and makes it straightforward to scan from the longest bar to the shortest.

To create one, select the labeled table and choose Insert > Insert Column or Bar Chart > Clustered Bar. Sorting the source values from largest to smallest often makes a ranking easier to read. If the bars do not appear in the intended order, adjust the source table’s sort order and check the category-axis options in Format Axis; Excel may display category order in a way that differs from the row order.

Use a bar chart for a manageable number of categories. If there are dozens, the labels and bars may be too dense to read on one page. Consider showing a relevant subset, grouping categories, or using a table with conditional formatting instead. Do not remove categories just because their results are inconvenient; explain any filtering or selection used.

Example 3: Compare change over time with a line chart

For monthly revenue, website visits, or other values recorded at regular intervals, a line chart is often clearer than a column chart. Put months in the first column and one series per year in adjacent columns. A line chart can then show whether this year’s pattern is rising, falling, or seasonal compared with previous years. Choose Insert > Insert Line or Area Chart and select a line style that fits the data.

Line charts are most useful when the horizontal values have a meaningful sequence, particularly time. Use the same time intervals for each series and keep the series aligned to the same dates. If you compare this year with last year, do not accidentally align February with March because one table contains a missing month. Use clear labels and avoid adding so many years that the lines overlap into an unreadable mass.

A line joining points suggests movement between observations. That is appropriate for a continuous time series, but may imply a relationship that does not exist when categories are unrelated. For example, a line connecting sales by product type can suggest a progression from one product to the next. A bar chart is usually more suitable for such categories.

Example 4: Compare different measures with a combo chart

Some comparisons involve two measures with different units, such as monthly sales in dollars and the number of orders. Plotting both on a single axis can make the smaller-valued series look nearly flat. A combo chart can show one series as columns and another as a line, and Excel can place one series on a secondary vertical axis when the scales differ substantially.

Arrange the data with months in one column and the two measures in separate columns. Select the table, then use Insert > Recommended Charts > All Charts > Combo to choose the series’ chart types. In the combo-chart options, select a secondary axis for the series that needs its own scale. Check the axis titles and units carefully: the secondary axis can help reveal patterns, but it can also make unrelated movements appear to match. Explain what each axis measures and avoid implying that one measure causes the other.

Build and edit a comparison chart in Excel

These steps apply to Excel for Microsoft 365 on Windows. Chart names and the placement of some controls can vary slightly with window size, but the key commands are on the ribbon.

  1. Prepare the table. Use a clear header for every series and category. Keep values numeric, use consistent units, and make missing values explicit rather than typing explanatory text into numeric cells.
  2. Select the data. Drag over the complete table, including headings. If the range is not adjacent, hold Ctrl while selecting additional ranges, though a single rectangular table is usually simpler to maintain.
  3. Insert a chart. Open the Insert tab and choose the chart family that matches the task, such as Insert Column or Bar Chart for clustered bars or columns. Excel creates a chart linked to the selected cells.
  4. Check the series and categories. If Excel interpreted rows and columns backwards, select the chart and choose Chart Design > Switch Row/Column. Use Chart Design > Select Data to review the chart’s data range, series names, and category labels.
  5. Add context. Select Chart Design > Add Chart Element to add or edit a chart title, axis titles, data labels, or a legend. Name the measure and, when useful, state its unit and time period.
  6. Review the result. Confirm the displayed values against the source table, check the axis scale, and make sure colors and labels remain distinguishable. Resize the chart or simplify it if labels overlap.

On Excel for Mac, the same chart families and most chart-editing commands are available on the Insert and Chart Design tabs, though ribbon placement can differ. In Excel for the web, chart creation and basic formatting are available, but some advanced formatting controls may be more limited than in the desktop application.

Choose a chart type that fits the comparison

There is no single best chart for every comparison. Match the chart to the structure of the data and the question a reader should answer. These common choices are a practical starting point:

  • Clustered column: Compare a few series across a modest number of categories, such as quarterly expenses by department.
  • Clustered bar: Compare or rank categories, especially when category names are long.
  • Line: Compare trends across ordered, evenly spaced time periods.
  • Stacked column or bar: Show how series contribute to a combined total while comparing totals across categories. Individual segment comparisons can be harder because most segments do not share a common baseline.
  • 100% stacked column or bar: Compare proportions when the total size of each category is less important than its composition. The chart shows each category as 100 percent, so it does not communicate differences in absolute totals.
  • Combo: Show two related measures with different units or emphasize one measure as a line and another as columns. Label both axes clearly.

Use pie charts cautiously for comparisons. They can show parts of one whole, but readers may find it difficult to compare similar-sized slices across multiple pies. For comparing the same categories across groups, aligned bars or columns are generally easier to judge. Likewise, a 3-D chart may make values harder to compare because perspective changes the apparent size of marks.

Make charts easier to interpret

A chart should make the comparison visible without requiring readers to decode decoration. Use a title that states the subject and period, such as “Quarterly service requests by team, 2026,” rather than leaving the default title or using a vague heading. Add axis titles when the measure or unit is not obvious. Keep the legend close to the chart and use series names that make sense without referring back to the source table.

Choose a limited, consistent color palette. Color can distinguish series, but readers should not have to rely on color alone; labels, position, or line styles can reinforce the distinction. Check the chart at the size at which it will be viewed, especially if it will be placed in a report or presentation. If data labels create clutter, label only the values that support the comparison or rely on a clear axis and legend.

Be transparent about scales and data selection. A chart comparing values from different periods should state whether the values are actual amounts, percentages, or an index. If you exclude categories, filter the data, or omit periods, say so. A chart is a visual summary, not a substitute for explaining what the numbers represent.

Common comparison-chart problems

  • Excel plots the wrong labels: Use Chart Design > Switch Row/Column, then inspect Chart Design > Select Data to confirm the category range and series names.
  • The chart is too crowded: Reduce the number of series, use a bar chart for long labels, or divide the comparison into focused charts. More series do not automatically make a chart more informative.
  • Values appear as zero or are missing: Check that cells contain numbers rather than numbers stored as text, and inspect blank cells or filters. A chart cannot reliably compare values Excel has not recognized as numeric.
  • Colors are hard to tell apart: Choose higher-contrast colors and use direct labels where helpful. Avoid assigning a different color to every category if one highlighted series is the point of the comparison.
  • The chart suggests a false difference: Check the axis scale, units, and whether the chart type fits the data. A truncated axis, a secondary axis, or a 3-D perspective can change how large differences appear.

When the chart updates unexpectedly, inspect its source range and the shape of the table. A chart built from a fixed range may not include newly appended rows automatically. Converting the source range to an Excel table with Insert > Table can help keep structured data organized as it grows; verify that the chart includes new entries after adding data.

Frequently Asked Questions

What is the best chart for comparing two sets of data in Excel?
A clustered column or clustered bar chart is a good starting point when both sets share the same units and categories. Use a line chart if the categories are time periods and the comparison is about trends.

How do I compare two years in an Excel chart?
Put the dates or months in one column and each year’s values in a separate column, with a heading for each year. Select the full table and insert a clustered column chart for period-by-period comparisons or a line chart for overall trends.

Can Excel compare values with different units in one chart?
Yes. A combo chart can use different chart types and, when appropriate, a secondary axis. Label both axes with their measures and units, and interpret the visual relationship carefully because the two scales can create misleading impressions.

Why does Excel show my comparison chart backwards?
Excel may have treated rows as series and columns as categories, or vice versa. Select the chart and choose Chart Design > Switch Row/Column. If that does not fix it, review the ranges through Chart Design > Select Data.

Should a comparison chart start its value axis at zero?
For bar and column charts, a zero baseline usually makes bar lengths proportional to values and helps avoid exaggerating differences. Other chart types and analytical contexts may use a different scale, but the axis should be visible and the choice should not distort the takeaway.

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.