Yes. In Microsoft Excel for Microsoft 365 on Windows, select your category labels and numeric data, then choose Insert > Insert Waterfall, Funnel, Stock, Surface or Radar Chart > Radar. Pick Radar, Radar with Markers, or Filled Radar; then format the chart so its scale, labels, and series are easy to compare.
What an Excel radar chart shows
A radar chart, sometimes called a spider chart, plots several categories around a circle. Each category gets a spoke, and the value for each data series is measured outward from the center. Excel connects the plotted values, creating a shape for each series. This makes the chart useful for comparing profiles across a consistent set of measures—for example, rating several products on price, durability, ease of use, and support.
Radar charts work best when the categories are meaningfully related and measured on the same scale. A manager might compare three teams across five skills, with each skill rated from 1 to 5. The resulting shapes can make relative strengths and weaknesses visible at a glance. They are less suitable for showing change over time, precise ranking, or a long list of unrelated measures.
The chart’s circular layout does not mean the categories have a natural order or that values form a continuous measurement. Each spoke is a separate category. The connected lines are a visual guide between those categories, not evidence that a value between two spokes was measured.
Prepare the worksheet data
Arrange the data in a rectangular table before inserting the chart. Put category names in the first column and give each series its own column, with the series name in the header row. For example, a product comparison could have columns named Product A, Product B, and Product C, and rows named Price, Reliability, Comfort, and Setup. Put numeric scores at the intersections.
Excel uses the category labels for the spokes and the column headers as the series names in this layout. Keep the category rows in the order you want them to appear around the chart: changing their order changes the polygon’s shape and can change the impression it gives. Avoid blank header cells, merged cells, subtotals, and text mixed into the score columns. Make sure each score is stored as a number, not as text that merely looks numeric.
- Use the same categories for every series. If one product has no score for a category, decide how to handle that missing value rather than silently omitting the category for that product.
- Use a consistent scoring definition. If 5 means excellent for one measure but poor for another, the chart may be hard to interpret unless you reverse or clearly explain the affected scale.
- Keep the number of categories manageable. A radar chart with a large number of spokes can become crowded and difficult to read.
For a useful example, suppose three services receive ratings from 1 to 5 for Response, Reliability, Features, and Value. Because every rating uses the same scale and the same set of measures, their profiles can be compared fairly. If one column instead contains annual cost in dollars and another contains a 1-to-5 satisfaction score, the raw values should not be plotted together as if they shared a scale.
Create a radar chart in Excel for Windows
- Select the complete data range, including the category labels and series headers. In the example above, that means selecting the header row and all four category rows.
- 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.
- Review the inserted chart. Check that the category names appear around the outside and that each data series has a distinct name in the legend.
- If Excel treated rows as series rather than columns, select the chart and choose Chart Design > Switch Row/Column. Use the option that makes each product or team a series and each measure a category.
- Replace the default chart title with a descriptive one, such as Product ratings by evaluation measure. Keep the table headers clear because Excel uses them for the chart legend and labels.
The three radar choices present the same underlying data in different ways. Radar draws lines between points. Radar with Markers adds a symbol at each measured value, which helps readers identify individual scores. Filled Radar shades the area inside each series, but overlapping fills can obscure one another. For several series, the plain line version or Radar with Markers is often easier to read than filled shapes.
Format the scale, labels, and series
The value scale is a key part of a radar chart. Excel chooses an axis range automatically, but the chosen minimum and maximum may not match the scale readers expect. To inspect it, right-click a value-axis label and choose Format Axis. In the Format Axis pane, review the Bounds and Units settings. For scores defined from 1 to 5, setting a clear minimum and maximum can make the scale easier to understand. If the scale starts at zero, the visual differences may look smaller; if it starts above zero, differences may look larger. Use a range that is appropriate to the data and disclose it when it is not obvious.
Use Chart Design > Add Chart Element to add or adjust chart elements such as a chart title, legend, or data labels. The exact options available can depend on the selected chart and Excel build. A legend is useful when there are multiple series, but avoid relying on color alone: use distinct line styles or markers where possible, and choose colors with enough contrast. Data labels may help for a small chart, but labels on every point can clutter a chart with many categories.
To change a series’ appearance, select its line or marker and use the formatting controls on the Format tab or the Format Data Series pane. Use a restrained set of colors and line weights. If the chart will be printed in grayscale or viewed by people with color-vision differences, test whether the series remain distinguishable without color.
How to read the shape without overclaiming
A point farther from the center represents a larger value on the chart’s scale. If the scale has the same meaning for all categories, that can indicate a stronger rating. But the visual area enclosed by a polygon is not a score, and a larger-looking shape should not be treated as a mathematically valid summary unless a suitable method has been defined. Radar charts emphasize the overall profile, not exact differences between neighboring values.
Category order matters because Excel connects each category to the next. Rotating or rearranging the same values can make the enclosed shape look substantially different even though no score changed. Choose an order that is logical, such as grouping related measures together, and keep that order consistent when comparing charts. For exact comparisons, include the data table or use a bar chart alongside the radar chart.
Also be cautious when comparing series with very different patterns or when the chart contains many overlapping lines. A single high or low value can dominate the shape, while points near the center may be hard to distinguish. The chart is a visual aid, not a substitute for checking the underlying numbers.
Common problems and practical fixes
- The series and categories are reversed. Select the chart and use Chart Design > Switch Row/Column. Then confirm that the legend lists the items you intend to compare and the spokes show the measures.
- The chart has generic labels or a confusing legend. Check the selected range includes the header row and category-name column. Edit those worksheet cells or use Chart Design > Select Data to review the chart’s data range and series names.
- One series looks much larger than the others. Check for inconsistent units, a misplaced value, or an axis range that makes small differences look dramatic. Do not combine raw measurements with unlike units and assume the chart makes them comparable.
- Some categories are missing or appear as zero. Check for blank cells, text values, and inconsistent category rows. If data is genuinely unavailable, document how it is represented; zero means something different from “not measured.” Excel’s chart settings for empty cells can be reviewed through Chart Design > Select Data > Hidden and Empty Cells, where available for the chart.
- The filled chart hides a series. Switch to Radar or Radar with Markers, or reduce the number of plotted series. Transparent fills may help, but overlapping lines and a legend are still important for clarity.
- The chart is hard to read after resizing. Make the chart larger, shorten category labels, reduce the number of categories, or place the legend outside the plot area. Avoid shrinking the chart until labels are cramped.
Radar charts compared with other Excel charts
A radar chart is a reasonable choice when the question is “How does each option’s profile differ across the same set of measures?” For a direct comparison of values category by category, a clustered bar or column chart is often clearer because lengths are easier to compare against a common baseline. A line chart is generally better when the horizontal categories represent ordered time periods or another meaningful sequence. A radar chart’s circular arrangement can imply a relationship between the last and first categories that may not exist.
Use a table when readers need exact values, especially if there are many categories or series. You can also pair a radar chart with a small table or a bar chart: the radar chart communicates the profile, while the table or bars support precise comparisons. The right choice depends on the question, not on which chart looks more elaborate.
Excel versions, sharing, and cost
Creating a radar chart uses Excel’s built-in chart tools; it does not require a separate chart-maker add-in. The steps here target Excel for Microsoft 365 on Windows. Excel for Mac also has radar charts, although ribbon placement and the available insertion routes can differ; if the direct radar-chart button is not visible, use Insert > Recommended Charts and look under All Charts > Radar. Excel for the web has a different interface and may not expose every chart-formatting control found in the desktop app. If a needed option is unavailable, open the workbook in desktop Excel.
When sharing a workbook, include the source data and keep a clear title and legend. If exporting or copying the chart into a presentation, check the labels and colors at the final display size. A chart that looks readable on a large worksheet may become illegible in a small slide or printed report. For accessibility, provide a descriptive title and surrounding text that summarizes the important comparison; readers should not have to infer the message from color or shape alone.
Frequently Asked Questions
Does Excel have a built-in radar chart maker?
Yes. Radar, Radar with Markers, and Filled Radar are built-in chart types. Select a properly arranged data range and use the Insert tab’s radar-chart menu; no add-in is needed for a standard radar chart.
How many categories should a radar chart have?
There is no fixed limit that makes every chart readable. In practice, a small set of related measures is easier to understand than a chart with many spokes. If labels crowd together or lines overlap, reduce the categories or use a bar chart or table.
Can I use different scales for different radar-chart axes?
A standard Excel radar chart uses a shared value scale rather than an independently customized scale for each spoke. Measures with different units or ranges should be converted to a clearly explained common scoring system before comparison, or displayed in separate charts.
Why does my radar chart look wrong after I select the data?
Excel may have interpreted rows and columns in the opposite direction, or the selection may omit headers or labels. Try Chart Design > Switch Row/Column and verify the source range in Chart Design > Select Data.
Which radar-chart type should I choose?
Choose Radar for uncluttered lines, Radar with Markers when individual observations need to stand out, and Filled Radar when only a few series are being compared and overlapping areas will not hide the data. For precise value comparisons, consider a bar chart instead.
Related
- Open Notepad with Excel: Use Both or Import Text Files
- Open a New Excel Spreadsheet: Quick Steps and Options
- OpenOffice Excel Files: How to Open, Edit, and Save
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- How to Reverse Order in Excel Graphs: Axis and SeriesTo reverse the order of categories in an Excel graph, select the chart axis, open Format Axis, and…
- Data Pivot Chart: Meaning, Uses, and How It Works in ExcelA data pivot chart—usually called a PivotChart in Microsoft Excel—is an interactive chart linked to a PivotTable. It…
- Excel Pivot Table: Filter Values Greater Than a NumberTo show PivotTable items whose summarized value exceeds a threshold, open the drop-down for the row or column…
- Free Comparison Chart Template for Excel: How to Build OneYes. You can make a free comparison chart template in Microsoft Excel by listing the options in rows,…
- How to Refresh a Pivot Table in ExcelTo refresh a pivot table in Excel, right-click anywhere inside the pivot table and choose Refresh from the…
- Google Sheets Duplicate Pivot Table: How to Copy OneYes. In Google Sheets, the surest way to duplicate a pivot table and keep it editable is to…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.