Radar Chart in Excel: How to Create and Format One

Charts & pivot tables · Updated November 20, 2026

To make a radar chart in Excel for Microsoft 365 on Windows, arrange your categories in the first column and each data series in its own column, select the full table, then choose Insert > Insert Waterfall, Funnel, Stock, Surface or Radar Chart > Radar. Choose Radar, Radar with Markers, or Filled Radar, then adjust the chart title, scale, and series formatting so readers can compare the values fairly.

What a radar chart shows

A radar chart, also called a spider chart or web chart, displays several numeric measures around a circular plot. Each measure has an axis that starts near the center and extends outward. A value is plotted along each axis, and Excel connects the points in a series to form a shape. The category labels sit around the outside of the chart.

This layout is useful when you want to compare profiles across the same set of measures, rather than show change over time. For example, a team could compare products by battery life, durability, price score, ease of use, and support. A radar chart makes the overall patterns visible: one product might score strongly on durability but poorly on price, while another has a more balanced set of scores.

The chart is not a literal map of total performance. The filled area can look persuasive, but its size depends on the chosen scale and the arrangement of categories. Read the individual values or labels as well as the outline, especially when the differences are small.

Prepare the data before inserting the chart

Set up the worksheet with one category per row and one data series per column. Put a heading above each series and a category name beside each row. Excel uses the first row and first column of a selected range as labels when it can identify them. A small example might look like this:

Measure Product A Product B
Battery life 4 3
Durability 5 4
Ease of use 3 5
Support 4 3
Value 2 4

Here, the ratings use a common scale from 1 to 5, with 5 representing the strongest rating. The first column supplies the axes, and each product is a separate series. Keep the measure names concise; long labels can crowd the perimeter. Make sure every series uses the same categories in the same order, and avoid blank rows or columns inside the selected range.

Radar charts work best when the measures are comparable and share a meaningful scale. If one column is a percentage from 0 to 100 and another is a rating from 1 to 5, the larger numeric range can dominate the display. Convert the measures to a common scale only when that conversion is defensible, and explain the method to readers. Do not silently rescale data just to make the shapes look more alike.

Create the radar chart step by step

  1. Select the table. Include the category labels, series headings, and all the values. In the sample above, that means selecting the entire table, including its header row and first column.
  2. Insert the chart. Open the Insert tab. In the Charts group, choose Insert Waterfall, Funnel, Stock, Surface or Radar Chart, then select Radar, Radar with Markers, or Filled Radar. The plain Radar option draws connected lines; Radar with Markers adds a marker at each category; Filled Radar colors the area inside each series outline.
  3. Check Excel’s interpretation. Excel usually treats the first column as categories and each remaining column as a series. If the chart instead treats each row as a series, select the chart and choose Chart Design > Switch Row/Column.
  4. Add a clear title. Select the chart title and replace the placeholder with a concise description, such as Product ratings by measure. Include the rating scale or data period in the title or a nearby note if that information is not obvious.
  5. Review labels and scale. Confirm that the measure names are legible and that the radial value scale represents the data appropriately. Format the axis if Excel’s automatic bounds make comparison difficult.

When the chart is selected, Excel displays the Chart Design and Format tabs. These contextual tabs provide chart-specific commands. If you do not see them, click the chart once. To change between radar variants later, use Chart Design > Change Chart Type and select the desired Radar option.

Choose the right radar chart type

The three radar options emphasize different things. A standard Radar chart draws a line around each series and is often the clearest choice when there are several series. Radar with Markers makes the plotted value at each category easier to locate, which can help when the number of measures is modest or the values need attention individually. Markers may clutter a chart with many categories.

Filled Radar shades the region within each series. It can make a single profile easy to see, but overlapping filled regions conceal one another. With two or more series, use transparency if appropriate and check that all outlines remain visible; alternatively, choose an unfilled style. Filled shapes can also make a small difference look more dramatic than the underlying numbers justify.

Limit the number of series where possible. A chart with many products, people, or teams creates a tangle of lines and makes the legend hard to use. Consider displaying a small, relevant selection, splitting the comparison into several charts with identical scales, or using a different chart type. Do not remove inconvenient observations without explaining the selection.

Format the axes and series for fair comparison

To set the numeric range, right-click a value on the radial value axis and choose Format Axis. In the Format Axis pane, open Axis Options and review the Bounds and Units controls. Set a minimum, maximum, or major unit when a fixed scale is important, such as a rating that always runs from 0 to 5. The exact controls available can depend on the chart and data. If you cannot select the value axis easily, click the chart and use the Current Selection control on the Format tab to locate the value axis.

For the example’s 1-to-5 ratings, using a consistent 0-to-5 axis preserves the full rating scale and makes charts created at different times easier to compare. Starting at 1 may make small differences appear larger because the visual distance from the center no longer represents the complete scale. A nonzero minimum can be appropriate in some analytical contexts, but label it clearly and use the same bound for every chart being compared.

To format a line or marker, select the series and choose Format Data Series, or right-click the selected series and choose Format Data Series. Use distinct line colors and, if needed, different dash styles or markers. Avoid relying on color alone when the chart may be printed in grayscale or viewed by someone with color-vision differences. Keep the legend names specific, and remove a legend only when direct labels or a nearby key make series identities unmistakable.

Use Chart Design > Add Chart Element to add or adjust chart elements such as a legend or data labels. Data labels can help in a chart with only a few categories, but placing a number at every point across several series often makes the plot crowded. One useful compromise is to keep the radar chart for the overall profile and place the source table next to it so readers can check exact values.

Common problems and how to fix them

  • The chart has the wrong categories or series. Check that the first column contains category names and the first row contains series names. Then use Chart Design > Switch Row/Column if the orientation is reversed.
  • Labels are missing or unhelpful. Include the heading row and category column in the selected range. If the chart already exists, use Chart Design > Select Data to review the chart data range and series labels.
  • The shape looks distorted or misleading. Check for inconsistent units, an unsuitable minimum, or different scales across series. Confirm that high values mean the same kind of thing for every category. A high score for cost, for example, might mean expensive rather than good value unless the scoring definition says otherwise.
  • Series overlap and cannot be distinguished. Use fewer series, remove fill, change line styles, or make separate charts with a shared axis scale. Do not interpret hidden portions of a filled series as missing data.
  • A blank or zero value changes the outline. Check whether the cell is truly blank, contains a formula returning an empty string, or contains zero. Those are not interchangeable in charts. Open Chart Design > Select Data and choose Hidden and Empty Cells to review how empty cells are displayed. Verify the result against the source table rather than assuming Excel treats every gap the same way.

Another frequent misconception is that the first and last categories are separate ends of a line. Radar charts wrap around: Excel connects the plotted series around the circle. Category order therefore affects the visual pattern. Put related measures beside each other when that ordering has a clear rationale, and keep the order consistent across charts. Reordering categories can change the apparent outline even though none of the values changed.

When a different chart is clearer

A radar chart is not automatically the best choice just because the data has several categories. Use a clustered bar chart when the main task is to compare exact values across categories; bars share a common baseline, which is often easier to read than distances along separate spokes. A line chart is usually better for ordered time data, because the horizontal sequence carries meaning. A radar chart can imply a circular progression that is not present in an ordinary list of measures.

A table with conditional formatting may be more accessible and precise when readers need to look up many exact scores. A radar chart can still provide a quick overview beside that table. For a small number of profiles with standardized measures, however, a radar chart can be a compact way to highlight balance, strengths, and weaknesses.

Ask what comparison the audience needs to make. If the answer is which item has the greatest value in each category, bars may be clearer. If the answer is how a few items’ overall profiles differ across the same defined measures, radar may be useful. The chart should support the comparison, not substitute for a clear definition of the data.

Frequently Asked Questions

How do I switch the rows and columns in an Excel radar chart?
Select the chart, open Chart Design, and choose Switch Row/Column. Excel will exchange which data appears as categories and which appears as series. Check the legend and axis labels afterward to ensure the new arrangement matches your intent.

Can I make a radar chart with only one data series?
Yes. Select the category labels and the one series of values, then insert a Radar chart. A single series can show a profile clearly, although a bar chart may make individual values easier to compare with one another.

How do I change the maximum value on a radar chart?
Right-click a value on the radial axis, choose Format Axis, and change the Maximum bound under Axis Options. If you are comparing multiple radar charts, use the same minimum and maximum on each so the shapes are not being compared on different scales.

Can a radar chart show percentages?
Yes, as long as the percentages use a consistent meaning and range. Format the source cells as percentages and check the axis labels. If the percentage scale runs from 0% to 100%, make that range clear and use the same bounds in charts intended for direct comparison.

Why does my radar chart look crowded?
Too many categories or series, long labels, markers, and filled areas can all make the plot difficult to read. Reduce clutter by showing fewer series, choosing an unfilled chart, simplifying category names, or splitting the data into separate charts that share a scale.

Final checks before sharing

Before you send or publish the worksheet, compare the plotted values with the source table, verify the category order, and confirm that the axis limits have not changed unintentionally. Give the chart a descriptive title and explain any custom scale or scoring method. If readers need exact numbers, include labels selectively or leave the underlying data table available. These checks help ensure the radar chart communicates a real comparison rather than an attractive but ambiguous shape.

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.