Hello,
I have created a pie chart, but some of the parts should be replaced and rotated. How it could be done?
Hello,
I have created a pie chart, but some of the parts should be replaced and rotated. How it could be done?
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.