Excel for Mac Spiderweb Graph: Create and Format It

Charts & pivot tables · Updated November 18, 2026

Yes. In Excel for Mac, a spiderweb graph is called a Radar chart: arrange your categories and values in a table, select the data, then choose Insert > Recommended Charts > All Charts > Radar. Excel plots each category around a circular set of spokes, making it easy to compare several measures or profiles at once.

What a spiderweb graph means in Excel

Spiderweb graph, spider chart, and web chart are informal names for a radar chart. Excel uses the name Radar in its chart options. Each spoke represents a category, and the distance from the center represents a value. A line joins the values for one series, producing a closed or nearly closed shape. With multiple series, their shapes overlap for comparison.

This chart is most useful when the same subjects are measured across the same set of categories. For example, you might compare two product models on battery life, durability, comfort, price, and ease of use, or compare a team’s skills across several competencies. It is not a map, and the position of a category around the circle does not usually mean that category is more important. The shape is a visual summary of values, not a statistical score.

Radar charts work best with a modest number of categories and a few series. A chart with many spokes or many overlapping lines becomes difficult to read. If your purpose is to compare exact values across a long list of categories, a bar chart is usually clearer.

Arrange the data before creating the chart

Excel needs a clear row or column for category labels and one numeric series for each subject being compared. Put the category names in the first column and the series names in the first row. For example, a small product comparison could look like this:

  • Column A: Measure, followed by Battery, Durability, Comfort, Price, and Ease of use.
  • Columns B and C: Model A and Model B, with one numeric rating for each measure.

Include the header row and category labels when selecting the range. Those labels help Excel identify what belongs on the chart legend and around the chart perimeter. Keep the ratings on a consistent scale, such as 1 to 5, and make sure larger numbers mean the same kind of thing for every measure. If a lower price is better but you enter the raw price as a larger number, the chart may suggest that a more expensive product scores better. Convert measures to a comparable rating or explain the direction clearly.

Avoid mixing values with very different units without transforming or otherwise making them comparable. A score of 4, a price of 900, and a battery life of 12 hours share no meaningful scale simply because Excel can plot them together. If you use ratings, document what the scale means, such as 1 for poor and 5 for excellent. Do not leave decorative blank rows or columns inside the selected data range; they can confuse Excel’s series detection.

Create a Radar chart on a Mac

  1. Enter the categories and numeric values in a contiguous table, with descriptive headers.
  2. Select the entire table, including the headers and category labels.
  3. On the ribbon, choose Insert > Recommended Charts.
  4. In the chart dialog, open All Charts, select Radar, and choose a subtype such as Radar, Radar with Markers, or Filled Radar if it is available in your Excel version.
  5. Choose OK. Excel inserts the chart into the worksheet.

If Recommended Charts does not show the chart you want, use its All Charts list rather than assuming the chart is unavailable. Microsoft updates Excel’s ribbon and dialog presentation over time, so the placement or appearance of chart controls can differ slightly by release. The Radar chart family is the relevant choice; it may be grouped with other chart types in the Insert chart controls.

After insertion, select the chart to reveal contextual chart tabs such as Chart Design and Format. You can move or resize it by dragging its border or corner handles. To place it on its own sheet, use the chart’s move option from the chart design controls if your version displays it. Keep the source table intact: editing its numbers will normally update the chart.

Choose the right Radar subtype

Excel’s Radar options differ in how they draw the series, not in what the underlying data means. The plain Radar chart draws a line around each series. It is often a good starting point when there are few series and you want to compare profiles without filling in the shapes.

  • Radar: Draws connecting lines. Use it when the outline is the important comparison and a clean chart is preferable.
  • Radar with Markers: Adds a marker at each category’s value. Markers can make individual observations easier to locate, especially when the chart is small or the lines are thin.
  • Filled Radar: Fills the area inside each series shape. Overlapping fills can obscure one another, so this is most suitable for very few series and often needs transparency or careful color choices.

For the product example, plain Radar or Radar with Markers is generally easier to interpret than several opaque filled shapes. The category order follows the order in the table. If the order is meaningful, such as a progression from entry-level to advanced skills, arrange the rows in that order before creating the chart. Changing the order changes the outline and can change the visual impression, even though the values themselves have not changed.

Format the chart for readable comparisons

Give the chart a specific title that names what is being compared and, where useful, the rating scale. A title such as Product ratings, 1–5 is more informative than Chart Title. Select the title text to edit it. Use a legend when there are multiple series, and choose series names that are short enough to read without ambiguity.

To add or change chart elements, select the chart and use the chart design controls. Depending on the Mac release, options for titles, legends, data labels, and other elements appear under Chart Design > Add Chart Element or in the chart elements controls. Data labels can help readers identify exact values, but labeling every point on a chart with many categories can make it crowded. A useful compromise is to show labels only when precise readings matter, and otherwise keep the underlying data table nearby.

The radial value scale deserves special attention. Excel chooses a scale automatically, and a truncated or inconsistent scale can exaggerate small differences. Select the value axis and open Format Axis to inspect the bounds and units. When the ratings use a fixed scale, set the minimum and maximum to that scale where the available axis options allow it. For a 1-to-5 rating, for instance, using a consistent 1-to-5 range across comparable charts makes comparisons more honest than allowing each chart to autoscale differently. If the scale starts at zero by convention, keep that choice consistent and make it clear to readers.

Use distinguishable line colors and adequate contrast. Avoid relying on color alone if the chart may be printed in grayscale or viewed by people with color-vision differences; markers and line styles can help. A white or light background, restrained gridlines, and a readable legend usually work better than decorative effects. Resize the chart enough that category labels do not collide, and check it at the size at which it will be shared or printed.

Common problems and how to fix them

  • The chart has one line instead of several: Excel may have interpreted rows and columns in the opposite direction from what you intended. Select the chart and use Chart Design > Switch Row/Column if that command is available. Check that the legend lists the subjects and the perimeter lists the categories.
  • Category names or series names look wrong: The selection may have omitted the header row or label column. Correct the selected source range through the chart’s data selection controls, or recreate the chart after selecting the full table.
  • One series dominates the chart: The measures may use different units or scales, or one value may be an outlier. Check the source values and decide whether the measures can fairly be compared on one scale. Do not change the axis merely to hide a genuine difference.
  • The shape looks distorted or misleading: Check the value-axis bounds, category order, and whether larger values consistently mean better performance. The area enclosed by a radar shape can look impressive, but it is not a reliable substitute for reading the individual values.
  • Some categories disappear or show unexpected gaps: Inspect the source range for blanks, text stored where numbers are expected, or accidental omissions. Excel’s handling of empty cells can depend on chart settings and version; review the chart’s data selection or hidden-and-empty-cell options if available.
  • Filled shapes hide each other: Switch to Radar or Radar with Markers, reduce the number of series, or use less opaque colors if formatting options permit. The simplest fix is often a less crowded chart type.

When a chart does not update after a source edit, confirm that the edited cells are within its source range. If you add new categories below the original table, the chart may not include them automatically in every workbook setup. Expand the chart’s data range or recreate it from the updated table, then verify that the new labels and values appear.

When a different chart is better

A spiderweb graph is not automatically the best way to compare multiple measures. Use a clustered bar or column chart when readers need to compare values precisely, especially if categories are numerous. Bars share a common baseline, which makes small differences easier to judge than distances from the center of a radar chart.

A line chart is more appropriate when the horizontal order represents time or another continuous sequence. Radar charts wrap the last category back to the first, which can imply a cycle or relationship between the endpoints that may not exist. A radar chart is reasonable for a recurring set of dimensions, but that circular arrangement should not be used just because it looks distinctive.

For only two or three categories, a small table with conditional formatting can be clearer. For many subjects, consider one chart per subject or a carefully designed table rather than layering a large number of radar lines. The key question is whether the reader needs to recognize an overall profile or compare individual values. Choose the chart based on that task, not on the chart’s visual novelty.

Frequently Asked Questions

Does Excel for Mac have a spiderweb chart?
Yes. Excel calls it a Radar chart. In Excel for Mac, select the data and open Insert > Recommended Charts > All Charts > Radar to choose a Radar subtype.

Why can’t I find a chart called Spiderweb?
Spiderweb is a common informal name, not the chart label Excel uses. Look for Radar in the chart type list instead.

How do I put categories around the outside of the chart?
Include the category names in the first column or row of the selected table. Excel uses them as the radar chart’s category labels. If the wrong labels appear, check the selected range and whether the chart needs its rows and columns switched.

Can I make a radar chart with different scales?
A single radar chart plots its series against a shared value scale. Mixing incompatible units can mislead readers. Convert measures to a defensible common rating scale or use separate charts with clearly stated scales.

Is a filled radar chart better?
Not necessarily. Filling the shapes can make a small number of profiles stand out, but overlapping fills often hide values. Try a plain Radar chart or Radar with Markers when comparison and legibility matter more than filled areas.

Can I use a spiderweb graph in Excel for the web?
Chart features can vary between Excel for the web and desktop Excel, and available editing controls may differ. If the web version does not offer the Radar subtype or formatting option you need, open the workbook in Excel for Mac and use its chart controls.

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.