0

I have two pie charts side by side and I want them to be the same size.

However, in pie chart #2, I need to move the Data Labels away from the pie chart which means resizing the Chart Area.

The trouble is, when I resize the Chart Area, the Plot Area (containing the pie chart) also gets resized. I don't want this to happen. I need to lock the size of the Plot Area so it doesn't get resized when I resize the Chart Area.

Is this possible? If so, please can you let me know how?

I am using Excel in Office 365.

screenshot of chart

1

However, in pie chart #2, I need to move the Data Labels away from the pie chart which means resizing the Chart Area.

I think moving the Date Labels away does not means resizing the Chart Area.

The trouble is, when I resize the Chart Area, the Plot Area (containing the pie chart) also gets resized. I don't want this to happen. I need to lock the size of the Plot Area so it doesn't get resized when I resize the Chart Area.

Yes, when resizing the Chart Area, the Plot Area also gets resized. But you can size Plot Area again after resizing the Chart Area.

enter image description here

0

I opted to create a bigger pie chart that would encapsulate the bigger data labels and used that as the base size for both charts. Well, that was my initial solution, in the end I settled for XX% inside the segments and used legends underneath for the descriptors.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.