Spider Web Chart in Excel: Create and Format a Radar Chart

To make a spider web chart in Excel for Microsoft 365 on Windows, arrange your categories in the first column and each data series in its own column, select the full table, then choose Insert > Insert Waterfall, Funnel, Stock, Surface or Radar Chart > Radar. Excel calls this chart type a radar chart; its circular grid and radiating category axes create the spider-web appearance.

What a spider web chart shows

A spider web chart, also called a radar chart or spider chart, compares several observations across the same set of categories. Each category gets an axis that extends from the center of the chart toward the edge. Values are plotted along those axes, and Excel connects the points for each data series to form a polygon. The circular or polygonal gridlines act as a scale, much like the horizontal gridlines in a column chart.

For example, a team might rate three products on ease of use, speed, customer support, features, and reliability. A separate polygon for each product makes it possible to see where its strengths and weaker scores sit relative to the others. Radar charts are most useful for a compact profile across a modest number of comparable measures, not for reading precise values or displaying a long list of categories.

The chart shape can be visually striking, but it is not a literal picture of a product’s overall quality. The area enclosed by a polygon can make small differences look substantial, and the visual impression depends on the scale and the order of categories. Read the axis values and underlying table rather than treating a larger-looking shape as a definitive ranking.

Prepare the data before inserting the chart

Excel needs one set of category labels and one or more numeric series. A straightforward layout has a header row for the series names, category names down the first column, and a value at every intersection. For instance:

Measure	Product A	Product B	Product C
Ease of use	4	3	5
Speed	3	5	4
Customer support	5	3	4
Features	4	5	3
Reliability	5	4	4

Here, the values are illustrative ratings on a consistent scale from 1 to 5, with higher meaning better. If one measure is an amount where lower is better, such as defect rate or response time, decide how to make its direction comparable before charting. You might convert it to a clearly defined score, or keep it separate and explain the interpretation. Mixing raw seconds, dollar amounts, and five-point ratings on one radar chart generally produces a confusing comparison.

Use a short, clear label for each category and a distinct header for every series.
Keep the same category order and scoring rules for all series.
Use numeric values, not numbers stored as text, and avoid blank cells where a value should exist.
Include only the rows and columns intended for the chart; unrelated totals can be interpreted as another category or series.

Create a radar chart in Excel

Enter the category names in the first column, series names across the top row, and numeric values in the body of the table. Include the headers when selecting the range so Excel can use them as labels.
Select the complete rectangular range. In the example above, that means the Measure heading, all three product headings, the five category names, and their values.
On the ribbon, select Insert. In the Charts group, click Insert Waterfall, Funnel, Stock, Surface or Radar Chart, then choose a chart under the Radar section. The exact button presentation can vary with ribbon width, but it is the chart button that includes the radar options.
Choose a style: Radar, Radar with Markers, or Filled Radar. For a first chart, Radar with Markers is often easiest to read because the plotted observations are visible as points.
Check the result. The product names should appear as series in the legend, and the measure names should appear around the chart. If Excel has treated the products as categories and the measures as series, select the chart and use Chart Design > Switch Row/Column.
Add a descriptive chart title and, where useful, a legend. Select the chart, then use the chart elements button beside it or Chart Design > Add Chart Element to manage elements such as the title and legend. Available controls can differ slightly by build and chart selection.

In Excel for Mac, the radar chart is also available from the Insert tab’s chart options, although the button grouping and wording can differ from Windows. In Excel for the web, chart creation and formatting controls may be more limited or arranged differently; if a particular radar option is unavailable, open the workbook in the desktop Excel app.

Choose between the radar chart styles

Excel offers several radar presentations, and the best choice depends on how many series you have and whether exact point positions matter.

Radar: Connects each series’ points with lines. It keeps the chart relatively uncluttered and works well when points do not need prominent symbols.
Radar with Markers: Adds a marker at each category value. This can help readers distinguish individual observations, especially when comparing a few series.
Filled Radar: Fills the area inside each series polygon. The fill can make one series stand out, but overlapping fills obscure one another. Use transparency if the formatting controls available in your Excel build allow it, or avoid this style when several series overlap.

For the sample table, a line or marker chart with three products is usually clearer than three opaque filled shapes. If the chart has many series, changing colors may not solve the underlying crowding; selecting fewer series or using small multiples may be more effective.

Format the scale, labels, and appearance

Scale choices affect the impression a radar chart gives. Excel often chooses an axis range based on the data. For a rating scale that is defined as 1 to 5, a chart that begins at a different minimum can exaggerate differences. To review the scale, select the chart’s value axis, right-click it, and choose Format Axis. In the Format Axis pane, review the bounds and units under Axis Options. Set a minimum and maximum that match the meaning of the measure when that makes the comparison more honest. For a 1-to-5 rating, for example, use the same 1 and 5 limits across charts intended for direct comparison.

Not every chart element is equally helpful. A short title should state what is being compared, while a legend should identify each series without requiring readers to guess from color alone. Keep category labels concise; long labels can crowd the perimeter. If the chart is too small to show them clearly, enlarge the chart area or use a data table or another chart type instead of shrinking the text excessively.

Use a restrained palette and distinguish series with more than color alone where possible, such as markers or line styles. This improves readability for people who have difficulty distinguishing colors and when a chart is printed in grayscale. Avoid three-dimensional effects and heavy fills: they add visual decoration without making the underlying values more precise.

How to interpret the shape fairly

Radar charts emphasize a profile: which dimensions are relatively high or low, and where two series differ. They are less suitable for precise comparisons between distant categories because the axes radiate in different directions. A reader may also perceive the enclosed area as a score, even though ordinary radar charts do not calculate or validate an overall rating.

Category order matters. Reordering the axes changes the polygon’s outline and can change its apparent area even though none of the values changed. For a fair comparison, keep the category order consistent between charts and choose an order with a clear rationale, such as a process sequence or a stable list of evaluation criteria. Do not rearrange categories simply to make one series look stronger.

Also consider whether the measures are genuinely comparable. The example works because every product is rated on the same five-point scale, with the same direction. If ratings come from different people or use inconsistent definitions, the chart cannot correct that problem. Explain the scale, source, and any important limitations alongside the visualization.

Common problems and how to fix them

The chart has the wrong series orientation: Excel may interpret rows and columns differently than intended. Select the chart and choose Chart Design > Switch Row/Column, then check that the legend and category labels are correct.
Category names or series names appear as numbers: Confirm that the selected range includes the header row and label column. Check that those cells contain text labels and that the data range does not include an extra total row.
The lines look distorted or gaps appear: Check for blank cells, text-formatted numbers, or missing observations. A blank is not equivalent to zero, so decide whether the data is missing or truly zero and represent it accordingly.
One series dominates the chart: Look for an outlier, a different unit, or inconsistent scale. Do not simply remove a valid outlier to make the picture look balanced; investigate it and explain any justified scale choice.
The chart is crowded: Reduce the number of categories or series, use markers and lighter lines, or select another visualization. A radar chart is not improved just by making its labels smaller.
Filled areas hide the data: Switch to Radar or Radar with Markers, or use fewer series. Filled polygons overlap and can make it difficult to tell which series is in front.

When a different chart is a better choice

A spider web chart is one option, not a default for every comparison. A clustered bar chart is often easier for comparing exact values category by category, particularly when there are many categories or the measures are not naturally interpreted as a shared profile. A line chart is usually better when the horizontal order represents time or another continuous sequence. A table with conditional formatting can be more useful when readers need the exact numbers as well as a quick visual scan.

Use a radar chart when the same small group of categories applies to each series, scales are meaningfully aligned, and the overall profile is more important than precise ranking on every individual measure. If the purpose is to rank alternatives, a sorted bar chart often makes the ranking clearer. If the purpose is to show how one person or product changes over time, separate radar charts with identical scales may be less misleading than overlaying many time periods on a single chart.

Frequently Asked Questions

Is a spider web chart the same as a radar chart in Excel?
Yes. Spider web chart is a common name for a radar chart, referring to its radiating axes and web-like grid. In Excel’s Insert chart menu, look for the Radar chart options.

Can I add more than one data series?
Yes. Put each series in a separate column with its name in the header row, then select the whole table before inserting the chart. Keep the number of series manageable, because overlapping lines and fills quickly become difficult to distinguish.

Why does Excel show my categories in the legend?
Excel may have read the data orientation differently from the intended layout. Select the chart and choose Chart Design > Switch Row/Column. If that does not correct it, check that the headers and category labels are positioned consistently in the selected range.

Can a radar chart show values on the axes?
The chart uses a value scale on its radial axes, and Excel displays scale labels according to the chart’s formatting. You can select the value axis and use Format Axis to adjust its bounds, units, and number format. The exact label arrangement depends on the chart and formatting options available in your Excel version.

What is a good number of categories for a spider chart?
There is no fixed limit, but a small set is easier to read. As categories accumulate, perimeter labels crowd and the polygon becomes harder to interpret. If readers need to compare many measures, use a bar chart or a well-organized table instead.

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.