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.