Is there any way to stop a single chart in a sheet from auto minimizing?
I have three charts, two of which are "big" charts that are the focus of the sheet. I would like these to auto minimize when the other is viewed (ie. if one is open and the other is minimized, when you double click the minimized one the currently opened one minimizes while the other opens).
However, I also have another chart which is off to the side displaying 3 fields (pivot table) of useful information. I don't want this chart to be minimized when one of the others are opened, but it is.
I see in the Caption tab of the chart properties that there are options for Auto Minimize; however this check box is selected and disabled. Does anyone know how I can uncheck this for a single chart? Currently this option is not checked for the sheet, however Allow minimize is.
I just realized that simply removing the "Allow Minimize" is enough. I had changed some settings before posting the settings that I thought were incorrect.