I have 3 charts in a container. When I click on another sheet and then come back to the sheet with the container, the size of one or more of the charts frequently changes. Can I prevent this?
When you are navigating to the other sheet, do you make/clear selections on data? If Yes, these selections might be affecting the amount of data in your chart and hence the change in size.
To avoid this, go to Chart Properties -- Caption tab and fix the chart Width and Height values. Now go the Layout tab on the same window and uncheck Size to Data option.
If you are not making any selections and still experience the change in chart sizes while navigation from and to the sheet, you can fix the chart Height and Width to be the same as the height and width of the container you are using. Also, uncheck Allow Move/Size option on the Layout tab in the Chart properties.
Tried without success. The only thing that seems to work is clicking n number of times on the tab representing the pertinent container. It eventually resizes all the charts to be totally visible.
Tried without success. The only thing that seems to work is clicking n number of times on the tab representing the pertinent container. It eventually resizes all the charts to be totally visible.
Tried without success. The only thing that seems to work is clicking n number of times on the tab representing the pertinent container. This eventually resizes all the charts to be totally visible.
