Radar Chart Excel Format: Setup and Styling Guide

Charts & pivot tables · Updated November 20, 2026

In Microsoft Excel for Microsoft 365 on Windows, select a table with category labels and one or more data series, then choose Insert > Insert Waterfall, Funnel, Stock, Surface or Radar Chart > Radar. Pick Radar, Radar with Markers, or Filled Radar; then use the chart formatting controls to set a consistent value scale and make the series easy to compare.

What a radar chart shows

A radar chart, also called a spider chart, plots several categories around a circle. Each category has a spoke radiating from a central point, and values are positioned along that spoke. Excel connects the points for each data series, creating a polygon that gives a visual profile across the categories.

For example, a product team might compare three products on price, durability, ease of use, and support, with each factor scored from 1 to 5. A radar chart can make it quick to spot that one product scores highly on durability but poorly on price. It is most useful when categories are meaningfully related and use comparable measures. The shape is a summary, not a statistical test, and it does not show that one factor causes another.

The chart’s visual impression depends on the order of categories and the value scale. Changing either can alter the polygon’s shape, so a polished format should also be an honest and consistent one.

Choose the right radar chart type

Excel offers three main radar formats. Select the one that matches the amount of data and the kind of comparison you need:

  • Radar: Draws a line between each series’ category values. It is a good starting point for comparing a few series without filling the area inside each polygon.
  • Radar with Markers: Adds a marker at each category value. Markers help readers identify individual observations, especially when the chart is small or the lines are thin.
  • Filled Radar: Fills the polygon for each series with color. This can emphasize a single profile, but overlapping filled shapes can hide one another and make comparisons difficult.

For several series, ordinary Radar or Radar with Markers is usually easier to read than Filled Radar. If a filled chart is appropriate, use transparency where available and avoid relying on color alone. A useful rule is to start with the plain line version and add visual effects only when they improve interpretation.

Arrange the worksheet data

Put category names in the first column and series names in the top row. For instance, A1 can contain the label Factor, B1 Product A, and C1 Product B. Put Price, Durability, Ease of use, and Support in A2:A5, and enter each product’s score in the corresponding cells of columns B and C. Include the headings when selecting the range so Excel can use them as series and category labels.

Keep the data rectangular: each series should have one value for every category. Avoid blank rows or columns inside the selected range, merged cells, and totals that are not genuine categories. If a value is missing, decide how to represent it before charting; a blank or text entry may not behave like a measured score. Do not substitute zero for missing data unless zero really means the lowest possible result.

Excel may interpret the rows and columns in the opposite direction from what you intended. If the legend lists categories rather than products, select the chart and use Chart Design > Switch Row/Column. For this example, the intended result is four category labels around the chart and two product series in the legend.

Create a radar chart in Excel

  1. Arrange the labels and values as a table, with category labels in the first column and series names across the first row.
  2. Select the complete range, including its headings.
  3. Choose Insert > Insert Waterfall, Funnel, Stock, Surface or Radar Chart, and select the desired Radar option.
  4. Check that the category names appear around the circle and the data series appear in the legend. If they are reversed, use Chart Design > Switch Row/Column.
  5. Add a descriptive chart title and adjust the scale and series formatting before sharing the chart.

On Excel for Mac, the ribbon-based chart workflow is similar: select the data and use the Insert tab’s chart options to choose a Radar chart. The exact grouping or menu presentation can vary with the window size and Excel build. Excel for the web also supports chart insertion, but some detailed formatting controls may be more limited than in the desktop application; open the workbook in desktop Excel if a required control is unavailable.

Format the value scale fairly

The radial value axis controls how values map from the center toward the outside of the chart. To change it, select a value-axis label or gridline, right-click, and choose Format Axis. In the Format Axis pane, use Axis Options to set bounds such as Minimum and Maximum and, when available, the major unit. The exact controls shown depend on the chart and data.

For ratings from 1 to 5, a scale that starts at 1 and ends at 5 may make sense if 1 is the true minimum and the goal is to compare scores within that defined rating system. A scale beginning at zero may be more appropriate when zero is a meaningful absence of the measured quantity or when the chart should show the full range from none to the maximum. Whatever the choice, use the same bounds for charts that readers are expected to compare.

A truncated scale can exaggerate small differences. For example, two values of 4.2 and 4.5 may look far apart if the axis begins at 4, even though the numerical gap is only 0.3. Conversely, a very broad scale can make meaningful differences hard to see. State the scale in the chart title, subtitle, or nearby text when readers might otherwise misinterpret it.

Format lines, markers, labels, and legend

Click a series line to select it, then right-click and choose Format Data Series. The pane provides styling options such as line color, line width, and marker settings, depending on the selected radar type. Give each series a distinct, high-contrast color and, where useful, different marker shapes or line styles. This helps distinguish series in grayscale printouts and for people who have difficulty distinguishing certain colors.

Use the chart title to explain what is being compared, not merely to repeat the chart type. A title such as Product scores by evaluation factor is more informative than Radar Chart. Keep category labels short enough to fit around the circle, and make the legend labels match names used in the surrounding discussion.

To add or edit chart elements, select the chart and use Chart Design > Add Chart Element. Depending on the element, Excel offers options for titles, legends, and data labels. Data labels can help when exact values matter, but labels on every point across many series quickly clutter the chart. A compact data table beside the chart may be clearer when readers need to look up every score.

Common problems and how to fix them

  • The chart has the wrong number of series: Check whether the header row and label column were included. Use Chart Design > Switch Row/Column if Excel treated each category as a series.
  • The shape looks distorted or misleading: Review the value-axis bounds and confirm that all series use the same units and scale. A polygon’s area can make differences appear larger or smaller than the values alone suggest.
  • Some points or lines are missing: Check for blank cells, text stored where numbers are expected, or incomplete series. Confirm that every category has an intended value for each series.
  • Labels overlap: Shorten category names, enlarge the chart, or reduce the number of categories. Rotating or shrinking labels is not always a good fix if it makes them hard to read.
  • Filled shapes obscure one another: Switch to Radar or Radar with Markers, reduce the number of series, or use transparency if the formatting controls allow it.

Also check the order of categories. Excel plots them in worksheet order around the circle, so moving rows changes the visual profile. Keep the order consistent across related charts; alphabetical order, a logical process sequence, or a documented ranking can work, but arbitrary changes make comparison harder.

When to use a different chart

Radar charts are not automatically the best choice for multivariable data. They work best with a modest number of categories and a small number of series on a common scale. A chart with many spokes or many overlapping polygons can become difficult to interpret, even if Excel can draw it.

For precise comparisons across categories, a clustered bar chart is often easier because readers can compare lengths against a shared baseline. A line chart is more suitable when the horizontal order represents time or another continuous sequence. A table with conditional formatting may be preferable when exact values matter more than an overall pattern. If the measures use different units, such as dollars, percentages, and days, do not plot them together on a radar chart without a defensible normalization method; the resulting shape could imply comparisons that the raw values do not support.

A common misconception is that a larger radar polygon always means a better overall result. That conclusion is only justified if higher values are desirable for every category, the scale is consistent, and the categories have appropriate importance. If lower is better for one measure, such as cost or error rate, a high value on that spoke may be negative rather than positive. Explain how scores were defined before interpreting the shape.

Frequently Asked Questions

How do I make a radar chart in Excel?
Select a table containing category labels, series headings, and numeric values. Go to Insert > Insert Waterfall, Funnel, Stock, Surface or Radar Chart > Radar, then check the category and series orientation.

What is the best data layout for an Excel radar chart?
Use one row per category and one column per series, with category names in the first column and series names in the top row. Include the headings in the selected range.

How do I change the scale on a radar chart?
Select a value-axis label or gridline, right-click, and choose Format Axis. Set appropriate minimum and maximum bounds in Axis Options, then apply consistent bounds to charts meant to be compared.

Can an Excel radar chart have negative values?
Radar charts can display numeric values, but negative ranges can be harder to interpret because the chart’s center and radial scale may not communicate the meaning clearly. Check the axis behavior in your workbook and consider a bar chart when values cross zero or signed differences are central to the message.

What is the difference between Radar and Filled Radar?
Radar connects series values with lines, while Filled Radar shades the area inside each series polygon. Filled areas can overlap and conceal data, so line-based radar charts are often clearer for multiple series.

Why does my radar chart show categories in the legend?
Excel has likely plotted rows and columns in the opposite orientation. Select the chart and choose Chart Design > Switch Row/Column so each category becomes a spoke and each intended data set becomes a series.

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.