Spider Web Chart in Excel: Make a Radar Chart Look Great

To make a spider web chart look great in Excel, arrange comparable measures in a table, select the data, and choose Insert > Insert Waterfall, Funnel, Stock, Surface or Radar Chart > Radar. Then set a sensible scale, simplify the labels, and use restrained colors so readers can compare the shapes quickly. Excel calls this a radar chart; spider web chart is another common name for the same chart family. It works best for comparing a small number of series across the same categories, such as two products rated on five shared features.

What You’ll Need

Excel for Microsoft 365 on Windows. The main chart and formatting tools are also available in current Excel for Mac, though ribbon placement and some formatting controls may differ slightly. Excel for the web can create charts, but use the desktop app if a formatting option is missing.
A tidy data table: category names in the first column, series names across the first row, and numeric values in the body. For example, use features such as Price, Ease of use, and Support as categories, with one column each for Product A and Product B.
Values measured on the same meaningful scale. A five-point rating is suitable if every category uses the same 1-to-5 scale. Different units, such as dollars and customer ratings, should not be plotted together without a defensible way to standardize them.

Step-by-Step

Prepare and check the data. Put a clear heading above each series and one category per row. Keep the category order consistent with the story you want the chart to tell; Excel places categories around the circle in table order. Check that the values are numbers rather than text, that there are no accidental totals, and that each series has a value for every category. A compact chart with roughly four to eight categories and two or three series is usually easier to read than one crowded with many spokes and lines.
Select the complete table. Highlight the series headings, category labels, and data values together, including the top-left corner cell if it contains a heading such as Measure. For instance, a table with headings in A1:C1, category labels in A2:A6, and scores in B2:C6 should be selected as A1:C6. Including the labels helps Excel build the spokes and legend correctly. If the table is an Excel Table, you can select its data range and add more rows later, but check that the chart includes any new categories.
Insert the radar chart. On Windows, open the Insert tab, choose Insert Waterfall, Funnel, Stock, Surface or Radar Chart, and select Radar. The menu also offers Radar with Markers and Filled Radar. Start with the plain Radar option for most comparisons. Radar with Markers can make individual observations easier to locate. Filled Radar adds colored areas, but overlapping fills can hide one another, so reserve it for a small number of series with transparent fills.
Confirm the series orientation. Look at the chart: category names should appear around the edge, and each product or group should have its own line and legend entry. If Excel has treated each category as a series, select the chart and go to Chart Design > Switch Row/Column. If the result still looks wrong, return to the table and check that category labels occupy one column while series names occupy one row. A useful test is whether the legend lists the groups you actually want to compare.
Set a fair, readable value scale. Right-click a value-axis label and choose Format Axis. Under Axis Options, set the minimum and maximum bounds to match the real scale and choose a sensible major unit. For a five-point rating, a 0 minimum and 5 maximum with a major unit of 1 makes the rings easy to interpret. Avoid tightening the minimum just to make small differences look dramatic. Use the same bounds when comparing multiple radar charts; otherwise identical values can create different-looking shapes.
Give the chart a useful title and legend. Select the chart, then choose Chart Design > Add Chart Element > Chart Title > Above Chart. Replace the placeholder with a short title that says what is compared and, where useful, the period or scale, such as Product feature ratings, scale 0–5. Use Chart Design > Add Chart Element > Legend to place the legend at the bottom or right. Keep the legend if colors alone do not make the series identities obvious; remove it only when the chart has one series or labels identify the lines clearly.
Style the lines so they remain distinct. Click a line, right-click it, and choose Format Data Series. In the Format Data Series pane, use Fill & Line to choose a Solid line color and a moderate width. Give each series a clearly different color, and use Marker Options to add small markers when readers need to compare exact category points. Avoid relying on red and green alone, since those colors can be hard to distinguish for some readers. With several series, vary marker shapes or line dashes as well as color.
Reduce visual clutter and finish the layout. Keep the major grid rings visible but use a quiet gray rather than a strong color. Select unnecessary chart elements and press Delete; remove minor gridlines or a chart border if they compete with the data. Increase the chart size until category labels are not crowded, and use a readable font size. If you add data labels, use them sparingly: labels at every point across several series can collide. A short note in a nearby cell can explain the scale or data source without crowding the plot.

Common Mistakes

Comparing unlike measures. Radar charts can imply that every spoke has equal meaning. Plotting revenue, time, and satisfaction together is misleading because their units and ranges differ. Use separate charts or transform the measures to a clearly explained common scale before charting. Normalization changes how readers interpret the data, so document what the numbers mean.

Adding too many lines or categories. Every extra series makes intersections and overlaps more likely, while too many spokes make labels hard to follow. Split a large comparison into several small charts with the same scale, or show only the most relevant categories. Do not remove categories selectively from one group if the purpose is a fair comparison.

Using a truncated or inconsistent scale. A radar chart emphasizes the area and distance from the center. Starting the scale above zero or changing the maximum between charts can exaggerate differences. Choose bounds that match the measure, show those bounds in the title or a note, and keep them fixed for any charts readers will compare.

Using filled areas without checking overlap. A later series can cover an earlier one, making the hidden values seem absent. Prefer unfilled lines for multiple groups. If a filled chart is genuinely helpful, limit the number of series and use light, transparent-looking fills where the available formatting controls allow them.

Tips

Choose a category order that helps interpretation. Group related measures together, or order them in a consistent sequence that readers can follow from chart to chart. Radar charts do not have a universally best starting spoke, so use the same order across comparisons. If there is no meaningful order, choose one and explain it rather than rearranging categories to make a preferred shape look more impressive.

Use markers when precise values matter and clean lines when the overall profile matters more. If exact readings are important, include a small data table near the chart; radar charts are better at showing patterns than supporting precise comparisons. Keep series names short enough for the legend and use descriptive category names. For long labels, widen the chart or shorten labels in the source table while preserving their meaning.

Make the chart accessible as well as attractive. Use sufficient contrast between each line and the background, avoid communicating identity through color alone, and provide a concise text description when sharing the workbook. For example, a note might say that Product A scores higher on ease of use while Product B scores higher on support. This helps readers who cannot distinguish the colors or interpret the chart visually.

Troubleshooting

The chart has the wrong labels or too many series. Check the selected range for blank heading cells, extra rows, or totals. Use Chart Design > Switch Row/Column to change how Excel interprets the table. If that does not fix it, select Chart Design > Select Data and inspect the chart data range and the series and category labels. Correct the source table rather than manually adding many individual chart entries when possible.

Some points or lines are missing. Confirm that the cells contain numeric values and that the values fall within the axis bounds. Text such as a number followed by a word may be treated as text. Also inspect empty cells: a blank is not the same as zero. Decide whether a missing observation should remain missing or be represented by a valid value; do not fill gaps with zero merely to complete the shape. If needed, open Chart Design > Select Data > Hidden and Empty Cells and review the available empty-cell display options for the selected chart.

The chart looks flat, spiky, or unexpectedly distorted. Verify that all categories use the same measurement scale and check the Format Axis minimum and maximum. A single unusually high value can compress the rest of the profile. Check the source data for an extra zero, misplaced decimal, or outlier before changing the axis. If the data are correct but still hard to compare, use a column chart or a table instead; a radar chart is not the best format for every dataset.

Labels are cut off or crowded. Enlarge the chart area by dragging a corner, move the legend, shorten overly long category names in the source data, or reduce the number of categories shown. If the chart is inside a narrow worksheet area, move it to a separate sheet using Chart Design > Move Chart. On Mac, the chart commands are on the Chart Design tab when the chart is selected, though specific pane placement can differ.

Frequently Asked Questions

Is a spider web chart the same as a radar chart?
Yes. Spider web chart and web chart are common names for a radar chart. Excel uses Radar in its Insert chart menu.

Which radar chart type should I choose?
Choose plain Radar for a straightforward line comparison. Use Radar with Markers when the individual category values should stand out. Filled Radar is most suitable for one series or a small number of series that do not obscure each other.

How many categories and series should I use?
There is no fixed limit, but a handful of categories and a few series are generally easier to read. If labels overlap or lines cross repeatedly, reduce the number or split the data into separate charts with identical scales.

Can I make the scale start at a value other than zero?
Excel lets you change the value-axis minimum in Format Axis. Use a nonzero minimum only when it is appropriate for the measure and clearly shown; it can exaggerate differences in the chart’s shape.

Can I update the chart when I add new data?
Yes. If the chart’s source range includes the new rows or columns, Excel updates it. Otherwise, select the chart and use Chart Design > Select Data to revise the range. An Excel Table can help the source range expand as you add records, but confirm the chart picks them up.

Why might a different chart be better?
Use a bar or column chart when the main goal is to rank values precisely, especially across many categories. Radar charts are strongest when the goal is to compare a small set of groups across shared measures and see their overall profiles.

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.