To build a radar chart in Excel, arrange categories in the first column and each data series in its own column, select the complete table, then choose Insert > Insert Waterfall, Funnel, Stock, Surface or Radar Chart > Radar. Pick a radar style, check that the categories and series are plotted in the right direction, and format the scale so the values are easy to compare. Radar charts work best for comparing several measures that share a meaningful scale.
Before you start, decide what each spoke should represent and whether every series uses the same measurement range. A radar chart turns categories into spokes around a central point and plots values outward from the center. It can make a profile of strengths and weaknesses easy to see, but it can also make small differences look dramatic if the scale or data layout is poorly chosen.
What You’ll Need
- Microsoft Excel for Microsoft 365 on Windows, or another recent Excel version with radar charts.
- A small, rectangular table with category labels and one or more numeric data series. Aim for roughly three to eight categories so the chart stays readable.
- Consistent units and a sensible value range. For example, compare ratings all measured from 0 to 10, rather than mixing ratings, percentages, and dollar amounts.
- Optional: a clear chart title and a plan for which series should be compared.
Step-by-Step
- Lay out the data in a simple table. Put the category names down the first column and the series names across the top row. Each cell where a category and series meet should contain a number. For example, use columns named Product A and Product B, with rows for Price, Quality, Ease of use, Support, and Reliability. If the scores are ratings out of 10, use that same scale for every category and product. Keep the table contiguous: avoid blank rows or columns within the data, merged cells, and explanatory notes in the middle of the range.
- Include the headers when selecting the data. Select the entire table, including the category labels and series headings. Including headings helps Excel use them for the chart legend and category labels. If your data is in a formatted Excel table, you can select the table cells directly; otherwise, drag over the rectangular data range. Check that you have not selected totals or unrelated columns, since Excel may treat those values as another series.
- Insert a radar chart. On the Windows ribbon, open Insert, then choose Insert Waterfall, Funnel, Stock, Surface or Radar Chart in the Charts group. Under Radar, select Radar for a plain outline, Radar with Markers to show each plotted point, or Filled Radar to fill the area beneath each series. For a first comparison, Radar with Markers is often the clearest because viewers can see the individual category values as well as the overall shape.
- Check the chart orientation. Excel may interpret rows as series and columns as categories, especially if the table is arranged differently than expected. Click the chart, open the Chart Design tab, and select Switch Row/Column. The chart should show your measures, such as Price and Quality, around the outside as categories, while each product or person appears as a separate series in the legend. If the legend lists category names instead, switch the rows and columns or revise the table layout.
- Choose a chart style that suits the comparison. Use a plain Radar chart when you want uncluttered outlines, or Radar with Markers when the precise points matter. Filled Radar can be useful with one series, but overlapping filled areas can hide one another when there are several series. If the lines are difficult to distinguish, change their colors or line styles rather than adding more visual effects. Keep the number of series low enough that each one can be followed around the chart.
- Add a useful title and review the legend. Select the chart title and type a specific description, such as Product Ratings by Category. If the chart has no title, select the chart, use the Chart Design tab, and choose Add Chart Element > Chart Title. Make sure the legend labels identify the series clearly; names such as Product A and Product B are more helpful than Series 1 and Series 2. If needed, edit the heading cells in the source table, and the chart labels should update.
- Set a readable value scale. Click a number on the value axis, then right-click and choose Format Axis to open the formatting pane. Under Axis Options, review the minimum and maximum bounds and major unit. For scores that run from zero to 10, a minimum of 0 and maximum of 10 usually preserves the full scale and makes comparisons fair. You can set fixed bounds when appropriate, but avoid setting a narrow minimum merely to make differences look larger. The best bounds depend on what the numbers mean and what comparison readers need to make.
- Check category labels, markers, and readability. Confirm that every category label is visible and in a sensible order. If labels are long, shorten them in the source table or widen the chart area. Use Chart Design > Add Chart Element to add or remove chart elements such as a legend or data labels. Data labels can help with a small chart, but labels for every point often create clutter. Finally, compare the plotted values with the source table: a category with a higher score should be farther from the center when the scale increases outward.
On Excel for Mac, the ribbon labels and chart gallery placement can differ by release. Look under Insert for Recommended Charts, then open All Charts and choose Radar; if your version shows a Radar chart option directly in the Insert chart gallery, use that. In Excel for the web, chart tools appear in the browser ribbon and some formatting controls may be more limited than in desktop Excel. The core process remains the same: select the labeled data, insert a radar chart, and verify its orientation and scale.
Common Mistakes
- Mixing incompatible measures. A radar chart does not make different units comparable. A rating out of 10, a time in minutes, and a percentage should not be plotted together without a justified conversion. Their numeric ranges would distort the visual comparison.
- Using too many categories or series. Every category adds a spoke and every series adds another path. A crowded chart can become a tangle of labels and lines. Consider selecting the most important measures or splitting the data into separate charts.
- Starting the value axis above zero without explaining it. A shortened scale can exaggerate differences in the shapes. Use a scale that matches the meaning of the measure and make any nonzero minimum clear to readers.
- Assuming a larger filled area means a better result. The chart’s area is affected by the combination and order of values. Compare the individual spokes and values, not only the apparent size of each shape.
- Leaving blank cells or totals in the selected range. Excel may plot blanks unexpectedly or include a total as another category or series. Select only the actual data and check that each intended value is numeric.
Tips
- Keep category order consistent. Put related measures beside one another, and use the same order whenever you make charts for different groups. The sequence changes the appearance of the connecting lines, so consistent ordering makes separate charts easier to compare.
- Use a shared scale for side-by-side charts. If you compare radar charts in a report, give them the same minimum, maximum, and major unit. Auto-scaled charts can make identical values look different or make unequal values look deceptively similar.
- Use color with restraint. Choose distinct, contrasting line colors and keep each series color consistent across the workbook. Avoid relying on color alone to distinguish series; markers and clear legend names also help readers.
- Consider a table alongside the chart. A radar chart is useful for spotting an overall profile, while a small table gives exact values. Including both is particularly helpful when close scores matter.
- Keep the chart focused. A chart sized large enough for its labels is easier to read than a small chart surrounded by decoration. Remove unnecessary borders or background effects, and use a concise title that explains what is being compared.
Troubleshooting
The chart shows the wrong labels or series. Click the chart and choose Chart Design > Switch Row/Column. If that does not fix it, inspect the source range and move the category names into the first column and series names into the first row. Reinsert the chart if Excel has included the wrong cells.
The chart option is missing or unavailable. First confirm that you are selecting a rectangular range containing category labels and numeric values, not just a single cell or a text-only range. In desktop Excel, check Insert and the chart gallery for Radar. In Excel for the web or on Mac, the gallery may be arranged differently; look under the chart options or Recommended Charts. If the workbook is open in an older or limited spreadsheet app, open it in a current Excel desktop version.
The chart is blank or some values do not appear. Check whether the cells contain numbers rather than numeric-looking text, and inspect the selected range for blank rows or columns. Also look at the axis bounds: if the maximum is lower than some data points, or the minimum is above others, those values may not display as expected. Return the bounds to Automatic to see whether the chart becomes visible, then set suitable bounds if needed.
One series overwhelms the others. Check for an accidental outlier, a different unit, or a scale that is inappropriate for one measure. Correct the source data or separate measures that cannot fairly share a scale. Do not simply compress the axis to make the series look closer; explain any transformation used to make values comparable.
Labels overlap or the chart looks cluttered. Enlarge the chart, shorten category names, reduce the number of series, or remove data labels that are not essential. If filled areas obscure one another, switch to Radar or Radar with Markers. You can also use a separate chart for each group rather than forcing every series onto one plot.
Frequently Asked Questions
What is a radar chart used for?
A radar chart displays multiple categories on spokes radiating from a center point, with one or more series plotted across them. It is useful for comparing profiles, such as survey ratings or product attributes, when the measures use a comparable scale. It is less suitable for showing change over time or precise differences across many categories.
What is the difference between Radar and Filled Radar?
Radar shows the values as lines, while Filled Radar shades the area within each series. The fill can make one series stand out, but overlapping fills can hide other data. Use an outline chart or markers when comparing several series, and consider a filled chart for a single profile.
Can I make a radar chart with only one data series?
Yes. Put the categories in the first column, one series name in the header row, and the values beside the categories. Select the table and insert Radar. A single series can clearly show a profile, though a bar chart may communicate individual category values more directly.
How do I change the order of the spokes?
Reorder the category rows in the source data. Excel uses that order around the chart, so arrange categories in a logical sequence and keep it consistent across comparable charts. Avoid changing the order just to make one series look more favorable.
Can I show the exact values on the chart?
Yes. Select the chart, choose Chart Design > Add Chart Element > Data Labels, and select a label position if available. The exact label options depend on chart layout. If labels overlap, remove them and provide the values in a nearby table instead.
Why does my radar chart look different after I change the axis scale?
The plotted values are positioned relative to the axis bounds, so changing the minimum or maximum changes how far points sit from the center. Use consistent bounds for fair comparisons, and choose limits that reflect the real scale rather than a visual effect.
Related
- Align a Page in Excel for Printing: Center and Position
- How to Align a Picture in an Excel Cell: Step by Step
- How to Align an Image in an Excel Cell and Keep It in Place
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Balanced Graph: Definition, Examples, and Key TestsA balanced graph, in the standard signed-graph sense, is a graph whose edges are marked positive or negative…
- Radar Chart Excel Template: Build and Format a Chart in ExcelA radar chart Excel template is a worksheet that arranges categories and comparable measurements so you can create…
- Unique Excel Chart Designs: Ideas and How to Build ThemUnique Excel chart designs combine a chart type suited to the data with thoughtful formatting, labels, and context.…
- Google Sheets Gantt Chart Formatting GuideTo format a Gantt chart in Google Sheets, arrange tasks in rows, put each task’s start and end…
- Excel Chart Axis Range: Set Minimum and MaximumTo set an Excel chart axis range in Microsoft 365 for Windows, right-click the value axis, choose Format…
- Excel Bar Chart Reverse Order: Steps, Options, and FixesYes. Select the bar chart’s category axis, open Format Axis, and under Axis Options turn on Categories in…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.