How to Rotate Sunburst Chart in Excel (2 Easy Ways)

Get FREE Advanced Excel Exercises with Solutions!

A Sunburst Chart is generally used to display the hierarchical data. The Sunburst Chart is a feature in Excel starting with version 2016. Relational datasets can be presented in a neat and concise manner in this chart. Inserting the Sunburst Chart is quite easy, but rotating a Sunburst Chart can be tricky, as there is no straightforward way to rotate a Sunburst Chart in Excel. In this article, we will learn two effective methods to rotate Sunburst Chart in Excel. So, let’s start this article and explore these methods.


How to Rotate Sunburst Chart in Excel: 2 Simple Methods

In this section of the article, we will learn two simple methods to rotate Sunburst Chart in Excel. Let’s say, we have the Sales Data of XYZ Store as our dataset. Our aim is to create a Sunburst Chart and then rotate it.

how to rotate sunburst chart in excel

Not to mention, we used the Microsoft Excel 365 version for this article; however, you can use any version according to your preference.


1. Using the Camera Tool

Using the Camera tool is one of the most effective ways to rotate a Sunburst Chart in Excel. Let’s use the following steps to do this.

Steps:

  • Firstly, follow the steps mentioned here to create the Sunburst Chart and you will get the following output on your worksheet.

The Camera tool is not added by default in the Quick Access Toolbar of Excel. So, we need to add this manually.

  • Now, click on the Customize Quick Access Toolbar option as marked in the following image.
  • After that, select the More Commands… option from the drop-down.

Using the Camera Tool to rotate sunburst chart in excel

As a result, the Excel Options dialogue box will open on your worksheet.

  • Now, in the Excel Options dialogue box, click on the drop-down icon as shown in the following picture.
  • Then, choose the All Commands option from the drop-down.

Editing Excel Options dialogue box to rotate sunburst chart in excel

  • Following that, scroll down and find the Camera option.
  • Then, select the All Commands option.
  • Next, click on the Add option.
  • Subsequently, click OK.

As a result, the Camera tool will be added to the Quick Access Toolbar.

  • After that, highlight the cells behind the chart area.
  • Then, click on the Camera tool from the Quick Access Toolbar.

  • Following that, press ENTER.

Subsequently, the option to rotate the Sunburst Chart will be available as demonstrated in the following picture.

  • Finally, click and hold the rotation option and rotate the Sunburst Chart according to your needs.

Consequently, your Sunburst Chart will be rotated and your chart should look something like the following image.

Final output of method 1 to rotate sunburst chart in excel


2. Applying Sort Option of Excel

Applying the Sort Option is another smart way to rotate a Sunburst Chart in Excel. There is no direct option in the Sunburst Chart to rotate it. We can rotate the chart by changing and sorting our dataset. Let’s use the steps mentioned below to rotate a Sunburst Chart in Excel.

Steps:

  • Firstly, we will create a Support Sheet as shown in the image below.

Applying Sort Option to rotate sunburst chart in excel

  • After that, apply the following formula in cell E5.
=XLOOKUP(B5,'Support Sheet'!B17:B32,'Support Sheet'!C17:C32)

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

  • Then, hit ENTER.

As a result, Sales data of Peter for Week 1 and for the North Region will be available in cell E5.

Using XLOOKUP function to rotate sunburst chart in excel

  • Now, apply the AutoFill option of Excel to get the remaining outputs.

  • Subsequently, select the entire dataset.
  • Then, go to the Home tab from Ribbon.
  • After that, choose the Sort & Filter option from the Editing group.
  • Finally, select the Sort A to Z option from the drop-down.

Note: You can also choose other Sort & Filter according to your preference. 

Consequently, your dataset will be sorted and the Sunburst Chart will be rotated, as demonstrated in the following picture.

Final output of method 2 to rotate sunburst chart in excel

Read More: How to Sort Excel Sunburst Chart Order


How to Create Sunburst Chart with Percentage in Excel

In this section of the article, we will discuss how we can create a Sunburst Chart with percentages in Excel. Let’s use the procedure outlined in the following section to do this.

Steps:

  • Firstly, use the following formula in cell F5 to calculate the Percentage.
=E5/(SUM($E$5:$E$20))

Here, cell E5 indicates the first cell of the Sales column, and the range of cells $E$5:$E$20 represents the cells of the Sales column.

  • After that, press ENTER.

How to Create Sunburst Chart with Percentage in Excel

As a result, you will have the following output on your worksheet.

  • Then, use the AutoFill option of Excel to get the rest of the percentages.

  • Following that, press and hold the CTRL key and then select the marked data shown in the image below.

  • Afterward, click on the Chart Elements option.
  • Then, click on the Arrow option beside the Data Labels field.
  • Now, choose the More Data Label Options…

Consequently, the Format Data Labels dialogue box will open on your worksheet.

  • Finally, check the box of the Value field from the Format Data Labels dialogue box.

Subsequently, your Sunburst Chart will include the percentage values as demonstrated in the image below.

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


Download Practice Workbook


Conclusion

So, these are the most common & effective methods you can use anytime while working with your Excel datasheet to rotate Sunburst Chart in Excel. If you have any questions, suggestions, or feedback related to this article you can comment below.


Related Articles


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

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
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