In this article:

Sunburst Chart in Google Sheets (How to Create It in 2024)

May 8, 2024

How to Create a Sunburst Chart in Google Sheets

Google Sheets currently does not natively support sunburst charts. However, you can create sunburst charts in Google Sheets through third-party tools like ChartExpo. Here's how to do it:

Step 1: Prepare Your Data

First, you'll need to organize your data in a hierarchical structure. For this example, let's say we're analyzing sales data. Your data should be structured in a way that reflects the hierarchy of the information you're visualizing. Here's a simplified structure:

sunburst chart google sheets

Step 2: Install ChartExpo

If you haven't already, you'll need to install the ChartExpo add-on. Google Sheets currently does not support the sunburst chart type. Here's how to install ChartExpo: 

Go to Extensions > Add-ons > Get add-ons.

google sheets sunburst chart

Search for ChartExpo in the marketplace. 

sunburst chart in google sheets

Click on ChartExpo and then Install. Give ChartExpo permissions to access your data.

Step 3: Create a Sunburst Chart

After installing ChartExpo, go to Extensions > Charts, Graphs & Visualizations by ChartExpo > Open

Select Add New Chart from the ChartExpo panel that appears on the right side of your screen. In the search box, type “Sunburst Chart” and select it from the list.

You will be prompted to select the sheet with your data. Ensure your data range is correctly selected. In this case, select the columns that contain your hierarchy and sales data.

Tip: You can follow their quick tutorial (Help Wizard) to get started.

Assign the hierarchy levels (Region, Category, Product) to the dimension fields and the Sales to the metric field. Click on Create Chart.

Step 4: Analyze Your Chart

After creating the chart, you'll see a sunburst representation of your sales data. The free version of ChartExpo has a watermark on it, as you can see below:

The innermost circle represents the top level of the hierarchy (Region in this example), followed by subsequent levels (Category, then Product). The size of each segment is proportional to its sales figures, allowing you to quickly identify which areas are performing well or need improvement.

We hope that this article has helped you and given you a better understanding of how to make a sunburst chart in Google Sheets using an add-on. If you enjoyed this article, you might also want to check out our Eisenhower matrix template in Google Sheets and check out our article on how to use the GROWTH rate formula in Google Sheets.

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.
Get your copy of our free Google Sheets automation guide!
  • 27 pages of Google Sheets tips and tricks to save time
  • Covers pivot tables and other advanced topics
  • 100% free

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->