How to Create Radar Chart in Google Sheets [Step by Step Guide]

Published on

This tutorial explains how to create a Radar Chart, also known as a Spider Chart, in Google Sheets with step-by-step instructions.

A Radar Chart is a simple two-dimensional chart. You can arrange data in columns or rows in a worksheet to plot in a radar chart.

In this chart, you can show one or more variables or multivariate data, with one spoke for each variable. Data points are drawn clockwise around the chart.

Purpose of a Radar Chart or Radar Graph

You can use a Google Sheets Radar Chart, also known as a Spider Chart, similar to a Column Chart for comparison.

When the number of variables is large, use a Radar Chart, which offers a clutter-free data visualization experience. It allows you to see the relative strengths and weaknesses of different variables at a glance.

However, in my opinion, the readability of a Radar Chart is far behind that of a Column Chart. While Radar Charts are useful for showing relationships between multiple variables, they can become difficult to interpret when dealing with complex datasets.

Therefore, it’s important to choose the chart type that best fits your specific data and presentation needs.

How to Create a Radar Chart in Google Sheets

Below are two examples: one compares the allocated budget versus actual expenses, and the other compares the performance of two smartphones. Both are small and fictional datasets used to easily explain the chart.

Example 1: Allocated Budget vs Actual Expenses

My sample data consists of various expense categories in column A and the corresponding allocated budget and actual spending amounts in columns B and C.

Let’s compare my monthly allocated budget and actual spending using a Radar Chart in Google Sheets.

Sample Data for Radar Chart Creation:

ExpensesAllocated Budget (in thousands)Actual Spending (in thousands)
Sales109
Marketing1514
Development2018
Customer Support3530
Information Technology4040
Administration54

Steps to Create a Radar Chart:

  1. Select the data.
  2. Go to the Insert menu and click on Chart.
  3. Under Chart Type, select Radar Chart.
    Radar Chart Selection in Chart Editor
  4. The Radar Chart will be inserted as shown below.
Radar Chart in Google Sheets displaying Budget Allocation and Spending

Example 2: Smartphone Performance Comparison

Here is one more Radar Chart where I compare some of the features of two smartphones. See that below.

Please note that this comparison has nothing to do with the original phone’s features. It’s just sample data.

The sample data consists of phone features in column A and corresponding performance ratings of phone 1 in column B and phone 2 in column C.

CategoryPhone 1Phone 2
Performance55
Display44.5
Storage44
Camera44.5
Battery43.5
RAM44.5

To create this Radar Chart, select the data and click Insert > Chart, then choose Radar Chart.

Radar Chart in Google Sheets displaying comparison of two smartphones

Customizing Radar Charts in Google Sheets

Radar Charts in Google Sheets typically require minimal customization. You may need to adjust the chart title according to your needs and possibly turn off axis titles, among other adjustments.

You can access all Radar Chart customization options within the “Customize” tab of the chart editor sidebar panel.

If the panel isn’t open, double-click any blank area of the chart.

Customization Options Include:

  • Chart and Axis Titles: Add or remove chart titles, subtitles, and axis titles.
  • Series: Modify line colors and adjust data point size and shape.
  • Legend: Toggle legends on or off and adjust their position within the chart area.

These settings are essential for fine-tuning your Radar Chart to suit your needs.

Resources

Prashanth KV
Prashanth KV
Your Trusted Google Sheets and Excel Guide Prashanth KV brings a wealth of experience in Google Sheets and Excel, cultivated through years of work with multinational corporations in Mumbai and Dubai. As a recognized Google Product Expert in Docs Editors, Prashanth shares his expertise through insightful blogging since 2012. Explore his blog for practical tips and guidance on maximizing your spreadsheet skills.

Finding Most Frequent Text in Excel with Dynamic Array Formulas

Looking to identify the most frequently occurring text in Excel? You can do this...

Hierarchical Numbering Sequences in Excel

Creating hierarchical numbering sequences in an Excel spreadsheet can significantly improve the way you...

How to Easily Repeat a Sequence of Numbers in Excel

Excel offers multiple ways to accomplish tasks, and the simplicity of each approach depends...

Create a Sequence of Dates at Every Nth Row in Excel (Dynamic Array)

Would you like to create a sequence of dates in every nth row in...

More like this

XMATCH Row by Row: Finding Values Across a Range in Google Sheets

Using the BYROW function with XMATCH in Google Sheets allows us to match values...

Limit Formula Expansion to a Specific Row in Google Sheets

In this tutorial, I’ll explain how to limit the expansion of an array formula...

3-D Referencing Structured Data Tables in Google Sheets

When you have several tables within a single sheet—not across multiple sheets in a...

1 COMMENT

  1. Hi, how I could show the value of series for all axles? On Radar from Sheets, you can see just the values in one axle.

LEAVE A REPLY

Please enter your comment!
Please enter your name here

This site uses Akismet to reduce spam. Learn how your comment data is processed.