Spider Web Chart in Excel: How to Create and Read It

A spider web chart—usually called a radar chart in Microsoft Excel—plots several categories around a circle so you can compare the shape of one or more data profiles. To make one in Excel for Microsoft 365 on Windows, select a well-organized data range, then choose Insert > Insert Waterfall, Funnel, Stock, Surface or Radar Chart > Radar; use Radar with Markers or Filled Radar when those styles suit the data.

What a spider web chart is

A spider web chart is a visual comparison tool built from spokes radiating out from a central point. Each spoke represents a category, and a value is plotted along it. Excel connects the plotted values for each data series, creating a polygon or web-like shape. The chart is also known as a radar chart, web chart, or star plot. In Excel’s chart menu, Radar is the name to look for.

For example, a team might compare three products across battery life, price, durability, portability, and ease of use. Each product becomes a data series, while the five attributes become the spokes. A compact outline can make strengths and weaker areas easy to spot, especially when every attribute uses the same meaningful scale.

The visual is about a profile across categories, not a geographic map or a network of connections. The order of categories around the circle affects the shape, and the chart does not show that one category causes a result in another. It is best read as a summary, with the underlying numbers available for precise comparisons.

How the chart encodes values

Excel places category labels around the perimeter and draws a value axis outward from the center. Concentric rings, when displayed, act like the gridlines on a conventional chart. A larger value lies farther from the center, subject to the axis scale. The points for each series are connected in category order; the final point connects back to the first so the outline closes.

This geometry can be useful for recognizing balance. A roughly even outline may suggest similar performance across the included dimensions, while a pronounced indentation signals a lower value on one spoke. However, the area enclosed by a shape is not a reliable substitute for comparing the individual values. Area changes with both the values and the order of the spokes, so readers should compare points along each spoke, not assume the largest-looking polygon is best overall.

Radar charts can display multiple series, but each series uses the same spokes and scale. Lines that cross or sit close together become harder to distinguish as series are added. The chart is generally clearest with a limited number of categories and a small number of profiles.

Prepare data before inserting the chart

Arrange the worksheet so Excel can identify which labels are categories and which values belong to each series. A common layout puts category names in the first column, series names across the first row, and numeric observations in the cells between them. For example, rows might list attributes and columns might contain Product A, Product B, and Product C. Include the headers when selecting the range.

Use one consistent scale for all the categories, such as ratings from 1 to 5 or scores from 0 to 100.
Use descriptive category and series names; short labels are easier to fit around the chart.
Check that the values are numeric and that the selected range does not include totals or unrelated notes.
Keep category definitions consistent. A score of 5 should mean the same degree of performance across the categories being compared.
Decide on a logical order for the categories, such as grouping related attributes or following a consistent evaluation sequence.

Units matter. Plotting dollars, hours, and a five-point rating together on one radar chart does not create a fair comparison: their ranges and meanings differ. Convert measures to a defensible common scale only when the conversion method is clear, and explain that method to readers. Normalization can make a graphic possible, but it does not make unlike concepts inherently equivalent.

Create a spider web chart in Excel

Put category labels in one column and the series headers in the top row, with the values in the body of the table.
Select the complete range, including its row and column headers.
On the Windows ribbon, choose Insert > Insert Waterfall, Funnel, Stock, Surface or Radar Chart, then select Radar, Radar with Markers, or Filled Radar.
Check that the categories and series are assigned correctly. If Excel has treated columns as categories when you intended rows, choose Chart Design > Switch Row/Column.
Add a clear chart title and adjust the legend, labels, and scale so the comparison can be read without guessing.

Radar draws connected outlines without point markers. Radar with Markers adds a symbol at each observation, which can help readers locate exact category positions. Filled Radar shades the area inside each series; this may work for a single profile but can obscure overlapping series. For a first comparison of several products, the unfilled Radar or Radar with Markers option is often easier to inspect.

Excel for the web also supports creating and editing charts, although ribbon placement and available formatting controls can vary. On Mac, use the Insert tab and the chart controls to choose a Radar chart; menu labels and ribbon organization may differ slightly from Windows. The chart type and the underlying data principles are the same.

Read and format the result

Start by reading one spoke at a time. Locate the grid ring or value-axis label, then compare where each series meets that spoke. A line farther from the center represents a higher value when the scale increases outward. Use the legend to identify each series, and do not infer a difference from color or filled area alone when the lines overlap.

For axis settings in Excel for Windows, right-click a value-axis label or the value axis and choose Format Axis. In the Format Axis pane, use Axis Options to inspect or set bounds and the major unit where available. A fixed, sensible range helps preserve comparisons between charts; an automatic scale can make small differences look dramatic if the range is narrow. If you set bounds manually, show enough labels or gridlines that readers can understand the scale.

Use Chart Design > Add Chart Element to add or adjust elements such as a chart title and legend. Keep the title specific—for example, “Customer ratings by product, 1–5”—and explain what higher values mean. If a spoke’s label is unclear, revise the source header rather than relying on a long explanatory legend. A chart should remain understandable when copied into a presentation or printed separately from the worksheet.

When a radar chart is useful

Radar charts suit situations where the categories describe different dimensions of a profile and are measured on a comparable scale. Examples include comparing service providers on a common rating rubric, assessing a team’s skill levels, or summarizing a product’s performance against a fixed set of criteria. The chart can help prompt questions such as, “Which attribute is consistently weaker?” or “Where do these profiles differ most?”

It is less suitable for showing change over time across many dates, ranking a long list of items, or comparing precise differences. A line chart usually communicates time trends more directly. A bar chart is often clearer for ranking categories, particularly when there are many labels or when readers need to judge small numeric differences. Treat the radar chart as a compact overview, not as proof that a particular option is objectively superior.

Common problems and how to avoid them

Too many spokes: Long labels crowd the perimeter, and many categories make the outline difficult to follow. Reduce the chart to the most relevant measures or use a bar chart or table for the full set.
Too many series: Lines overlap and colors become difficult to distinguish. Show a few important profiles at once, or create separate charts with identical scales.
Different units or ranges: A value of 10 may mean ten dollars in one category and ten hours in another. Use a justified common scale or choose a chart that can show the original units clearly.
Misleading axis bounds: A narrow or inconsistent scale can exaggerate apparent variation. Make bounds explicit and consistent when comparing charts, and tell readers if the scale does not start at zero.
Filled shapes hide one another: Transparent fills may still make overlaps murky. Prefer outlines with markers for several series, or use small multiple charts.
Missing or blank observations: A missing value is not automatically equivalent to zero. Check how Excel displays gaps and decide whether to leave a value missing, explain the omission, or use a documented estimate.

A frequent misconception is that a larger enclosed shape necessarily means a better result. That conclusion is unsafe unless every category has a meaningful direction, the scale is comparable, and the weights of the categories are appropriate. If one dimension matters far more than the others, an unweighted radar chart gives every spoke similar visual prominence and may imply a balance that the decision does not actually use.

Radar chart compared with other charts

A radar chart puts categories around a shared center; a bar chart places them along a straight axis. Straight aligned bars make it easier to compare lengths accurately, so use bars when exact ranking is the main purpose. A line chart is a stronger choice when the horizontal order represents time or another continuous sequence. Radar’s advantage is the compact, circular profile, especially when the category set is fixed and not too large.

A polar chart also uses an angular layout, but it is not automatically the same as a radar chart. A radar chart typically assigns a separate named category to each spoke and connects the values. A polar plot often represents an angle and a distance as coordinate variables. For standard business comparisons in Excel, choose Radar only when the categories are discrete profile dimensions; do not choose it simply because the chart looks circular.

Frequently Asked Questions

Is a spider web chart the same as a radar chart?
Usually, yes. Spider web chart, web chart, and star plot are common names for the chart type Excel calls Radar. Some technical contexts distinguish related polar plots, so check the intended data structure when precision matters.

How do I add a spider web chart in Excel?
Select a table with category labels, series names, and numeric values. Choose Insert > Insert Waterfall, Funnel, Stock, Surface or Radar Chart > Radar, then check the series orientation and format the scale and labels.

Can a radar chart compare negative numbers?
Radar charts are easiest to interpret when values are nonnegative and share a clear scale. Negative values can be confusing because the center and outward direction may not communicate the familiar meaning of a zero baseline. Consider a bar chart or another display that makes positive and negative values explicit.

How many categories should a spider chart have?
There is no fixed limit, but a small set is usually more legible. If labels crowd together or the shape becomes hard to trace, reduce the categories or switch to a bar chart. The right number depends on label length, chart size, and how many series are shown.

Why does my radar chart look wrong in Excel?
Excel may have interpreted rows and columns in the opposite way from your intention. Choose Chart Design > Switch Row/Column and check that category names form the spokes while each item being compared is a separate series. Also confirm that headers and numeric values were included correctly.

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.