To create a radar chart in Excel for Microsoft 365 on Windows, select a table with category labels and one or more numeric series, then choose Insert > Insert Waterfall, Funnel, Stock, Surface or Radar Chart > Radar. Pick a radar style, then use the Chart Design and Format tabs to adjust the chart. The steps below explain how to prepare the data, choose a useful layout, and avoid misleading comparisons.
What a radar chart shows
A radar chart, also called a spider chart, plots several measures from a shared center. Each measure has its own spoke, with categories arranged around the outside. A series of values is marked along those spokes and connected to form a shape. With multiple series, the shapes appear on the same set of spokes, making it possible to compare profiles across several measures at a glance.
For example, a team could compare three products on price, durability, ease of use, support, and battery life. If the categories and scoring scales are consistent, the chart can show which product scores relatively well or poorly on each measure. It is most useful for a modest number of categories and a small number of series; adding many spokes or overlapping shapes can make the result difficult to read.
A radar chart is not a map, and the area inside a shape is not a dependable summary score. The connecting lines and enclosed area are visual aids, not evidence that adjacent measures are related or that a larger shape is a statistically meaningful improvement. Read the individual spoke values, and use a table or another chart when exact comparisons matter.
Prepare the source data
Arrange the data as a simple rectangular table. Put category names in the first column, one category per row, and put each series in its own column. Put the series name in the top cell of its column. For a product comparison, the table could have columns named Measure, Product A, Product B, and Product C, with rows for Price, Durability, Ease of use, Support, and Battery life. Excel uses the first column for the spoke labels and the headings for the series names.
Use numeric values for every plotted measure. If scores come from different units, such as dollars, hours, and ratings out of five, plotting them together on one scale will usually be misleading. Convert them to a comparable scale only when the conversion has a defensible meaning, and explain the scoring method to readers. A common rating scale, such as 1 to 5 for every category, is easier to interpret than a mixture of units.
- Include clear, concise column headings and category labels.
- Keep the same category order for every series.
- Check that values are numbers rather than text that merely looks numeric.
- Decide how missing values should be handled before charting; do not silently substitute zero if zero has a real meaning.
- Keep the number of series and categories manageable so labels and lines remain legible.
For a quick chart, select the table including its headings and category labels. If the data is in nonadjacent ranges, selecting a single contiguous table first is generally simpler and reduces the chance of assigning the wrong labels.
Create the radar chart in Excel
- Select the complete data range, including the category column and series headings.
- On the ribbon, choose Insert > Insert Waterfall, Funnel, Stock, Surface or Radar Chart.
- In the Radar section of the menu, choose Radar, Radar with Markers, or Filled Radar.
- Review the chart. Confirm that the category names appear around the perimeter and that each intended series is represented in the legend.
- Move or resize the chart using its border, and use Chart Design or Format to make the title, legend, and other elements clear.
Radar draws lines between the points. Radar with Markers also makes the individual values visible, which can help when readers need to locate a score on each spoke. Filled Radar shades the area for each series; overlapping fills can hide one another, so this option is often clearest with just one series or with transparency and a restrained palette.
Excel may infer the series direction incorrectly, particularly when the table is arranged differently from the example. Select the chart and choose Chart Design > Switch Row/Column to swap whether rows or columns define the series. Check the legend and spoke labels afterward; the correct arrangement is the one that makes the categories and comparisons match the purpose of the chart.
Choose a radar style and keep it readable
Use the plain Radar style when the overall line pattern matters and the chart has few series. Choose Radar with Markers when values need to be identified at particular spokes. Filled Radar emphasizes the shape, but can suggest that the enclosed area itself is a score and can obscure series beneath it. There is no universally best variant: the right choice depends on how many series overlap and whether the audience needs to read precise values or compare general patterns.
Give the chart a descriptive title, such as Product ratings by measure, rather than a generic title such as Chart Title. Keep category names short enough to fit around the chart. If the names are long, abbreviate them consistently and provide the full terms in a nearby table or note. Use distinguishable line colors, and do not rely on color alone to identify series when the chart may be printed in grayscale or viewed by people with color-vision differences.
To add or change chart elements, select the chart and use Chart Design > Add Chart Element. The available choices include chart titles, legends, and data labels. A legend is useful when several series are present; with only one series, it may be unnecessary. Data labels can make values explicit, but labels on every point can crowd a chart with many categories. Add only what readers need to understand the comparison.
Format the value scale
Excel places value levels along the spokes, with gridlines connecting the levels. The default scale is not always the most informative one. Right-click a value axis or one of its labels and choose Format Axis to inspect the axis settings. Depending on the chart and Excel build, the axis labels may be difficult to select; clicking the labels or gridlines carefully can help. In the Format Axis pane, review the minimum and maximum bounds and the major unit so the scale fits the data and remains easy to interpret.
For a rating that genuinely runs from 0 to 5, keeping the scale from 0 to 5 makes it clear where each score sits within the full rating range. For a comparison where values all fall between 80 and 100, automatically setting a narrow scale could make small differences look dramatic. A fixed, meaningful scale makes charts easier to compare over time or across reports. If you change the bounds, state them when they are not obvious.
Radar charts are especially sensitive to scale choices because every spoke radiates from a shared center. A zero minimum is not automatically appropriate for every measure, but using different effective ranges for different spokes changes the visual meaning of their distances. Avoid manipulating scales to make one series look better. If categories require different units or ranges, a table, small multiple charts, or a carefully documented normalized score may be more honest.
Interpret comparisons carefully
Look at each spoke separately before describing the overall pattern. A product may score highly on support but poorly on price; saying it is simply the “best” would hide the trade-off. Also inspect the numbers in the source table, because points that look close can represent different amounts depending on the scale and the chart’s size.
Category order affects the polygon’s appearance. If categories are reordered, the values stay the same but the connected outline changes. Keep the order consistent when comparing charts, and choose an order that has a clear rationale, such as a workflow or a fixed questionnaire order. Do not arrange categories just to create a more impressive-looking shape.
Another common misconception is that a more symmetrical or larger polygon is automatically better. The chart does not decide which measures matter most, and it does not weight categories according to importance. A high score on a minor measure can visually balance a low score on a critical one. If decisions depend on priorities, show the underlying criteria and values separately rather than expecting the chart’s silhouette to encode them.
Common problems and fixes
- The chart shows the wrong labels. Check that the first column contains categories and the top row contains series names. Try Chart Design > Switch Row/Column if Excel interpreted the table in the opposite direction.
- There is only one line, or too many lines. Review the selected range and confirm that it includes the intended numeric columns and headings. If necessary, select the chart and use Chart Design > Select Data to inspect the chart data range and series.
- The chart looks empty or values bunch near the center. Check for text-formatted numbers, blanks, accidental zeros, and values that are far smaller or larger than the rest. Review the value-axis bounds in Format Axis.
- Series are hard to tell apart. Use Radar with Markers, choose clearer line colors, reduce the number of series, or split comparisons into separate charts. Filled areas often make overlap worse.
- The labels are crowded. Shorten category labels, enlarge the chart, reduce the number of categories, or choose a different chart type. Rotating or shrinking text is not always a useful fix if it makes the labels hard to read.
Radar charts compared with alternatives
A radar chart is useful when the goal is to compare a few profiles across the same set of measures, especially when the overall pattern matters more than a precise ranking. A clustered bar chart is usually easier for comparing exact values category by category because the bars share a common baseline. A line chart is often preferable when the categories represent a meaningful sequence, such as time; radar connects the final category back to the first, which can imply a cycle that may not exist.
A table is often the clearest choice for a small dataset or when exact values and units matter most. If there are many categories or series, consider several small bar charts or separate radar charts with identical scales rather than squeezing everything into one crowded plot. The goal is not to use a radar chart because the data has multiple columns; use it only when the radial layout helps readers see the comparison.
Excel on Mac and Excel for the web
The chart concept is the same in Excel for Mac, although ribbon labels, menu placement, and the chart-type picker can vary by release. Select the data and look for Radar in the chart options on the Insert tab. Chart editing is also available through chart-specific tabs or panes, but exact controls can be arranged differently from Excel for Windows. If a step or option is not visible, check the current ribbon layout and the chart’s context menus.
Excel for the web has a different interface and may not expose every desktop chart-formatting control in the same place. If you cannot find a radar style or a setting needed for precise formatting, open the workbook in the desktop app and make the change there. Review the final chart after editing, particularly if the workbook will be viewed in more than one version of Excel.
Frequently Asked Questions
How do I make a radar chart in Excel?
Select the category labels and numeric data, then choose Insert > Insert Waterfall, Funnel, Stock, Surface or Radar Chart > Radar. Choose a style and check that the labels, series, and scale are correct.
What is the difference between radar and filled radar?
Radar connects each series’ values with lines. Filled Radar shades the area inside each series’ outline. Filled charts can make overlapping series harder to distinguish, so ordinary Radar or Radar with Markers is often clearer for multiple series.
Can I change the categories around the chart?
Yes. Reorder the category rows in the source data, or change their order there and check the chart. The outline changes when the order changes, even though the values do not. Keep the order consistent when comparing multiple charts.
Why does my radar chart look distorted?
Check whether the measures use comparable units, whether the value-axis bounds are appropriate, and whether one unusually large value is stretching the scale. Also remember that the polygon’s area can exaggerate visual differences and is not a reliable standalone score.
When should I use a bar chart instead?
Use a bar chart when readers need to compare exact values across categories or rank items clearly. Bars share a common baseline, while radar spokes point in different directions and can make small differences harder to judge.
Related
- New Employee Training Schedule Template in Excel
- New Hire Checklist Template in Excel: What to Include
- Can’t Insert an Image in Excel? Causes, Checks, and Fixes
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Create a Pareto Chart in Excel: Steps, Tips, and ExamplesTo create a Pareto chart in Excel for Microsoft 365 on Windows, select a table containing category names…
- Excel Dashboard Images: Add, Format, and Keep Them ClearTo add an image to an Excel dashboard in Microsoft 365 for Windows, select Insert > Pictures >…
- How to Add a Funnel Chart in Excel: Steps and TipsTo add a funnel chart in Excel for Microsoft 365 on Windows, put each process stage in one…
- Excel Pie Chart from a Table: Create and Format ItTo make an Excel pie chart from a table, select the category names and their numeric values, then…
- Pareto Chart in Excel: Use Word Labels and CountsYes—an Excel Pareto chart can use words such as “Late delivery” or “Damaged item” as category labels, with…
- OEE Waterfall Chart in Excel: Build and Interpret ResultsTo make an OEE waterfall chart in Excel, put the starting 100% and each staged loss in a…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.