Chart size changes with change in data

  • Thread starter Thread starter nsd
  • Start date Start date
N

nsd

Hello,

I have created a table to get a chart. The table copies data from a Pivot
Table output. ( I understand that Pivot chart loses formating set once you
change the Pivot criteria).

So now, I'm able to get the format intact. However, whenever I change the
Pivot's Page criteria then my chart automatically enlarges or reduces in
size. The inner formating is okay and doesn't change. What would be the
problem??

Please advise.
nsd
 
Under Format Chart, properties, select
"don't move or size with cells"
since, as you've seen, a PivotTable auto-adjusts it size depending on
selections.
 
Back
Top