Now, click on the Customize Quick Access Toolbar option as marked in the following image.

The Camera tool is not added by default in the Quick Access Toolbar of Excel.

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

Let’s use the following steps to do this. Using the Camera tool is one of the most effective ways to rotate a 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.

Our aim is to create a Sunburst Chart and then rotate it. Let’s say, we have the Sales Data of XYZ Store as our dataset. In this section of the article, we will learn two simple methods to rotate Sunburst Chart in Excel. Right-click the value axis labels you want to format.2 Simple Methods to Rotate Sunburst Chart in Excel

To change the format of numbers on the value axis: On the Character Spacing tab, choose the spacing options you want. On the Font tab, choose the formatting options you want. Right-click the category axis labels you want to format, and click Font. To change the format of text in category axis labels: Change the format of text and numbers in labels

In the Axis label range box, enter the labels you want to use, separated by commas.įor example, type Quarter 1 ,Quarter 2,Quarter 3,Quarter 4. In the Horizontal (Category) Axis Labels box, click Edit. Right-click the category labels you want to change, and click Select Data. To keep the text in the source data on the worksheet the way it is, and just create custom labels, you can enter new label text that's independent of the worksheet data: Type the text you want in each cell, and press Enter.Īs you change the text in the cells, the labels in the chart are updated. Your chart uses text from its source data for these axis labels.ĭon't confuse the horizontal axis labels-Qtr 1, Qtr 2, Qtr 3, and Qtr 4, as shown below, with the legend labels below them-East Asia Sales 2009 and East Asia Sales 2010.Ĭlick each cell in the worksheet that contains the label text you want to change. In a chart you create, axis labels are shown below the horizontal (category, or 'X') axis, next to the vertical (value, or 'Y') axis, and next to the depth axis (in a 3-D chart).

Excel 2016 chart axis labels angle