Creating a Radar Chart in Excel: A Clear Step-by-Step Guide

Charts & pivot tables · Updated November 19, 2026

To create a radar chart in Excel for Microsoft 365 on Windows, arrange category labels in the first column and one or more numeric data series in adjacent columns, select the whole table, then choose Insert > Insert Waterfall, Funnel, Stock, Surface or Radar Chart > Radar. Pick Radar with Markers or Filled Radar if that better suits the data, then add a title and check that every series uses the same meaningful scale.

What a Radar Chart Shows

A radar chart, also called a spider chart, plots several categories around a circle. Each category has a spoke extending from a central point, and values are positioned along that spoke. Excel connects the points for each data series, making a shape that can help readers see a profile across multiple measures.

For example, a team might score three products on ease of use, reliability, speed, support, and price, using a consistent scale from 1 to 5. A radar chart can show whether one product has a more even profile or stands out on particular measures. It is most useful for a modest number of related categories with a shared measurement scale.

The shape is a visual summary, not a statistical score. A larger-looking area does not automatically mean a better result, and the chart does not establish why one category differs from another. Readers should be able to see the underlying values or a supporting table when precision matters.

Prepare the Data in a Clear Layout

Excel reads a radar chart from a rectangular range. Put category names in the first column and give each data series its own column, with a header in the top row. Each subsequent row should represent one category. For instance, a table comparing products could look like this:

  • Column A: Measure, followed by Ease of use, Reliability, Speed, Support, and Price.
  • Column B: Product A, with one score for each measure.
  • Column C: Product B, with one score for each measure.
  • Column D: Product C, with one score for each measure.

Use actual numbers for values, not text such as high or medium. Keep the scoring direction consistent: if a high score means good performance for most measures, avoid making a high value mean greater cost unless you explain or transform the cost measure. Otherwise the chart can make a poor result look strong. One option is to convert all measures to a common rating where a larger number always represents the preferred outcome.

Use a comparable range for every measure. Scores on a 1-to-5 scale can be compared directly; a response time measured in seconds and a satisfaction score out of 10 cannot be fairly compared on the same chart without a deliberate, documented rescaling. Do not rescale simply to make the chart look more balanced, since that can obscure the real differences. Keep category names concise, and avoid including totals or averages as if they were additional categories.

Insert a Radar Chart in Excel

  1. Click a cell in the data table, or select the full range including headers and category labels. For the example above, select the Measure column and all product columns.
  2. On the ribbon, choose Insert > Insert Waterfall, Funnel, Stock, Surface or Radar Chart in the Charts group.
  3. In the Radar section of the menu, select Radar, Radar with Markers, or Filled Radar. Excel inserts the chart on the worksheet.
  4. Click the chart title and type a specific title, such as Product scores across five measures. If the title is not displayed, use Chart Design > Add Chart Element > Chart Title.
  5. Check the legend and category labels. If Excel has treated the rows and columns in the opposite way from what you intended, select the chart and choose Chart Design > Switch Row/Column.

On Excel for Mac, the same chart types are generally available from the Insert tab, although the ribbon layout and grouping can differ by release. In Excel for the web, chart creation and basic formatting are available, but some advanced formatting options may be located differently or may be more limited than in the desktop application.

Choose the Right Radar Chart Type

Excel offers three common radar variants, and the best choice depends on how many series and categories the chart contains:

  • Radar: Connects each series with lines. It is often the clearest option when comparing a few series because overlapping filled areas do not hide as much information.
  • Radar with Markers: Adds a marker at each category value as well as connecting lines. Markers make individual observations easier to locate, particularly when there are only a few categories.
  • Filled Radar: Fills the area inside each series. This can emphasize a single profile, but multiple translucent or solid fills can overlap and make comparisons difficult. Use it cautiously when several series are present.

More series do not necessarily make the chart more informative. If several lines cross repeatedly, use fewer series, split the comparison into separate charts, or choose a different chart form. A radar chart with a handful of categories and a small number of series is usually easier to read than one containing a long list of measures and many competitors.

Format the Chart for Readability

Select the chart to reveal the Chart Design and Format tabs. Chart Design includes options for changing the chart type, selecting data, switching rows and columns, choosing a style, and adding chart elements. Use Chart Design > Add Chart Element to add or adjust items such as the chart title, legend, and data labels. A descriptive title should identify what is being compared and, where needed, the scoring period or scale.

The value axis is arranged radially, while the category labels sit around the outside. To adjust the value range, right-click a value-axis label and choose Format Axis. In the Format Axis pane, inspect Axis Options and set the minimum and maximum bounds when those controls are available. For ratings that run from 1 to 5, a 0-to-5 axis is often easier to interpret than a truncated range, but the right bounds depend on the measure and the message. Apply identical bounds to charts being compared side by side.

Use distinct, high-contrast line colors and keep the legend labels meaningful. If the lines are hard to distinguish, markers or direct data labels may help, but labeling every point can clutter a chart. Remove decorative effects that compete with the data. If the worksheet already has a clear table, keep it near the chart so readers can check exact scores rather than estimating them from the spokes.

Interpret the Shape Without Overstating It

Radar charts make uneven profiles visually apparent: a series may extend farther on reliability but fall short on speed, for example. That can prompt a useful discussion about trade-offs. Still, the eye can misjudge distances and areas in a circular plot, especially when values are close together or the scale starts above zero. Read the axis labels and verify important comparisons against the source numbers.

Category order also affects the outline. Excel follows the order of the categories in the source table, so moving a row changes which measures sit beside one another and can change the apparent shape, even though the values have not changed. Arrange categories in a logical, stable order—perhaps by workflow, importance, or a consistent sequence—and document that order if charts will be compared over time.

A radar chart does not show a trend over time particularly well, even if the categories happen to be months. A line chart is usually clearer for time series because it preserves chronological order on a straight axis. Likewise, radar-chart area should not be treated as a reliable total or an overall performance score; the visual area depends on the scale and the placement of categories.

Common Problems and How to Fix Them

  • The categories and series are reversed: Select the chart and choose Chart Design > Switch Row/Column. If the layout is still confusing, confirm that category labels are in one column and series names are in the header row.
  • Excel includes headers as data or omits a category: Choose Chart Design > Select Data and review the chart data range and series names. Adjust the range so it includes the intended headers and values, but not unrelated cells.
  • The chart looks distorted or makes a comparison seem unfair: Check whether measures use different units, score directions, or axis limits. Put measures on a comparable scale before plotting them, and explain any conversion.
  • Lines and fills overlap: Reduce the number of series, switch from Filled Radar to Radar with Markers, or make separate charts for different groups. Changing colors alone will not solve a chart that contains too much information.
  • A series appears incomplete or unexpectedly flat: Check the source cells for blanks, text values, or zeros. Confirm that the intended cells are included in the selected range and that the values are numeric. A genuine zero is different from a missing response, so do not replace blanks with zero unless zero is the correct meaning.

When to Use a Different Chart

A radar chart is a reasonable choice when the question is about the shape of a small, multivariable profile and all measures can be compared on a consistent scale. If the reader needs to rank values precisely, a clustered bar chart is often clearer because bar lengths share a straight baseline. For a long list of categories, a sorted bar chart is easier to scan. For a time trend, use a line chart; for a relationship between two numeric measures, use a scatter chart.

Another option is a table with conditional formatting. It keeps exact values visible while color helps readers spot high and low results. This can be more accessible than relying on colored lines and is often preferable when a report needs precise comparisons. Choose the display that answers the reader’s question, rather than choosing a radar chart only because it is visually distinctive.

Frequently Asked Questions

How do I add another data series to a radar chart?
Select the chart and choose Chart Design > Select Data. In the Select Data Source dialog, add a series and specify its name and value range, or expand the chart’s source range to include the new column. Check that its values align with the existing category labels.

Can I make a radar chart with only one data series?
Yes. A single series can show a profile across categories, and Radar with Markers can make its individual values easier to see. A bar chart may be more straightforward if the main task is simply comparing category values from highest to lowest.

Why does my radar chart start at zero?
Excel uses a value axis for the plotted numbers. Select or right-click a value-axis label, choose Format Axis, and review the bounds in Axis Options. For honest comparisons, use a range that reflects the scoring system and apply consistent bounds to charts being compared.

Can I change the order of the radar chart categories?
Yes. Reorder the category rows in the source table, and the chart will follow that order. Because the outline can look different after categories move, use a deliberate ordering and keep it consistent when comparing multiple charts.

Can I create a radar chart in Excel for the web?
Excel for the web supports creating charts, but some chart-formatting controls may differ from or be less extensive than those in Excel for Microsoft 365 on Windows. If a specific radar option or axis control is unavailable, open the workbook in the desktop app and use the Insert and Chart Design ribbon commands.

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.