In Excel for Microsoft 365 on Windows, a spiderweb graph is called a Radar chart. Select your category labels and data, then choose Insert > Insert Waterfall, Funnel, Stock, Surface, or Radar Chart > Radar to create one.
What a spiderweb graph shows
A spiderweb graph, also known as a radar chart or spider chart, compares several measures arranged around a central point. Each measure has its own spoke, and the values are plotted along that spoke; connecting the points creates a polygon for each data series. The result resembles a web, which is the source of the informal name.
Radar charts are useful when the categories form a meaningful profile, such as a set of skills, product attributes, or performance measures. For example, a team might compare several products on price, durability, ease of use, support, and battery life. If every measure uses the same scoring scale, the shapes can give a quick visual sense of where each product is relatively strong or weak.
The chart is not a map of locations, and the categories do not have to be arranged by size. Instead, each spoke represents a distinct measure. The visual comparison depends on how values sit relative to the center and to the other values on the same spoke. Because the polygon’s area can make differences look more dramatic than they are, read the individual axis values as well as the overall shape.
Prepare the worksheet data
Arrange data in a simple table before inserting the chart. Put the category names in the first column and give each data series its own column. The first row should contain series names. For example:
| Measure | Product A | Product B |
|---|---|---|
| Comfort | 4 | 3 |
| Durability | 5 | 4 |
| Ease of use | 3 | 5 |
| Support | 4 | 3 |
| Value | 3 | 4 |
In this example, each product is a series and each measure is a category. Scores on a common 1-to-5 scale make a reasonable comparison. If one column represents a score out of 5 and another represents dollars or percentages, the chart will not offer a meaningful direct comparison without first converting the measures to a comparable scale. Do not normalize data merely to make the chart look balanced; choose a transformation only when it suits the question and explain it to readers.
Keep labels concise, use one row per category, and avoid blank rows or merged cells within the selected range. A radar chart can plot numeric values, but text, blanks, and errors may produce missing or confusing points. Check that high values mean the same kind of thing across measures. For instance, a high satisfaction score is favorable, whereas a high defect count may be unfavorable. Consider reversing or otherwise clarifying such measures before comparing profiles.
Create a radar chart in Excel
- Select the complete data range, including the category labels and series names. In the sample layout above, that would be the heading row and all five measure rows.
- Open the Insert tab. In the Charts group, choose Insert Waterfall, Funnel, Stock, Surface, or Radar Chart, then choose Radar.
- Review the chart title, legend, category labels, and plotted series. If Excel places the categories and series in the wrong direction, select the chart and choose Chart Design > Switch Row/Column.
- Replace the default chart title with a descriptive one, such as Product attribute scores. Keep the source table nearby so viewers can check exact values.
Excel may show a chart with default colors and formatting. That is a starting point, not a requirement to keep every default. Select the chart to reveal the Chart Design and Format tabs. On Excel for Mac, chart insertion is also available from the Insert tab, but the ribbon layout and chart-menu labels can differ between versions; look for the Radar chart category in the chart insertion controls. Excel for the web has a different interface and may not expose every formatting control found in the desktop app.
Choose the right radar chart type
Excel offers several radar variations. The basic Radar chart draws lines between each series’ points. Radar with Markers adds a marker at each category, making it easier to see where observations occur. Filled Radar colors the area inside each series’ polygon. The available choices appear under the Radar chart menu when inserting or changing a chart.
For most comparisons, the basic line chart or Radar with Markers is the clearest choice. Markers help distinguish individual measurements when the categories are close together. Filled Radar can work when there is only one series, or when series do not overlap much. With several filled series, opaque or partly transparent areas can cover one another, so viewers may have trouble telling which data belongs to which group.
Changing the chart type later is possible: select the chart and use Chart Design > Change Chart Type, then choose a Radar option. Changing type does not repair inconsistent units or misleading scales, so confirm the underlying data and comparison method first.
Format the scale and labels
The scale determines how far values extend from the center. Excel uses a value axis for the plotted measurements, while category labels appear around the perimeter. Select a value-axis label or gridline and open Format Axis to review its bounds and units. Set a sensible minimum and maximum when Excel’s automatic scale makes comparisons hard to interpret. For scores from 1 to 5, for example, a scale that begins at zero may make the differences look smaller than a scale beginning at 1; either choice can be defensible, but the chart should make the chosen range clear.
Use a consistent range for charts that readers will compare side by side. If one chart runs from 0 to 5 and another from 0 to 100, their polygon sizes cannot be compared directly. Avoid tightening the scale just to exaggerate small differences. A clearly labeled axis, visible gridlines, or a note stating the scale helps prevent misreading.
For other formatting, select a chart element and use the Format tab or the Chart Design tab. Chart Design > Add Chart Element provides options such as chart titles, legends, and gridlines. Use a short title and a legend with meaningful series names. If labels around the perimeter are crowded, shorten the category names in the source data or enlarge the chart area. Use distinct line colors and adequate contrast; do not rely on color alone to distinguish series if the chart may be printed in grayscale or viewed by people with color-vision differences.
How to read the shape without overclaiming
A point farther from the center indicates a larger value on that category’s scale. A series that extends farther out on several spokes may have higher measurements there, but that does not automatically mean it is better overall. The direction of “better” depends on what each measure represents, and a chart does not assign importance or weights to categories.
The order of categories affects the apparent shape. Excel connects each category to its neighbor and joins the last category back to the first, so rearranging the spokes changes the polygon even though the data values stay the same. Put related measures next to each other when that makes the profile easier to follow, and use the same order across charts being compared. Do not treat the enclosed area as a precise total or ranking unless a valid method for that interpretation has been defined.
When exact differences matter, supplement the radar chart with a table or another chart. A reader may see that one series is generally larger but still be unable to estimate whether a difference is 1 point or 10 points from the polygon alone.
Common problems and practical fixes
- The chart has the wrong number of series or categories: Check whether Excel interpreted rows or columns as series. Use Chart Design > Switch Row/Column, or select Chart Design > Select Data to review the plotted ranges.
- Some points are missing: Inspect the source range for blank cells, text in numeric columns, or error values. Confirm that the chart’s data range includes the intended rows and columns.
- The chart looks crowded: Reduce the number of categories or series, shorten labels, and use a larger chart. A crowded radar chart is often a sign that a table or a different chart type would communicate the information better.
- One series seems to dominate: Check whether measures use different units or ranges. Use comparable measures and disclose any rescaling; changing the axis alone cannot make fundamentally different units comparable.
- Filled areas hide one another: Switch to Radar or Radar with Markers, reduce the number of series, or use clearly distinct line styles and colors.
- The shape changes unexpectedly after editing: Confirm that the category order and axis bounds remain consistent. Adding a category changes the connecting polygon, even if existing values are unchanged.
A common misconception is that Excel’s radar chart automatically rates a group or calculates an overall score. It does neither: it plots the values provided. If an overall score is needed, define the calculation separately and explain its weights and assumptions rather than inferring it from the polygon’s area.
When to choose a different chart
A radar chart is most useful for a small number of categories that describe a profile and share a comparable scale. It can become difficult to read with many series, long labels, or measurements on unlike scales. A line chart is often easier when the categories have a natural sequence, such as time periods. A clustered bar chart is usually clearer for comparing exact values across categories, while a table is often best when the audience needs precise numbers rather than a quick visual overview.
For example, comparing three fictional service plans across five equally scored attributes could work well as a radar chart. Comparing twenty plans across fifteen attributes would create many overlapping lines and labels. A bar chart, a filtered table, or several focused charts would generally be easier to interpret. Choose the display based on the question, not simply because the data can be plotted as a web.
Frequently Asked Questions
What is a spiderweb graph called in Excel?
Excel calls it a Radar chart. You may also see the terms spider chart or web chart used informally for the same chart family.
How do I add another series to a radar chart?
Add a new series name and its values in the source table, then select the chart and use Chart Design > Select Data to adjust the chart’s data range if Excel does not include the new cells automatically.
Can a radar chart contain negative values?
Excel can plot numeric values on a value axis, but negative measurements may be visually awkward because radar charts are usually read outward from a central minimum. Check the axis behavior and whether another chart type would represent negative and positive values more clearly.
Why do two radar charts look different when their data is similar?
They may use different value-axis bounds, category orders, or numbers of categories. For a fair visual comparison, use the same scale and category order and make any differences in chart settings explicit.
Is a filled radar chart better than a regular radar chart?
Not necessarily. A filled version emphasizes the area and can be effective for a single profile, but overlapping fills can obscure values when there are several series. Lines or markers are usually easier to compare in that situation.
Related
- Scatter Plot in Excel With Two Variables
- Scatter Plot Excel: How to Label Every Point With Names
- Scatter Plot in Excel: Show Multiple Variables Clearly
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Excel Line Graph Sparklines: Create and Format ThemIn Excel for Microsoft 365 on Windows, create a line graph sparkline by selecting the cell where it…
- Excel Trendline for All Series: How It WorksNo—Excel does not add one trendline that automatically fits every chart series together. In Microsoft 365 for Windows,…
- Power Pivot Not Working? Fix Common Excel ProblemsIf Power Pivot is not working in Excel for Microsoft 365 on Windows, first enable its COM add-in:…
- Excel Line Chart: How to Add a Vertical Reference LineTo add a vertical line to an Excel line chart, use Insert > Shapes > Line for a…
- Excel Dashboard Inspo: Ideas, Layouts, and Design TipsFor Excel dashboard inspo, start with one clear question your dashboard should answer, then build a compact view…
- Data Source Reference Error in Pivot Tables: FixesThe Excel message Data source reference is not valid means the PivotTable cannot use the range, table, named…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.