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:
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:
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.
Search for ChartExpo in the marketplace.
Click on ChartExpo and then Install. Give ChartExpo permissions to access your data.
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.
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.
