Hello,
I have created a pie chart, but some of the parts should be replaced and rotated. How it could be done?
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
How to Rotate a Pie Chart
0
Answers
0
Selected Answer
Hi Jayden and welcome to the Forum
There's a chart data series setting called "Angle of first slice" which can rotate the pie chart. Microsoft's guidance on using it is here: Rotate a pie chart
That's illustrated in the attached file as the right-hand chart with title Same Pie Chart with First Slice at 45°. With the same (small) data set, I've editted the data series so that the pie slices go in the reverse sequence. Instead of the standard formula:
=SERIES(,Sheet1!$A$6:$A$11,Sheet1!$B$6:$B$11,1)=SERIES(,(Sheet1!$A$11,Sheet1!$A$10,Sheet1!$A$9,Sheet1!$A$8,Sheet1!$A$7,Sheet1!$A$6),(Sheet1!$B$11,Sheet1!$B$10,Sheet1!$B$9,Sheet1!$B$8,Sheet1!$B$7,Sheet1!$B$6),1)Discussion
Jayden- thanks for seelecting my Answer. I just added something else of interest (hopefully) to my Answer.
John_Ru (rep: 6142) Sep 13, '21 at 9:10 am
Thanks a lot!
Jayden Smith (rep: 10) Sep 16, '21 at 4:21 am