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.

how to rotate sunburst chart in excel

 


Method 1 – Using the Camera Tool

Steps:

  • This is the output.

The Camera tool is not added by default in the Quick Access Toolbar of Excel. To add it manually:

  • Click Customize Quick Access Toolbar.
  • Select More Commands… .

Using the Camera Tool to rotate sunburst chart in excel

The Excel Options dialog box will open.

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

Editing Excel Options dialogue box to rotate sunburst chart in excel

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

The Camera tool will be added to the Quick Access Toolbar.

  • Select the cells behind the chart area.
  • Click Camera in Quick Access Toolbar.

  • Press ENTER.

 

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

The Sunburst Chart will rotate:

Final output of method 1 to rotate sunburst chart in excel


Method 2 – Applying the Sort Option in Excel

Steps:

  • Create a Support Sheet as shown below.

Applying Sort Option to rotate sunburst chart in excel

  • 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.

Using XLOOKUP function to rotate sunburst chart in excel

  • 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:

Final output of method 2 to rotate sunburst chart in excel

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.

How to Create Sunburst Chart with Percentage in Excel

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:

Final output of method 3 to Create Sunburst Chart with Percentage in Excel


Download Practice Workbook


Related Articles


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

Get FREE Advanced Excel Exercises with Solutions!
Zahid Hasan
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

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo