Trellis Size To Data

[orital81]

Hi, I am using the Fit To Data checkbox on the Trellis Chart

but for some reason it doesn't work, see attached example.

On pivot table it's working good but on Trellis Pie Chart it's not,

Any Idea how to solve this?

[#2]

Hi Ori Tal,

I was looking the file you sent and the macro works, only you have to configure the trigger on the document.

You should set the action in the variable in the Document Properties options

Attached the new file

Regards

Thomas M.

[orital81]

Thanks Thomas, I have already found the solution but your answer is helpful anyway.