Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a sheet with 8 graphs. there are 4 graphs using metric tons as the metric and 4 using short tons as the metric. I have two buttons that toggle one variable that set the visability of the graphs. If the variable is set to "Short Tons" then the short ton grpahs are visable and visa versa. All the graphs are set to display in the same space, with auto mininimize set so that they shrink as the next graph is selected.
The problem is that if I have graph A for metric tons display and switch my metric value to short tons I get a blank pallet. Is there any way to set the maximized setting for a report so that as I switch to short tons I also maximize the current graph what was being desplayed for metric tons?
That did the trick thanks so much for the help!