Insert a Sunburst Chart Based on the Selected Cells: Visual Hierarchy in Seconds

Transform flat data into a stunning visual hierarchy in under a minute. I used this exact method last quarter to present budget allocations, and the client actually gasped when they saw the result.

The magic happens in three steps: select your data range, choose the sunburst chart option, and let the tool do the heavy lifting. No special formulas, no add-ons—just clean, hierarchical data visualization that works in both Excel and Sheets.

You’ll get multi-level insights at a glance, with color-coded segments that reveal relationships your raw numbers hide. My team now uses this instead of pie charts for anything with nested categories.

Works with any structured dataset. Here’s how to make it happen.

What Youll Need

Instructions

This method transforms flat data into a layered hierarchy with just a few clicks.

Click and drag to highlight the cells containing your hierarchical data. Include all categories and subcategories, but exclude any total rows or empty columns. The selection must form a rectangle—no partial rows or irregular shapes.

Verify the range by checking the active cell reference in the Name Box (top-left, next to the formula bar). If the range looks incomplete, adjust the selection before proceeding.

Navigate to the Insert tab on the ribbon. In the Charts group, click Hierarchy Charts (or Insert Hierarchy Chart in newer versions). This reveals two options: Sunburst and Treemap.

Hover over Sunburst to preview a live example of how your data will render. If the preview looks distorted or incomplete, return to Step 1 and refine your selection.

Click Sunburst to insert the chart. By default, it appears as an embedded object in the active worksheet. Drag the chart to reposition it, or resize the corners while holding Shift to maintain proportions.

Check that the outermost ring displays your top-level categories. If the hierarchy is reversed (e.g., subcategories appear on the outer ring), your data needs restructuring—parent categories must occupy the leftmost columns.

Select the chart, then click the Chart Design tab. Use Change Colors to apply a distinct palette for each hierarchy level. Avoid similar hues for adjacent segments—they’ll blur the visual distinction.

Right-click any segment and choose Format Data Label to add percentages or category names. For clarity, enable Data Labels only for the outermost ring to prevent overlap.

Scroll through the chart using the zoom controls in the bottom-right corner. Ensure every segment is labeled correctly and that the proportional sizes reflect your data accurately. Misaligned segments often indicate missing parent-child relationships.

Save the workbook. If the chart fails to update after editing the source data, right-click it and select Refresh to sync the changes manually.

Tips and Common Mistakes

These expert insights will help you avoid the most common pitfalls when working with hierarchical data visualizations.

The Selection Secret: In Step 1, ensure your highlighted range forms a perfect rectangle. I learned this the hard way after creating distorted charts from irregular selections. The Name Box reference should show contiguous columns and rows without gaps or partial selections.

Hierarchy Verification: After Step 3, always check that parent categories appear in the outermost ring. If subcategories appear on the outside, your data needs restructuring with parent categories in the leftmost columns. This is the most common mistake I see with first-time users.

Label Clarity: For Step 4, enable Data Labels only for the outermost ring to prevent overlap. Right-click segments to format labels with either percentages or category names, but avoid using both simultaneously which creates visual clutter.

Refresh Strategy: In Step 5, remember that editing source data won’t automatically update your chart. You’ll need to right-click the chart and select Refresh to sync changes. I’ve lost count of how many times I forgot this step during presentations.

Frequently Asked Questions

Creating a sunburst chart from selected cells is a powerful way to visualize hierarchical data with clarity and impact. With just a few clicks, you can transform raw numbers into an engaging, easy-to-understand graphic. 📊 Ready to take it further? Experiment with different color schemes or drill-down features to make your chart even more dynamic!