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

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.

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.

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.

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

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.

• After that, apply the following formula in cell E5.

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.

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

• Following that, use the previously mentioned steps to create the Sunburst Chart using this dataset.

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

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.

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.

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.

• Next, use the previously mentioned steps to create the Sunburst Chart and you will get the following chart on your worksheet.

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

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

• How to Insert Sunburst Chart with Conditional Formatting in Excel
• How to Insert Sunburst Chart in Excel

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