How to Rotate a Pie Chart

0

Hello, 

I have created a pie chart, but some of the parts should be replaced and rotated. How it could be done?

Answer
Discuss

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)
I've made it read this (note the extra brackets in bold to separate the labels and number data sides):
=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)
Hope this helps.
Discuss

Discussion

Jayden- thanks for seelecting my Answer. I just added something else of interest (hopefully) to my Answer.
John_Ru (rep: 1917) Sep 13, '21 at 9:10 am
Thanks a lot!
Jayden Smith (rep: 2) Sep 16, '21 at 4:21 am
Add to Discussion


Answer the Question

You must create an account to use the forum. Create an Account or Login