# How to Rotate a Sunburst Chart in Excel – 2 Methods

The Sales Data of XYZ Store is the sample dataset.

Create a Sunburst Chart and rotate it.

### Method 1 – Using the Camera Tool

Steps:

• This is the output.

• Select More Commands… .

The Excel Options dialog box will open.

• Click the drop-down icon as shown below.
• Choose All Commands.

• Select Camera.
• Choose All Commands.
• Click OK.

• Select the cells behind the chart area.

• Press ENTER.

• Click and hold the rotation option and rotate the Sunburst Chart.

The Sunburst Chart will rotate:

### Method 2 – Applying the Sort Option in Excel

Steps:

• Create a Support Sheet as shown below.

• Enter the following formula in E5.
`=XLOOKUP(B5,'Support Sheet'!B17:B32,'Support Sheet'!C17:C32)`

B5 indicates the first cell in the Sales Person column, B5:B20 refers to the cells in the Sales Person column of the Support Sheet, and C5:C20 represents the cells in the Sales column in the Support Sheet. The the XLOOKUP function will return the Sales data in E5:E20.

• Press ENTER.

Sales data of Peter for Week 1 in the North Region will be displayed in E5.

• Drag down the Fill Handle to see the result in the rest of the cells.

• Select the entire dataset.
• Go to the Home tab.
• Choose Sort & Filter in Editing.
• Select Sort A to Z.

Note: You can choose other Sort & Filter option.

The dataset will be sorted and the Sunburst Chart will rotate:

Read More: How to Sort Excel Sunburst Chart Order

## How to Create a Sunburst Chart with a Percentage in Excel

Steps:

• Use the following formula in F5 to calculate the Percentage.
`=E5/(SUM(\$E\$5:\$E\$20))`

E5 indicates the first cell in the Sales column, and \$E\$5:\$E\$20 represents the cells in the Sales column.

• Press ENTER.

This is the output.

• Drag down the Fill Handle to see the result in the rest of the cells.

• Press and hold CTRL and select the data as shown below.

• Click Chart Elements.
• Click the Arrow option beside Data Labels.
• Choose More Data Label Options…

• Check Value in the Format Data Labels dialog box.

The Sunburst Chart will include the percentage values:

## Related Articles

<< Go Back toÂ Sunburst Chart in ExcelÂ |Â Excel ChartsÂ |Â Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Zahid Hasan

Zahid Hassan, BSc, Industrial and Production Engineering, Bangladesh University of Engineering and Technology, has worked with Exceldmy for 1.5 years. He has written 95+ articles for Exceldemy. He has worked as an Excel & VBA Content Developer. He also worked as a VBA Developer for the Template team. Currently, he is working as a Junior Software Developer for the Excel Add-in project. He is interested in Software Development, Python, VBA, VB.NET, and Data Science, expanding his expertise in... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF