Minimising the Objects

[bharatkishore]

Hello All,

                  In my sheet i took 4 scatter charts and i kept some images in that charts.If i click on one chart the other charts should be automatically minimised and the selected chart should be on the first place.

                 I mean there  are two  up and to down charts.If i click on the down scatter chart it should go to top place and other charts should be automatically minimised.......

                 Can any one tell me how to do

Regards,

R.Bharat Kishore

[rohit214]

hi

go to  the chart>>properties>>caption>>check Auto minimize

thanks

rohit

[johnw]

Or in version 10+, for similar functionality with an arguably cleaner presentation, consider adding the charts to a container object.

[bharatkishore]

Hello John,

                    Thanks for reply...Is it possible to do only in individual scatter charts instead of using container.....

Regards,

R.Bharat Kishore

[johnw]

bharatkishore wrote:

Is it possible to do only in individual scatter charts instead of using container.....

Yes.  You can do it like Rohit said.

[bharatkishore]

Hello John,

                          Can we Change the X and Y position in Scatter Chart Which will be in the properties of Scatter Chart i.e Caption Through Macro Code.

                          If possible please tell me how to do?

Regards,

R.Bharat Kishore