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.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"nsd" wrote:

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