Whenever i expand the + symbol in pivot table, the expression columns moves towards right and finally pivot table occupies more space in the sheet.
I want the pivot table to occupy the same space even when i click on + symbol. But scroll bars can enable. I have seen this in a demo app. But dont know what setting in need to do in pivot table properties.
You could put the pivot table in a container, this will allow you to scroll inside the container but the chart will not grow beyond the container dimensions.
