Spider Web Chart in Excel: Create, Format, and Read It

Charts & pivot tables · Updated November 21, 2026

To make a spider web chart in Excel, arrange your categories in one column and each data series in its own column, select the table, then choose Insert > Insert Waterfall, Funnel, Stock, Surface, or Radar Chart > Radar. Excel calls this a radar chart; it plots each category along a spoke so you can compare several profiles in a web-shaped graphic.

What a spider web chart shows

A spider web chart, also called a radar chart or web chart, compares values across several shared categories. Each category has an axis that begins at the chart’s center and extends outward. Excel places a point on each axis according to its value, then connects the points to form a polygon for each data series. A larger distance from the center means a higher value, assuming the axes use the same scale.

This layout is useful when a reader needs to see a profile at a glance, rather than inspect every number individually. For example, a manager might compare two products on price, durability, ease of use, and support. A teacher might show a student’s scores across subjects, or a team might compare skills across several competencies. The shape can reveal where one series is relatively strong or weak.

The chart is not a geographic map and does not show literal connections between categories. Its spokes are separate measurement axes, and the order of categories around the circle affects the shape. That makes radar charts best for a modest number of meaningful categories measured on comparable scales—not for every kind of data.

Arrange and check the data first

Excel needs one label for each category and one column or row of values for each series. Put the category names in the first column and series names in the first row. Keep the table rectangular, with no blank rows or columns inside the data. For example:

Measure Product A Product B
Price score 4 3
Durability 3 5
Ease of use 5 4
Support 4 3
Design 3 4

Here, the ratings use a scale from 1 to 5, with 5 meaning the strongest score. The category labels belong in the first column, while the two products are separate series. If your data is arranged with series in rows instead, Excel may still interpret it correctly, but you may need to change how it reads the table after inserting the chart.

  • Use consistent units or scoring rules for every category. Mixing dollars, percentages, and ratings on one radar chart usually makes the visual comparison misleading.
  • Decide whether higher values should always mean better performance. If lower is better for a measure such as response time, consider converting it to a clearly explained score before charting.
  • Use concise category labels. Long labels can crowd the perimeter and make the chart harder to scan.

Create the chart in Excel for Microsoft 365

  1. Select the complete table, including the category labels and series headings. In the example, that means selecting all three columns and all six rows.
  2. On the ribbon, choose Insert > Insert Waterfall, Funnel, Stock, Surface, or Radar Chart.
  3. Under Radar, choose Radar for lines without point markers, Radar with Markers to show each data point, or Filled Radar to fill the area under each series.
  4. Check that the category names appear around the outside and that each product appears as its own series. If the chart is oriented incorrectly, select it and choose Chart Design > Switch Row/Column.
  5. Replace the automatic chart title with a specific title, such as Product Ratings by Measure. Add a legend if the chart has multiple series.

The Chart Design and Format tabs appear when the chart is selected. In Excel for Mac, the same general chart choices are available, but ribbon placement and wording can vary by release. Excel for the web also supports charts, though its available chart types and formatting controls may differ from the desktop app. If Radar is not offered in the version you are using, open the workbook in Excel for Microsoft 365 on Windows or Mac and create or format it there.

Choose the right radar chart type

Radar is the simplest style and is often the easiest to read when several series overlap. Radar with Markers adds a visible symbol at each category, which helps readers identify the actual measured points, especially when the values are close. Filled Radar colors the areas inside the polygons. It can look striking with one series, but overlapping fills can obscure data when there are several series.

For two or three series, try using distinct line colors and markers, and keep the fill transparent or avoid filled radar entirely. A legend should identify each series clearly. If you have many series, the lines and markers can become a tangle; splitting the comparison into separate charts may communicate the information better than adding more colors.

Format the scale and labels for a fair comparison

Radar charts can mislead if the value scale is unclear. In the sample ratings, the meaningful range is 1 to 5. Excel may choose an axis minimum and maximum automatically, so the center might represent zero even though no rating of zero is possible. To make the scale easier to interpret, select a value-axis label, open Format Axis, and review the Bounds settings. You can set a minimum and maximum that match the measurement, where Excel permits those settings for the chart. State the scale in the axis labels, chart title, or a nearby note.

Be careful when changing the minimum. A radar chart’s center is a visual baseline, so starting the axis at 1 rather than 0 changes the apparent area and can exaggerate differences. If you choose a nonzero minimum because it reflects the real scale, make that choice visible to readers. For comparisons across multiple radar charts, keep the same minimum and maximum on each chart; otherwise, identical shapes or distances may represent different values.

Improve readability with a few focused formatting changes:

  • Use a descriptive chart title and a legend with short, recognizable series names.
  • Choose contrasting colors that remain distinguishable for readers with color-vision deficiencies. Do not rely on color alone if marker shapes or line styles can help.
  • Keep gridlines light enough that they guide reading without overpowering the series.
  • Remove unnecessary borders, decorative effects, and data labels that collide with one another.
  • Consider adding labels only to a few important points. Labeling every point in a busy chart can make the display less legible than the source table.

Read a worked example carefully

In the sample table, Product A scores 5 for ease of use, while Product B scores 4. Product B scores 5 for durability, compared with Product A’s 3. The chart therefore shows Product A extending farther on ease of use and Product B extending farther on durability. Those observations are direct comparisons of the plotted ratings; they do not prove that either product is better overall.

One tempting shortcut is to compare the total filled area of each polygon and declare the larger one the winner. That can be unreliable. Area depends on the axis scale, the number and order of categories, and the way the points join around the circle. A high value on one category can also visually compensate for a low value on another even when the categories matter differently. If you need an overall score, define and explain a defensible scoring method separately rather than treating the polygon area as a meaningful total.

Fix common spider chart problems

  • Excel plots the categories as series. The table orientation may be reversed. Select the chart and use Chart Design > Switch Row/Column. If the result is still wrong, check that category names are in the first column and series names are in the first row.
  • The chart has generic labels or missing categories. Confirm that the selected range included the headings and every category row. You can also select the chart, choose Chart Design > Select Data, and check the chart data range and category labels.
  • The shape looks almost flat. Check whether values are close together, whether Excel has chosen an unsuitable axis range, or whether the data contains blanks or text instead of numbers. Review the source cells before changing the scale.
  • One series hides another. Use Radar with Markers, change the order of series in Select Data, or use less visually dominant formatting. For many overlapping series, separate charts are usually clearer.
  • The category order seems wrong. Radar charts follow the order of categories in the source data. Rearrange the table rows if a different order would make the comparison easier to follow, and ensure you have not implied a meaningful sequence that the data does not have.

When to use a different chart

A spider web chart is not automatically the best choice just because the data has several categories. A clustered bar chart is often easier for accurately comparing values, particularly when readers need to see small differences or compare many categories. A line chart is more appropriate when the horizontal order represents time or another continuous sequence. A table may be best when exact values matter more than the overall profile.

Use a radar chart when the goal is to show a compact, multivariate profile and the categories share a comparable scale. Keep the number of categories manageable, and use a consistent axis range when comparing groups. If categories have different units or importance, consider separate charts, standardizing the measurements with a transparent method, or presenting the values in a table alongside the graphic.

Frequently Asked Questions

Is a spider chart the same as a radar chart in Excel?
Yes. Spider chart, web chart, and radar chart are common names for the same general type of chart. In Excel’s chart menu, look for Radar.

How many categories should a spider web chart have?
There is no universal fixed limit, but a small set of clearly named categories is easier to read. With too many spokes, labels crowd together and the profile becomes difficult to compare. If the chart looks busy, use fewer categories or split it into multiple charts.

Can I make a spider chart with only one data series?
Yes. A single series can show one profile across several measures. Use markers if you want the individual values to stand out, and include a clear scale so readers can interpret the distances from the center.

Why does my radar chart show the wrong labels?
Excel may have interpreted rows and columns in the opposite direction, or the selected range may omit the labels. Try Chart Design > Switch Row/Column, then check Chart Design > Select Data to verify the category labels and series names.

Can I use a radar chart for percentages?
Yes, if every category is measured as a percentage on the same meaningful range. Make the scale clear, and do not mix percentages with unrelated units such as currency or time on the same radar chart.

Related

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.