The complete process of rotating Excel pie charts is as below. In the Transform Range dialog box, select Range to single column or Range to single row that you want, see screenshot: 3. Select the column data cells, and then click Kutools > Range > Transform Range, see screenshot: 2. You can input different angles to rotate the slices till it finally meets your need. After installing Kutools for Excel, please do with following steps: 1. Change the value in the textbox, the pie chart will rotate accordingly.Ĥ. Switch to Series Options (the icon of histogram) and you can adjust the Angle of first slice here. The Format Data Series panel will show on the right of the page.ģ. Please note that you should click exactly on the pie chart instead of the blank background of the chart area.Ģ. First, double-click the pie chart to enable Format Data Series…panel on the right of Excel spreadsheet, or you can right-click it and choose Format Data Series… in the menu. But personally I want it to be on the left. Look at this chart below, the blue slice of A is on the upper right of the pie. But if you’re not satisfied with the location of these slices, how can you rotate the pie chart to finally meet your need? Let us now learn how to use the TRANSPOSE excel formula by taking an example, and what’s so special about it.If you’ve made a pie chart in Excel, you can apply any color or style you like to it easily. Therefore, it will not work by simply using the formula as we do for other excel functions in general. The TRANSPOSE function belongs to the array function. TRANSPOSE Function select a cell where you wish to display the result, click the Insert function Insert function icon select the Lookup and Reference. Consequently, you must press Ctrl + Shift + Enter to return the array result.

It is important to note that the Excel TRANSPOSE formula is an array function. array – In this argument, specify the range of cells that you wish to transpose.The text is rotated in the chosen direction in the selected cells. The icons to the left of the options show which way the text will rotate. This function belongs to the Reference formula group in excel. Make sure the Home tab is active and click the Orientation button in the Alignment section of the Home tab (the button with the slanted text). This function converts row to column and vice versa. The TRANSPOSE formula in excel is used to change the layout of the data by rotating columns to rows and rows to columns.

How to rotate columns in excel