Radar Charts in Excel: Why and When to Use Them

Charts & pivot tables · Updated November 20, 2026

A radar chart in Excel is used to compare several measures for one or more items across the same set of categories. Its radial layout makes each item’s overall profile and strong or weak areas easy to scan, especially when the categories use a shared scale.

Why use a radar chart?

A radar chart, also called a spider chart or web chart, puts categories around a circle and plots a value for each category along an axis extending from the center. Excel joins the plotted values for each data series, making a distinctive shape. Readers can compare those shapes to see where items are similar and where their profiles differ.

This format is useful when the question is about a pattern across multiple dimensions rather than a single total. For example, a product team might compare three models on battery life, durability, portability, ease of use, and price score. A radar chart can reveal that one model is well balanced, another excels in portability but scores poorly on durability, and a third has no single standout strength.

  • Summarize a profile: Show a person, product, team, or option across a consistent set of criteria.
  • Spot relative strengths: Find categories where one series extends farther from the center than another.
  • Compare patterns: Notice whether two items have similar shapes even if their values are not identical.

The chart is most helpful when the audience needs a quick overview. It is not automatically the best way to read exact values; a table or a bar chart is often clearer for precise comparisons.

How a radar chart works

Each category becomes a spoke around the chart, and the chart’s value axis runs outward from the center. A point’s distance from the center represents its value. Excel connects the points in category order, creating a line or polygon for each series. In a filled radar chart, the area inside each polygon is shaded.

Because all series share the same category spokes and value scale, a value farther from the center means a higher value on that scale. The shape can help readers recognize a broad profile at a glance, but the visual area enclosed by a polygon is not a reliable measure of an item’s total performance. The result depends on category order and scale, and viewers may perceive area differently than individual values.

Radar charts work best when categories are meaningful dimensions that can be compared on a consistent scale. If the spokes represent unrelated quantities with very different units—such as dollars, minutes, and a rating out of five—the shape can be misleading unless the values are converted to a defensible common scale first.

Examples of useful comparisons

Consider a customer-support team scoring service quality from 1 to 5 for response speed, accuracy, courtesy, resolution rate, and follow-up. A radar chart can make it easy to see whether one team member has a balanced profile or whether a particular measure is an outlier. The same chart could compare several departments, provided that every score is defined and measured in the same way.

Other reasonable uses include comparing product features, evaluating a project against a fixed set of criteria, or showing a learner’s scores across subjects. In each case, the categories should be stable across the items being compared. Comparing one product’s battery life, price, and weight against another product’s camera quality, screen size, and warranty would not produce a meaningful profile because the dimensions do not match.

A radar chart can also show change over time, such as one team’s scores in January and June. Keep the number of periods small, label the series clearly, and make sure the measures are comparable from one period to the next. With many dates, the lines overlap and a line chart or a set of small charts is usually easier to interpret.

Prepare the data for Excel

Organize the data as a compact rectangular table. Put category names in the first column and the series names in the top row, or transpose that arrangement if each series is easier to list down a column. Include a descriptive heading for every series and a label for every category. Avoid blank rows or columns inside the data range because Excel may interpret them as breaks or omit part of the data.

For example, a table might have criteria in cells A2:A6 and three product scores in columns B through D, with product names in B1:D1. Every score should use the same scale, such as 1 to 5, and the meaning of a high score should be consistent. If high price is undesirable, decide whether the chart should show the raw price or a transformed affordability score; mixing a negative measure with positive measures without explanation can make the shape confusing.

  • Use the same categories for every series and keep their order consistent.
  • Use comparable units and a clearly stated scoring method.
  • Limit the number of categories and series so labels and lines remain readable.
  • Check for missing values, accidental text entries, and scores outside the intended range.

Create a radar chart in Excel

In Excel for Microsoft 365 on Windows, select the category labels, series headings, and values, then choose Insert > Insert Waterfall, Funnel, Stock, Surface or Radar Chart. In the Radar section, choose Radar, Radar with Markers, or Filled Radar. The first option emphasizes the connected profile lines, the marker version makes individual category points easier to locate, and the filled version shades the area beneath each series.

  1. Select the complete data table, including row and column headings.
  2. Open the Insert tab and choose the radar chart type that suits the comparison.
  3. Check that Excel has assigned categories and series in the intended direction. If the chart is organized incorrectly, use Chart Design > Switch Row/Column.
  4. Add or edit the chart title and, when useful, add a legend or data labels using the chart design controls.
  5. Review the axis scale and labels before sharing the chart.

On Excel for Mac, select the data and use the Insert tab’s chart controls to choose a Radar chart; the exact ribbon layout can differ from Windows. The chart types and underlying principles are similar. In Excel for the web, available chart formatting controls may be more limited than in the desktop application.

Choose a radar chart type and format it

A standard Radar chart is often a good starting point when comparing a few series. Radar with Markers adds visible points at category values, which helps when the chart has few categories or when the exact locations matter. Filled Radar can make one profile stand out, but overlapping filled areas may hide the series behind them. It is often a poor choice when several series need to be compared at once.

Use a descriptive title and a legend with names that make sense without extra explanation. If the category labels are long, abbreviate them carefully and define the abbreviations in a note or nearby table. Use distinct line colors and markers, and avoid relying on color alone to distinguish series. A readable chart should still make sense when printed in grayscale or viewed by someone with color-vision differences.

Check the value axis. Excel may choose bounds automatically, and a scale that begins above zero can make moderate differences appear more dramatic. For scores that naturally run from 0 to 5, a consistent 0-to-5 scale is usually easier to interpret than a changing scale from chart to chart. Select the value axis and use its formatting options to set bounds when needed. State the scale clearly, especially if the chart is copied into a report without its source table.

Common problems and limitations

The most common mistake is using a radar chart for too many categories or series. A dozen spokes create crowded labels, while multiple overlapping polygons make it difficult to identify which line belongs to which item. There is no universal maximum, but a small number of categories and a few series are generally easier to read. If the data set is larger, consider splitting it into several focused charts or using a different chart type.

Another frequent problem is comparing values with incompatible units or meanings. A chart does not normalize data simply because its layout is circular. If one measure ranges from 0 to 100 and another from 0 to 5, the larger numerical range can dominate the visual pattern. Rescaling may be appropriate, but only if the method has a clear rationale and is explained to the reader. Do not change scales merely to make one profile look more balanced or more impressive.

Category order also affects the polygon’s appearance. Moving a category changes which points are connected next to each other, so the outline can look different even though the underlying values have not changed. Arrange categories in a logical sequence—perhaps by process, topic, or a consistent framework—and use the same sequence for related charts.

Finally, a larger polygon does not prove that an item is better overall. The chart can invite a quick visual judgment, but it does not calculate a valid combined score or account for the importance of each dimension. If a decision requires weighting criteria, show the weights and the calculation separately rather than treating polygon size as a ranking.

Radar chart versus other chart types

Choose a chart based on the comparison readers need to make. A radar chart emphasizes the overall profile across a fixed set of dimensions. A clustered bar chart is usually better for comparing exact values category by category, because bars share a common baseline and are easier to compare in length. A line chart is generally better for ordered time data, where the sequence itself matters.

A table can be the clearest option when readers need exact numbers, units, or notes for every observation. A heat map can help readers scan a large matrix for high and low values without drawing overlapping outlines. For a small number of categories where an overall profile is important, however, a radar chart can provide a compact visual summary that those alternatives do not emphasize in the same way.

A useful rule is to make the chart answer one clear question. If the question is Which option has the highest score for each criterion?, consider bars. If it is How does each option’s pattern of strengths and weaknesses compare across the same criteria?, a radar chart may be suitable.

Frequently Asked Questions

What is a radar chart used for in Excel?
A radar chart compares one or more items across the same set of categories. It is especially useful for showing patterns or profiles, such as product ratings across several features, rather than for reading precise values.

How do I add a radar chart in Excel?
Select the data range with its category and series headings, then choose Insert > Insert Waterfall, Funnel, Stock, Surface or Radar Chart and select a Radar option. Check the series orientation and value-axis scale after Excel creates the chart.

What is the difference between Radar and Filled Radar in Excel?
Radar displays connected lines, while Filled Radar shades the areas inside the series outlines. Filled Radar can draw attention to one or two profiles, but overlapping fills can obscure values and other series.

When should I not use a radar chart?
Avoid it when you need highly accurate value comparisons, have many categories or series, or are comparing measures with incompatible units. A bar chart, table, or heat map will often communicate those data more clearly.

Does a bigger radar-chart shape mean a better result?
Not necessarily. The shape depends on the axis scale, category order, and the measures included. A larger-looking polygon is not automatically a valid overall score, especially when criteria have different importance or include measures where higher values are undesirable.

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.