Excel Rotate Pie Chart
To rotate the pie chart in Excel, we have several options. Those include:
- Changing the first slice angle is presented in the series options.Using the camera tool commands from the quick access toolbarQuick Access ToolbarQuick Access Toolbar (QAT) is a toolbar in Excel that may be customized and is located on the upper left-hand side of the window. It enables users to save important shortcuts and easily access them when needed.read more.
Using these options helps apply the rotation on the pie chart in Excel.
You are free to use this image on you website, templates, etc., Please provide us with an attribution linkHow to Provide Attribution?Article Link to be HyperlinkedFor eg:Source: Rotate Pie Chart in Excel (wallstreetmojo.com)
How to Rotate Pie Chart in Excel?
Example #1 – 2D Rotate Pie Chart
The creation of 2D rotates a pie chartPie ChartMaking a pie chart in excel can help you with the pictorial representation of your data and simplifies the analysis process. There are multiple kinds of pie chart options available on excel to serve the varying user needs.read more on the diameter of nine planets in the solar system.
Now, the pie chart looks good, clearly representing the small slices.
- Open the Excel worksheet. Insert the data regarding the diameter of nine planets in the table format, as shown in the below-mentioned figure. Select the data by pressing “CTRL+A” by placing the cursor anywhere in the table or selecting through the mouse. Go to the “Insert” tab on the ribbon. Next, move the cursor to the “Charts” area to select the “Pie Chart.” Click on the “Pie Chart” and select the “2-D Pie,” as shown in the figure, and develop a 2D pie chart. We get the following 2D Rotate Pie Chart. In the next step, change the chart’s title and add data labels in the next step. To rotate the pie chart, click on the chart area. Right-click the pie chart and select the “Format Data Series” option. Change the angle of the first scale to 90 degrees to display the chart properly.
Example #2 – 3D Rotate Pie Chart
Creation of a 3D rotate pie chart on the population of various states in India.
Step 1: Open the Excel worksheet.
Step 2: Insert the data regarding the population of the Indian states in the table format in excelTable Format In ExcelExcel comes with a number of table styles that you may quickly apply to a table format. In Excel, you can design and use a new custom table style of your choice. read more, as shown in the below-mentioned figure.
Step 3: Select the data by pressing “CTRL+A” by placing the cursor anywhere in the table or selecting through the mouse.
Step 4: Go to the “Insert” tab on the ribbon. Move the cursor to the “Chart” area to select the “Pie Chart.”
Step 5: Click on the “Pie Chart” and select the “3-D Pie,” as shown in the figure, and develop a 3D pie chart.
Step 6: In the next step, change the chart’s title and add data labels in the next step.
Then, the chart will look like this:
Step 7: Click on the “Chart Area” to rotate the pie chart. Right-click the pie chart and select the “Format Data Series” option.
It opens the “Format Data Series” pane, as shown in the figure.
Step 8: Change the angle of the first scale to 90 degrees to display the chart properly.
Step 9: We get the following rotate pie chart.
Example #3 – Doughnut Rotate Pie Chart
Creation of a rotate pie chart for the doughnut chart in excelDoughnut Chart In ExcelA doughnut chart is a type of excel chart whose visualization is similar to pie chart. The categories in this chart are parts that, when combined, represent the whole data in the chart. A doughnut chart can only be made using data in rows or columns.read more.
Step 1: Open the Excel worksheet. Insert the data regarding the sales made by a company in two years in different regions in the table format, as shown in the below-mentioned figure.
Step 2: Select the data by pressing “CTRL+A” by placing the cursor anywhere in the table or selecting through the mouse.
Step 3: Go to the “Insert” tab on the ribbon. Move the cursor to the “Chart” area to select the “Pie Chart.”
Step 4: Click on the “Pie Chart” and select the “Doughnut” chart, as shown in the figure, and develop the doughnut pie chart.
Step 5: In the next step, change the chart title and select layout 6 under the “Quick Layout” option to change the chart.
Step 6: Click on the “Chart” area to rotate the pie chart. Right-click the pie chart and select the “Format Data Series” option.
Step 7: Change the angle of the first scale to 150 degrees and change it to display the chart properly.
Step 8: We get the following doughnut to rotate the pie chart.
How to Use Rotate Pie Chart in Excel?
The Rotated pie chart has many applications. Those include:
- Changing the worksheet’s orientation to ensure the pie chart’s proper fit at the time of printing.Modifying the location of the legend in the pie chart.Reversing or changing the order of the slices in the pie chart.Moving the individual labels of the pie chart.Rotating the pie chart in various degrees, including 900, 1800, 2700, and 3600 in the clockwise and anti-clockwise directions.Formatting the data series on the context menu of the pie chart.Utilization of the camera tool effectively to apply the rotation on the chart from various angles.
Things to Remember
- Starting the rotation of the pie chart with 900 degrees is a good option.The use of the camera tool in rotating the pie chart results in decreasing the resolution and changing the appearance of the object.The practice of starting displaying the small parts of the pie chart at 12 o’clock is not right.The doughnut pie chart is useful when two data series are presented.
Recommended Articles
This article is a guide to the Rotate Pie Chart in Excel. Here, we discuss how to rotate the 2D, 3D, and doughnut pie charts in Excel with examples and a downloadable template. You can learn more about Excel functions from the following articles: –
- How to Create Excel Panel Chart?How To Create Excel Panel Chart?The panel chart is a chart that displays different categories of data for the same segment individually but in a single chart. For example, stock prices of four different companies in a week.read moreStep Chart in ExcelDot Plots in ExcelExcel Combo Chart