To make a circular radar chart in Excel for Microsoft 365 on Windows, arrange your categories in one column and each data series in its own column, select the range, then choose Insert > Insert Waterfall, Funnel, Stock, Surface or Radar Chart > Radar. Excel calls this a Radar chart; its circular layout is also commonly called a spider chart.
What a circular radar chart shows
A radar chart places categories around a circle and plots each series’ values along spokes that extend from the center. Excel connects the plotted points, creating a shape that makes the profile of a series visible. For example, a team might compare products across categories such as price, durability, ease of use, and support. Each product becomes a line or filled shape, and each category gets a spoke.
“Circular” describes the arrangement, not a separate Excel chart type. In a standard Radar chart, the gridlines are generally polygon-shaped rings following the category spokes, rather than perfectly circular rings. The chart is not a pie chart: angles do not represent shares of a whole, and the plotted values are read by their distance from the center.
This design is most useful for a small set of related measures that use a comparable scale. It can reveal a balanced profile or a standout strength, but it is not automatically a good way to rank many observations. The areas and shapes can be visually persuasive even when the underlying values are close, so use the chart alongside the data or a more direct comparison.
Prepare the data before inserting the chart
Excel needs one category field and one or more numeric series. Put category names down the first column and series names across the top row. Each intersection should contain the value for that series and category. Keep the categories in the order you want them to appear around the chart; Excel follows the worksheet order.
- Use a clear header for every series, such as Product A or Current quarter.
- Use consistent units and a common measurement scale across the categories.
- Keep the table compact. A chart with a handful of categories and a few series is usually easier to read than one with dozens of spokes or lines.
- Check that values are numeric, not numbers stored as text, and decide how blanks should be handled before charting.
For instance, a comparison of three service plans across five ratings might have the headings Plan A, Plan B, and Plan C in cells B1:D1, with the five rating names in A2:A6 and the scores in B2:D6. Select the entire table, including its headings. If your data is in the opposite orientation, with series in rows, Excel may interpret the categories differently; you can correct that after insertion.
Create a Radar chart in Excel
- Select the complete data range, including category labels and series headings.
- On the Windows ribbon, open Insert and choose Insert Waterfall, Funnel, Stock, Surface or Radar Chart in the Charts group.
- Under Radar, choose Radar for lines, Radar with Markers to emphasize the individual category points, or Filled Radar for overlapping filled shapes.
- Use the chart elements and formatting controls to add a useful title, legend, and data labels where they improve comprehension.
If the chart plots the wrong categories or series, select it and use Chart Design > Switch Row/Column. To change among Radar, Radar with Markers, and Filled Radar later, use Chart Design > Change Chart Type. In Excel for Mac, select the range and use Insert > Recommended Charts, then open All Charts and choose Radar; ribbon labels and arrangement can vary slightly by release. Excel for the web also offers chart insertion, although its editing controls may be more limited than the Windows desktop app.
Choose the right Radar chart type
The plain Radar type draws lines between category values. It is a sensible default when the purpose is comparing profiles and several series may overlap. Radar with Markers adds a marker at each category point, making it easier to see where a line’s value was measured, especially when the chart is small or printed.
Filled Radar shades the area within each series’ outline. That can make a single profile more prominent, but overlapping fills may cover one another and make comparisons harder. Transparency can reduce the obstruction, but it does not remove the underlying issue. If you have several series, use line-based Radar or markers rather than relying on filled areas.
There is no independent radial scale for each spoke in a standard Excel Radar chart. All categories share the same value axis, which means a score of 4 should mean a comparable amount on every spoke. Mixing unrelated measures such as dollars, days, and percentages without a meaningful transformation can make the shape misleading. If measures need separate units, consider separate charts or a carefully explained normalization method instead.
Format the scale and labels for clarity
A radar chart’s value axis starts at the center and extends outward. Excel chooses bounds automatically, but the automatic scale may not match the comparison you intend. Right-click the value axis, choose Format Axis, and review the Bounds and Units options. Setting the same minimum and maximum for charts that readers will compare can make the comparison fairer. For rating scales that run from 1 to 5, for example, showing a consistent 1-to-5 range is often clearer than letting each chart use a different automatic range.
Be cautious when changing the minimum. A scale that starts above zero can make modest differences look much larger, because the center no longer represents zero. If you use a restricted range for a legitimate reason, label it clearly. The available axis options can depend on the chart and Excel version, so check the resulting chart rather than assuming that a setting has the desired visual effect.
Give the chart a descriptive title and make category labels short enough to fit around the perimeter. Use a legend when several series are present, and choose line colors with strong contrast. Data labels can help readers identify exact values, but labels on every point may crowd a chart with many categories. A useful compromise is to label a key series or include the source table next to the chart.
Worked example: comparing product ratings
Suppose three products receive scores from 1 to 5 for reliability, setup, comfort, battery life, and value. With those five categories in A2:A6 and product names in B1:D1, enter the scores in B2:D6 and insert a Radar with Markers chart. A consistently high line would show a product with strong ratings across the criteria; a pronounced dip on one spoke would identify a relative weakness.
Before interpreting the pattern, confirm that all scores use the same rating scale and that higher always means better. If a category is a cost where lower is preferable, either explain that the direction differs or transform the measure in a transparent, consistent way before charting. Do not silently reverse one score: a visually neat shape can hide an inconsistent definition. For close scores, show the table or add data labels, since the chart’s geometry may make small differences difficult to judge precisely.
Common problems and how to fix them
- The series and categories are reversed: Select the chart and choose Chart Design > Switch Row/Column. Check that the legend names are the series you intend to compare.
- A category or series is missing: Confirm that the selected source range includes its label and values. Use Chart Design > Select Data to inspect the chart’s data range and series.
- The shape looks distorted: Check for different units, inconsistent scoring directions, or an automatic axis scale that changes the visual emphasis. A radar chart cannot make incomparable measures comparable by itself.
- Labels overlap: Shorten category names, enlarge the chart, reduce the number of categories, or move the chart to a wider layout. Removing useful labels entirely can make the spokes impossible to interpret.
- Lines disappear or appear incomplete: Check for blank cells, text values, or missing observations. Decide whether a blank means zero, unknown, or not applicable; those meanings are not interchangeable. Avoid replacing unknown values with zero unless zero is genuinely the measurement.
Another common misconception is that a larger filled area necessarily means a better result. The visual area depends on the scale, the number and order of categories, and how the values vary around the chart. Compare the actual measurements and explain what a high or low value means rather than treating area as a score.
When another chart is a better choice
Choose a chart based on the comparison readers need to make. A radar chart emphasizes an overall profile, but people often judge lengths and positions more accurately than angles or enclosed areas. A clustered bar chart is usually clearer when the priority is comparing exact values across categories. A line chart can be better when categories have a meaningful sequence, such as months or stages, rather than a circular arrangement.
Radar charts also become crowded as series and categories accumulate. If many products must be compared, consider a table with conditional formatting, small multiples, or separate charts grouped by a meaningful subset. Do not arrange categories in a circle merely because there are several of them; the circular order can imply a relationship between the last and first categories that does not exist.
Frequently Asked Questions
Is a radar chart the same as a spider chart?
Usually, yes. “Spider chart” is a common name for a chart with category spokes and values plotted outward from the center. Excel labels its chart type Radar.
Can I make the gridlines perfectly circular in Excel?
Excel’s built-in Radar chart uses its radar-style grid, which follows the spokes and appears as polygonal rings. It does not offer a separate built-in chart type with perfectly circular value rings. Avoid confusing the chart’s circular layout with circular gridlines.
How many categories should a Radar chart have?
There is no fixed Excel limit that makes a chart readable. In practice, a small set of clearly named, comparable categories is easier to interpret. If labels crowd or lines become hard to distinguish, split the data into smaller charts or use another chart type.
Can a Radar chart show negative values?
Excel charts numeric data, but negative values are often awkward to interpret in a radial layout because the center and outward direction are central to reading the chart. For measures that naturally include negatives, a bar or line chart is generally easier to explain.
Why does my Radar chart look different after I change the data?
Excel may update the axis bounds, which changes the apparent size of the plotted shape. Review Format Axis and keep comparable charts on consistent bounds. Also check whether the selected data range or row-and-column orientation changed.
Related
- Bottom Border Excel Shortcut and How to Use It
- Billion Number Format in Excel: Display Values in Billions
- Birthday List Excel Template: Setup and Tips
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Aggregate Excel Pivot Tables: Methods and ExamplesTo aggregate data in an Excel PivotTable, select a clean source range, choose Insert > PivotTable, and place…
- Excel Graph: How to Move the X-Axis to the BottomTo move an Excel chart’s x-axis to the bottom, select the vertical (y) axis, open Format Axis, and…
- Revenue Waterfall Chart in Excel: Build and Format OneTo make a revenue waterfall chart in Excel for Microsoft 365, put the opening revenue and each increase…
- Excel Bar Graph Too Skinny? Fix Bar Width and SpacingIf an Excel bar graph looks too skinny, select a bar, open Format Data Series, and reduce Gap…
- Excel Trendline Not Showing? Causes and Fixes in ChartsIf the Trendline option is missing in Excel, select a data series inside the chart, not the chart…
- How to Draw a Histogram in Excel: Step-by-Step GuideTo draw a histogram in Excel for Microsoft 365 on Windows, put your numeric observations in one column,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.