To make a radar chart in Excel for Microsoft 365 on Windows, arrange categories in the first column and data series in separate columns, select the whole table, then choose Insert > Insert Waterfall, Funnel, Stock, Surface or Radar Chart > Radar. Pick Radar, Radar with Markers, or Filled Radar, then add a clear title and check that the scale makes the comparison fair.
What a Radar Chart Shows
A radar chart, also called a spider chart or web chart, places each category on an axis that radiates from a shared center. Excel connects the values for each data series, creating a polygon for each series. The shape can make a profile across several measures easy to scan—for example, comparing a product’s price, durability, comfort, and battery life.
Radar charts are most useful when the categories are related dimensions that share a meaningful numeric scale. They are less effective when there are many categories, when the values use unrelated units, or when readers need to compare precise values. The distance from the center represents value, so the axis scale and starting point matter: an axis that starts above zero can make small differences look much larger.
A radar chart does not automatically make unlike measurements comparable. If one category is measured in dollars and another in hours, plotting both as raw numbers may create a misleading shape. Convert the measures to a common scale—such as ratings from 1 to 5—before charting, and explain how you scaled them.
Prepare the Data in a Clear Layout
Use a compact rectangular table with one header row and no blank rows or columns inside the data. Put category names down the first column and give each series its own column. For a product comparison, the table might have Feature in A1, Product A in B1, and Product B in C1, with Battery life, Comfort, Price, and Durability in A2:A5 and a consistent rating for each product in B2:C5.
Keep the categories in the same order for every series. Make sure each value is numeric rather than text, and use the same direction for ratings: for example, a higher score should consistently mean better performance. If lower values are preferable for a measure such as cost, consider transforming or clearly labeling the score so that the chart does not imply that a higher cost is better.
- Use concise category labels; long labels can crowd the perimeter.
- Use a consistent range, such as 0–5 or 0–100, across all categories.
- Limit the number of series so the lines and fills remain distinguishable.
- Include units or a note explaining a rating scale when readers might not know what the values mean.
For a simple rating example, suppose three products are each scored from 1 to 5 on four features. A value of 5 should represent the same level of performance wherever it appears. If the numbers come from different sources or use different scales, normalize them first or choose a different visualization.
Create the Chart in Excel for Microsoft 365
On Windows, create the chart from the selected data range. In the example above, select the complete table, including the headers and category labels, then follow these steps:
- Open the Insert tab on the ribbon.
- In the Charts area, select Insert Waterfall, Funnel, Stock, Surface or Radar Chart.
- Under the Radar choices, select Radar, Radar with Markers, or Filled Radar.
- Click the chart title and replace the placeholder with a descriptive title, such as Product Ratings by Feature.
- Check the legend and category labels. If Excel has treated rows as series or columns as categories, select the chart and use Chart Design > Switch Row/Column.
The ordinary Radar option draws lines between the values. Radar with Markers adds a visible marker at each category, which can help readers identify individual observations. Filled Radar shades the area inside each series shape. With overlapping series, however, filled areas can obscure one another; transparency or an unfilled chart is often easier to read.
Excel usually creates a chart from the selected range immediately. To change which cells it uses later, select the chart and use Chart Design > Select Data. This opens the data-source controls, where you can adjust the chart range or edit a series. If the table will grow, include new rows or columns in the chart’s data source when needed.
Choose the Right Radar Chart Type
The three radar types communicate the same underlying arrangement, but their appearance affects readability. Use the plain Radar type when comparing several series and keeping the intersections visible is important. Use Radar with Markers when the exact category positions need emphasis, particularly with a modest number of categories. Filled Radar is best suited to a small number of series when the overall profile is more important than seeing every crossing line.
Filled shapes can suggest area or magnitude, even though the chart is intended to compare values along separate axes. Overlap can also hide the series drawn underneath. If there are three or more products, start with lines and markers, assign each series a distinct color, and use a legend that clearly identifies them. Avoid relying on color alone if the chart will be printed in grayscale or viewed by readers with color-vision differences.
There is no universal ideal number of axes, but a short list of meaningful dimensions is easier to interpret than a long list. If labels become crowded or the polygon turns into a dense web, remove less important categories or split the comparison into smaller charts.
Format the Scale, Labels, and Appearance
Formatting should clarify the comparison, not decorate it. Select the chart to use the chart-specific ribbon tabs, including Chart Design and Format. Use Chart Design > Add Chart Element to add or adjust items such as a chart title, legend, or data labels where available. A useful title says what is being compared, while a subtitle or nearby note can state the scale and data source.
To change the value-axis bounds, select a value label around the chart, right-click, and choose Format Axis. In the Format Axis pane, review the axis bounds and units. Setting a maximum that matches the rating scale—for instance, 5 for a 0–5 score—can make the chart easier to compare. Avoid choosing a narrow minimum and maximum simply to exaggerate differences. If the chart has a zero baseline, explain any deliberate departure from it.
For readable lines, select a series and use the formatting controls to adjust its line color, width, or marker style. Keep the gridlines visible but subdued. If adding data labels, use them selectively: labels on every point in a crowded chart may overlap. A nearby data table or a small, well-organized source table can be more useful when readers need exact values.
On a Mac, the broad workflow is the same, but ribbon arrangement and some chart-formatting controls can differ. Select the table, open Insert, and look for the Radar chart choices in the Charts controls; then use the chart design and format tabs or panes to edit it. In Excel for the web, chart creation and basic editing are available, but some detailed formatting controls may differ from or be more limited than the Windows desktop app. If a particular setting is not present in the web interface, open the workbook in the desktop version.
Read the Shape Without Overinterpreting It
A point farther from the center represents a higher value on that category’s axis. A broad, outward shape can indicate consistently high scores, while a pronounced inward dip can draw attention to a relative weakness. But the polygon’s area is not a reliable summary score: the visual area depends on axis order and scale, and changing the order can change the shape without changing any data.
For that reason, do not rank products by which polygon looks largest unless the values and scoring method support that conclusion. Read the individual axes and, when precision matters, check the underlying table. Radar charts are useful for an overview of a profile; they are not a substitute for a transparent definition of the measures or a statistical comparison.
Axis order is especially important when categories have a natural sequence, such as stages in a process. For unrelated features, use a consistent, logical order and keep it unchanged across charts. This makes comparisons between versions or groups less confusing.
Fix Common Radar Chart Problems
- The chart shows the wrong categories or series: Select it and choose Chart Design > Switch Row/Column. If that does not fix it, open Chart Design > Select Data and verify the data range and series names.
- The chart looks like a crowded web: Reduce the number of categories or series, use Radar with Markers only when markers remain distinct, and avoid filled areas that cover one another.
- Some points disappear or look unexpectedly low: Check for blank cells, text-formatted numbers, and inconsistent scales. Confirm that every series has a value for each category and that the value-axis bounds are appropriate.
- Category names are missing or confusing: Check that the first column was included in the selected range and that it contains the labels, not empty cells. Shorten lengthy labels in the source table if necessary.
- The shape suggests a result the data do not support: Check whether a high number always means better, whether all values share a scale, and whether the value axis starts at the intended point.
When data are incomplete, do not assume that Excel’s visual treatment of a blank means zero. A blank and a measured value of zero have different meanings. Resolve missing values in the source data or explain how they should be interpreted before presenting the chart.
When Another Chart Is a Better Choice
A radar chart is not automatically the best way to compare multiple measures. A clustered bar chart is usually easier for comparing exact values in a single category, because bars share a straight baseline. A line chart is a more natural choice for values that change over time or follow a meaningful sequence. A table with conditional formatting can work well when the audience needs both exact numbers and quick visual cues.
Choose a radar chart when the main question is how several subjects compare across a small set of common dimensions, and the overall profile matters. Choose bars, lines, or a table when exact ranking, a time trend, many categories, or unrelated measurement units are central. It is also reasonable to show a radar chart alongside a table rather than asking the shape to carry every detail.
Frequently Asked Questions
Can I make a radar chart with only one data series?
Yes. Select the category labels and the single series of values, then insert a Radar chart. One series can show a profile, although it cannot compare subjects against one another.
How do I add another series to an existing radar chart?
Add the values and a header for the new series in the source table, then select the chart and use Chart Design > Select Data to update the chart’s data range or add the series. Check that its values align with the existing category labels.
Can radar chart axes use different scales?
Excel’s radar chart uses a shared value scale for its axes. That is why unrelated units should not be plotted as raw values together. Convert them to a clearly explained common scale or use separate charts.
Why do two radar charts look different when the data are the same?
Different axis order, value-axis bounds, chart types, or series formatting can change the visual impression. Compare the category order and scale settings before interpreting the shapes.
Can I make a radar chart in Excel for the web?
Excel for the web supports chart work, but its available chart-formatting options can differ from desktop Excel. If you cannot find a specific Radar choice or axis setting, open the workbook in Excel for Microsoft 365 on Windows or Mac and make the adjustment there.
Related
- Audit Working Papers Excel Templates Explained
- Excel AutoFilter Dates Before Today
- Excel Data Validation List Autocomplete: How It Works
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Correlation Graph in Excel: Create and Interpret OneTo make a correlation graph in Excel, select two columns of paired numeric data and choose Insert >…
- Excel PivotTable Charts: How to Create and Use ThemTo create an Excel PivotChart in Microsoft 365 for Windows, click a cell in a PivotTable, choose PivotTable…
- Excel 100% Stacked Lines in a Combo ChartYes, you can combine percentage lines with another chart type in Excel, but the most dependable method is…
- Excel Slicer Link to Different Pivot Tables: How It WorksYes. In Excel for Microsoft 365 on Windows, one slicer can filter multiple PivotTables when those PivotTables share…
- Gantt Chart Roadmap Excel Template: Build and Use ItA Gantt chart roadmap Excel template is a spreadsheet that lists project tasks beside a date-based timeline, then…
- Find a Pivot Table in Excel: Locate It Across SheetsTo find an existing PivotTable in Excel, search the workbook for a label or value you know appears…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.