WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Free Tutorials
  • Certification Courses
  • Excel VBA All in One Bundle
  • Login
Home » Excel, VBA & Power BI » Excel Tutorials » Rotate Pie Chart in Excel

Rotate Pie Chart in Excel

Excel Rotate Pie Chart

To rotate a pie chart in excel, first, the user needs to create a pie chart using the data. It is best suited in different to effectively display a large number of tiny pie chart slices and proper layout tuning of the label to enhance slice visualization. The slices can be separated with space to easily differentiate them. Rotating supports in avoiding the overlap of labels and chart title and facilitating the considerable amount of empty area on each data label.

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

The use of these options helps in applying the rotation on the pie chart in Excel.

Rotate Pie Chart in Excel

How to Rotate Pie Chart in Excel?

You can download this Rotate Pie Chart Excel Template here – Rotate Pie Chart Excel Template

Example #1 – 2D Rotate Pie Chart

The creation of 2D rotates a pie chart on the diameter of nine planets in the solar system.

Step 1: Open the Excel worksheet.

Step 2: Enter the data regarding the diameter of nine planets in the table format, as shown in the below-mentioned figure.

Rotate Pie Chart in Excel Example 1

Step  3: Select the data by pressing CTRL+A by placing the cursor anywhere in the table or select through the mouse.

Example 1.1

Step 4: Go to the “insert” tab on the ribbon. Move the cursor to the chart area to select the pie chart.

Rotate Pie Chart in Excel Example 1.2.0

Step 5: Click on the Pie chart and select the 2D chart, as shown in the figure, and develop a 2D pie chart.

 Example 1.3

Step 6: We get the following 2D Rotate Pie Chart.

Rotate Pie Chart in Excel Example 1.4

Step 7: In the next step, change the title of the chart and add data labels to it.

 Example 1.5

Step 8: To rotate the pie chart, click on the chart area.

Rotate Pie Chart in Excel Example 1.6

Step 9: Right-click on the pie chart and select the “format data series” option.

Example 1.7

This opens the “format data series” panel, as shown in the figure.

Popular Course in this category
Sale
All in One Excel VBA Bundle (35 Courses with Projects)
4.9 (1,353 ratings)
35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion
View Course

Rotate Pie Chart in Excel Example 1.8

Step 10: Change the angle of the first scale to 90 degrees to display the chart properly.

 Example 1.9

Now the pie chart is looking good, representing clearly the small slices.

Rotate Pie Chart in Excel Example 1.10

Example #2 – 3D Rotate Pie Chart

Creation of 3D rotate pie chart on the population of various states in India

Step 1: Open the Excel worksheet.

Step 2: Enter the data regarding the population of the Indian states in the table format in excel, as shown in the below-mentioned figure.

Example 2

Step 3: Select the data by pressing CTRL+A by placing the cursor anywhere in the table or select through the mouse.

Rotate Pie Chart in Excel Example 2.1

Step 4: Go to the “insert” tab on the ribbon. Move the cursor to the chart area to select the pie chart.

Example 2.2

Step 5: Click on the Pie chart and select the 3D chart, as shown in the figure, and develop a 3D pie chart.

Example 2.3

Step 6: In the next step, change the title of the chart and add data labels to it.

Rotate Pie Chart in Excel Example 2.4

Then, the chart will look like as

Example 2.5

Step 7: To rotate the pie chart, click on the chart area. Right-click on the pie chart and select the “format data series” option.

Rotate Pie Chart in Excel Example 2.6

This opens the “format data series” pane, as shown in the figure.

 Example 2.7

Step 8: Change the angle of the first scale to 90 degrees to display the chart properly.

Rotate Pie Chart in Excel Example 2.8

Step 9: We get the following Rotate Pie Chart.

 Example 2.9

Example #3 – Doughnut Rotate Pie Chart

Creation of rotate pie chart for the doughnut chart in excel.

Step 1: Open the Excel worksheet. Enter 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.

Rotate Pie Chart in Excel Example 3

Step 2: Select the data by pressing CTRL+A by placing the cursor anywhere in the table or select through the mouse.

 Example 3.1

Step 3: Go to the “insert” tab on the ribbon. Move the cursor to the chart area to select the pie chart.

Rotate Pie Chart in Excel Example 3.2

Step 4: Click on the Pie chart and select the Doughnut chart, as shown in the figure, and develop the Doughnut pie chart.

Example 3.3

Step 5: In the next step, change the title of the chart and select the layout 6 under the “quick layout” option to change the chart.

Rotate Pie Chart in Excel Example 3.4

Step 6: To rotate the pie chart, click on the chart area. Right-click on the pie chart and select the “format data series” option.

 Example 3.5

This opens the “format data series” pane, as shown in the figure.

Example 3.6

Step 7: Change the angle of the first scale to 150 degrees and change to display the chart properly.

Rotate Pie Chart in Excel Example 3.7

Step 8: We get the following doughnut to rotate the pie chart.

 Example 3.8

How to Use Rotate Pie Chart in Excel?

Rotate pie chart has many applications. Those include

  • Changing the orientation of the worksheet to ensure that the proper fit of the pie chart 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 direction.
  • 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.
  • With 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 start displaying the small parts of the pie chart at 12’o clock is not good.
  • The doughnut pie chart is useful when two data series are presented.

Recommended Articles

This has been a guide to rotate the 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?
  • Step Chart in Excel
  • Dot Plots in Excel
  • Excel Combo Chart
0 Shares
Share
Tweet
Share
All in One Excel VBA Bundle (35 Courses with Projects)
  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Book Your One Instructor : One Learner Free Class
Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Login

Forgot Password?

WallStreetMojo

Download Rotate Pie Chart Excel Template

New Year Offer - All in One Financial Analyst Bundle (250+ Courses, 40+ Projects) View More