In Excel, a spider web graph is usually called a radar chart. To create one in Microsoft Excel for Microsoft 365 on Windows, arrange your categories in the first column and each data series in its own column, select the table, then choose Insert > Insert Waterfall, Funnel, Stock, Surface or Radar Chart > Radar.
What a spider web graph shows
A radar chart places categories around a circle and plots values along spokes that meet at the center. Excel connects the plotted points for each data series, forming a shape that can resemble a web. The chart is also commonly called a spider chart, web chart, or star plot. Those names generally refer to the same type of visualization.
Radar charts are designed to compare several things across the same set of measures. For example, a manager might compare three product concepts on price, ease of use, durability, and design, with each measure scored from 1 to 5. A larger distance from the center means a higher value on that category’s scale.
The chart is most useful when the categories are meaningfully related and have comparable scales. It is less suitable for showing a trend over time, precise differences between many values, or unrelated quantities with very different units. The shape can be striking, but it does not automatically make a comparison easier to understand.
Arrange the data before inserting the chart
Each row should represent one category, and each column after the category labels should represent a data series. Put descriptive headers in the first row. Excel uses those headers for the legend and the first-column labels around the chart.
| Measure | Concept A | Concept B | Concept C |
|---|---|---|---|
| Price score | 4 | 3 | 2 |
| Ease of use | 3 | 5 | 4 |
| Durability | 5 | 4 | 3 |
| Design | 4 | 3 | 5 |
| Support | 3 | 4 | 4 |
For this example, select the entire range, including the headers and labels. Scores use a common 1-to-5 scale, so they can be compared directly. If your measures use different units—such as dollars, days, and percentages—do not place raw values together without a deliberate plan to make them comparable. A value of 100 dollars and a value of 100 percent do not mean the same thing simply because the numbers match.
- Use short category labels so they remain legible around the circle.
- Keep the same categories and order for every series being compared.
- Check for blank cells, text in numeric columns, and accidental totals included in the selected range.
- Decide whether higher values consistently mean better performance. If not, readers may misread the resulting shapes.
Create the radar chart in Excel
- Arrange the table with category names in the first column, series names in the top row, and numeric values in the body.
- Select the complete data range, including the row and column headers.
- On the ribbon, choose Insert > Insert Waterfall, Funnel, Stock, Surface or Radar Chart.
- Under Radar, choose Radar, Radar with Markers, or Filled Radar.
- Click the chart title and replace it with a specific description, such as Product concept scores.
Radar draws lines between the values, while Radar with Markers also displays a marker at each category. Filled Radar shades the area inside each series, which can make overlapping data difficult to distinguish. For several series, the unfilled version is often easier to read. If Excel places the series and categories in the opposite direction, select the chart and choose Chart Design > Switch Row/Column. Use this only when the rearranged series make sense for your data.
On Excel for Mac, select the data and use the Insert tab’s chart controls to find Radar; ribbon grouping and wording can vary slightly by release. The chart types are equivalent in purpose. The instructions above use Excel for Microsoft 365 on Windows, where the full chart-type menu is available from the Insert tab.
Choose a radar style and format its scale
Use Radar when you want a clean outline, and Radar with Markers when readers need to identify the value at every spoke. Filled Radar can work for two series with distinct colors and little overlap, but transparent fills may still obscure the shapes beneath them. Avoid using a filled chart merely because it looks more dramatic.
To adjust the radial value scale, click a value-axis label or gridline, right-click, and choose Format Axis. In the Format Axis pane, set appropriate bounds and units when Excel’s automatic scale does not suit the comparison. For the sample scores, a scale from 0 to 5 makes the full rating range visible and gives the center a consistent meaning. If you set the minimum to a value above zero, small differences can look much larger than they are; make that choice explicit in the chart or its notes.
Improve readability with a descriptive title, a legend that identifies each series, and a small number of gridlines. Use colors with clear contrast and avoid relying on color alone to identify lines; markers or distinct line styles can help. If a category name is clipped, widen the chart or shorten the label in the source table. Excel updates the chart when the source labels change.
Read the shape without overinterpreting it
In the example, Concept A is strong on durability and price score, while Concept B scores highest on ease of use and support. The chart makes those profiles visible at a glance, but it does not tell you which concept is best overall. That conclusion depends on how important each measure is and whether the scoring method is fair. If durability matters twice as much as design, the chart does not automatically apply that weighting.
Radar charts also make some comparisons harder than they appear. The area enclosed by a shape depends on the order of the categories, so rearranging spokes can change the apparent area without changing any score. The visual distance between adjacent spokes can also be difficult to compare accurately. For exact comparisons, keep the source table available, show data labels when they remain readable, or use a bar chart alongside the radar chart.
Use a radar chart when the goal is to compare a small number of profiles across a fixed set of dimensions. If the audience needs to rank values precisely, a sorted bar chart or a table with conditional formatting is often clearer. The chart is a summary, not a replacement for defining the measures, rating scale, or source of the data.
Common problems and how to fix them
- The categories appear in the legend. Excel may have interpreted rows and columns differently than intended. Try Chart Design > Switch Row/Column, then check whether the legend now lists the data series and the spokes show the category labels.
- The chart has one series or unexpected labels. Confirm that the selected range includes all intended numeric columns, the header row, and the category column. Remove blank rows or columns inside the range if they are confusing the chart layout.
- The lines look crowded. Reduce the number of series, remove unnecessary markers, or use separate charts. Filled Radar is particularly hard to read when several shapes overlap.
- One series dominates the chart. Check whether the values share a meaningful scale and whether a single unusually large value is stretching the axis. Do not hide a real outlier just to make the shapes look balanced; explain the scale or use another chart type.
- Negative values or missing values look confusing. Radar charts are not a good default for data with negative scores or substantial gaps. Verify how Excel plots the specific values and consider a line, bar, or scatter chart if zero and negative differences are central to the story.
Radar charts compared with alternatives
A radar chart and a line chart can both show multiple series, but their layouts imply different things. A line chart usually places an ordered sequence—often time—along a horizontal axis. A radar chart wraps categories around a circle. The circular arrangement is useful for profiles, but it does not create a meaningful beginning, end, or continuous cycle unless the categories genuinely have that structure.
A bar chart is usually the better choice when readers need to compare one measure at a time or rank many items. A table is more precise when exact values matter. A scatter chart is better for examining the relationship between two numeric variables. A radar chart earns its place when the reader needs to compare a handful of multi-measure profiles, not simply because the data contains several columns.
Frequently Asked Questions
Is a spider web graph the same as a radar chart?
Usually, yes. In Excel, the chart type is named Radar. Spider chart and spider web graph are common alternative names for the same circular chart with category spokes and connected values.
How many categories should a radar chart have?
There is no fixed technical limit, but a modest number is easier to read. Too many spokes make labels and shape differences difficult to follow. If the categories become crowded, split them into related charts or choose a bar chart.
Can I make a spider web graph with only one data series?
Yes. Select a category column and one numeric series, including their headers, and insert a Radar chart. A single series can show a profile, although there is no second shape to compare against.
How do I show values on the radar chart?
Select the chart, then choose Chart Design > Add Chart Element > Data Labels and select a label position. Labels can overlap when categories or series are numerous, so use them selectively and keep the original data table nearby for precise values.
Why does my radar chart look different after changing the category order?
Excel connects each category’s value to the next one around the circle. Changing the order changes which points are adjacent and therefore changes the outline, even though the underlying scores are unchanged. Keep category order consistent when comparing charts.
Can I make a spider web chart in Excel Online?
Excel for the web supports many common chart tasks, but chart creation and formatting options can differ from the Windows desktop application. If Radar is unavailable in the controls you see, create or edit the chart in Excel for Microsoft 365 on Windows or Mac, then reopen the workbook in the browser.
Related
- Excel Data Analysis: Methods, Tools, and Examples
- Excel GIS Data Analysis: Maps, Methods, and Limits Explained
- Excel Historical Data Analysis: Methods and Examples
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Pivot Chart Axis Options in Excel: What You Can ChangeIn Excel for Microsoft 365 on Windows, PivotChart axis options let you control what appears on the category…
- Power Pivot Troubleshooting: Fix Common Excel IssuesTo troubleshoot Power Pivot in Excel for Microsoft 365 on Windows, first confirm the Power Pivot add-in is…
- Link a Pivot Chart to a Slicer in ExcelTo link a slicer to an Excel PivotChart, select the PivotTable or PivotChart, choose PivotTable Analyze > Insert…
- Excel Pivot Table Value Field Settings: How They WorkExcel PivotTable value field settings control how a field in the Values area is summarized and how its…
- Pivot Table Value Filter Not Working? Fix It in ExcelIf a PivotTable value filter is not working, first confirm that you applied it to a field in…
- Excel Pie Chart Labels: Add, Format, and TroubleshootTo add labels to an Excel pie chart, select the chart and choose Chart Design > Add Chart…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.