Share via

Chart is resizing when updating pivot table

Bogert Marco 1 Reputation point
2020-08-10T14:08:28.083+00:00

Dear sir or madam,

I created a pivot table 1 and pivot chart (Chart is related to another pivot table 2) on the same sheet.
When I update the pivot table by changing filters, the size of the chart does not stay the same.
Properties Chart: don't mo16728-voorbeeld.jpgve or size with cells.

I have inserted a picture. I change the slicers. Than Pivot table is getting shorter or longer. The problem occurs that the size of the "pie" chart is also changing.

Is there a solutions for this problem?
Thank you in advance for your help.

Best regards, Marco

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,713 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Emi Zhang-MSFT 24,761 Reputation points Microsoft Vendor
    2020-08-11T09:20:59.957+00:00

    Because you filter the table by slicer in Excel but not a PivotTable, please try this method and help you fix the Chart size:
    17011-85.gif

    1. Select all cells- Right click Format Cells- Under Protection- check Locked option:
      16819-86.gif
    2. Right click Chart- select Format Chart Area- under Size&Properties option- check Lock aspect ratio- select Don't move or size with cells:
      16996-87.gif
    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.