Radar Chart in Google Sheets: How to Create and Read One

To make a radar chart in Google Sheets, put category names in the first column and each data series in its own column, select the table, then choose Insert > Chart. In the Chart editor, open Setup and choose Radar chart as the chart type.

What a radar chart shows

A radar chart, also called a spider chart, plots several measures around a central point. Each measure gets a spoke, and values are marked along that spoke. Connecting the marks creates a shape for each series, making it possible to compare profiles across the same set of categories.

For example, a team might rate a project on cost, speed, reliability, support, and ease of use. A radar chart can show whether one option is consistently strong or has a distinctive mix of strengths and weaknesses. It is most useful when the categories are related, measured on comparable scales, and limited in number. It is not a general-purpose replacement for a bar or line chart: the layout emphasizes overall patterns, not precise reading of every value.

The chart’s polygon can attract attention, but its area is not a dependable summary score. A large-looking shape does not automatically mean a better result, especially if the axes use different units or the category order changes. Read the spokes and values, not just the silhouette.

Arrange the source data

Google Sheets needs to identify one set of category labels and one or more series of values. A simple layout puts labels down the first column, series names across the first row, and numeric values in the body of the table. For instance:

Cell A1: Category; cells A2:A6: Cost, Speed, Reliability, Support, and Ease of use.
Cells B1:C1: Option A and Option B.
Cells B2:C6: the scores for each option, all measured on the same scale.

Use a clear header for every series and a clear label for every category. Keep the selected range to the actual table rather than including notes, totals, or empty rows. A blank row inside the range can make the chart confusing, while unrelated numbers can be interpreted as another series.

Before charting, check that values are numeric rather than numbers stored as text. Also decide how to handle missing ratings. A blank does not mean the same thing as zero; enter a value only when it has a defensible meaning, or leave the item out of the comparison and explain why. Avoid combining measures such as dollars, days, and five-point ratings on one chart unless you first convert them to a meaningful shared scale.

Create the chart in Google Sheets

Select the complete data range, including category labels and column headings.
Choose Insert > Chart. Sheets inserts a chart and opens the Chart editor, usually at the right of the sheet.
In the editor’s Setup tab, open Chart type and select Radar chart.
Check the data range and confirm that the category labels and series are assigned correctly. If the chart has treated rows as series instead of columns, use the row/column switching control in Setup and review the preview.
Give the chart a descriptive title and resize or move it so labels and the chart are easy to see.

The chart remains linked to its source cells, so changing a score in the selected range updates the visualization. If you add new categories or series outside the original range, check whether the chart’s data range includes them; do not assume every new row or column will be included automatically.

Set labels, series, and appearance

Use the preview in the Chart editor to check the chart before adjusting its look. If category names appear as series, or a series name appears as a category, revisit Setup and the row/column orientation. Confirm that the first row is being used for headers and the first column for labels when that matches your layout.

In Customize, the available controls depend on the chart and current Sheets interface. You can set a chart title under Chart & axis titles, and use the relevant customization options to adjust presentation, such as the legend or series styling. Choose colors that remain distinct and check the chart at its intended display size. A title such as “Customer ratings by service area” explains more than “Results.”

Keep category labels short enough to scan, but specific enough to distinguish measures. If the legend is hard to interpret, rename the series headers in the data table; the chart generally uses those headers as series names. Formatting should clarify comparisons, not imply that a small numerical difference is more important than it is.

Read a radar chart carefully

Each spoke corresponds to one category, and a point farther from the center represents a larger value on that category’s scale. A line connects the values for a series. When several series are shown, compare them spoke by spoke: one option may lead on speed while another performs better on cost. The chart is strongest at showing that general profile.

Category order affects the shape. Rotating or reordering the same categories can make the polygons look quite different without changing any values. If readers need to compare multiple charts, keep the category order consistent. Likewise, keep the scale consistent across charts and comparisons. A radar chart can make differences look dramatic when readers do not know the scale or its limits.

Consider a five-point rating example in which Option A scores 4 on every category and Option B scores 5, 3, 4, 4, and 4. The chart makes Option A’s even profile and Option B’s higher speed score visible. It does not establish which option is preferable: that depends on whether speed matters more than the other categories. Add context or a separate decision rule rather than treating the larger-looking polygon as a verdict.

Choose an appropriate scale and number of categories

Radar charts are clearest when every spoke uses a comparable scale with the same direction. If higher scores mean better performance on four measures but higher cost means worse performance on the fifth, the chart mixes favorable and unfavorable directions. You can recode a measure only if the transformation is transparent and appropriate; otherwise, label the interpretation carefully or use separate charts.

Too many categories make labels and lines crowded. There is no universal maximum that makes a chart readable: the practical limit depends on label length, number of series, and display size. As a rule of presentation, start with the few measures that answer the question and move supporting detail to a table or another chart. Many overlapping series are particularly difficult to distinguish, even with different colors.

Be cautious with scales that do not start at zero or that use different bounds across charts. A changed scale can alter the apparent size of differences. If a reader cannot tell what the center and outer edge represent, include the scale in the chart title, labels, or nearby explanation, and provide the underlying values when precision matters.

Common problems and fixes

The chart shows the wrong categories: Check the selected range, headers, and row/column orientation in Setup. Make sure the category names are in the column or row that Sheets is using for labels.
There is only one shape, or the legend is unhelpful: Confirm that each comparison group occupies its own series column and that each column has a descriptive heading. A layout with series in rows may need the row/column setting changed.
Values or labels are missing: Look for blanks, merged cells, stray text in numeric columns, or a range that stops before the last row. Correct the source table, then review the chart’s data range.
The chart looks crowded: Reduce the number of categories or series, shorten labels, enlarge the chart, or use a different chart type. Adding more colors will not solve a cluttered comparison.
The shapes look misleading: Check whether the measures share a scale and direction, and keep the category order and scale consistent when making comparisons. Show the data values if exact differences matter.

When troubleshooting, change one thing at a time and watch the chart preview. That makes it easier to tell whether the issue is the source layout, the chart’s interpretation of the range, or a design choice.

When a different chart is better

A radar chart is a reasonable choice when the goal is to compare a few profiles over the same set of dimensions. A grouped bar chart is often easier for precise comparisons because bars share a common baseline. A line chart is better when values follow a meaningful sequence, such as dates or stages; connecting categories that have no natural order can suggest a relationship that is not there.

A table may be the clearest option when readers need exact scores, and a heat map can show a larger grid of categories and groups compactly. In Google Sheets, conditional formatting can add color to a table without turning it into a radar chart. Choose the display based on the question: use radar for a broad profile, bars for direct comparisons, and a table when precision or detail is central.

Google Sheets and Microsoft Excel both offer radar-style charts, but their chart editors and formatting controls are not identical. Instructions for one program should not be assumed to match the other. In Sheets, begin with Insert > Chart and select the chart type in the Chart editor rather than following Excel ribbon directions.

Frequently Asked Questions

Does Google Sheets have a radar chart?

Yes. In Google Sheets in a web browser, select your data, choose Insert > Chart, then select Radar chart under Setup > Chart type in the Chart editor.

How do I add another series to a radar chart?

Add the new series as another column with a heading and one value for each category, then expand or correct the chart’s data range in Setup. Check the preview to confirm the new column appears as a separate series.

Can a radar chart show negative values?

Radar charts are generally easiest to interpret with nonnegative values on a clear shared scale. If your data includes negative numbers, verify how the chart displays them and consider a bar chart, which usually makes values on both sides of zero easier to read.

Why does my radar chart look different after I reorder categories?

The chart connects category values in their displayed order, so reordering categories changes the polygon’s outline even though the values are unchanged. Keep the order fixed when comparing charts, and do not interpret polygon area as a score.

Can I make a radar chart with one data series?

Yes. A single series can show one profile across several categories. A radar chart is often more useful for comparison when a second series provides context, but one series can still reveal a pattern across dimensions.

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.