I want to minimize chart object even though if user double click on object it will not maximize. I tried through properties--> Caption--> unchecked 'Allow maximized' option. But not working this way, please share if you know.
My Chart contains many fields so it is not possible more ever in Straight/Pivot charts can not do like your example (In your attached you have taken table box).
I think you may well be limited to using a Macro then - so that you can attach this to an Action on a Text Box or Button.
Is there a reason why you can not show the user the information they are about to export? You can then have the XL icon in the caption too - which is more intuitive that the right click menu with Send To Excel half way down the list.
Hide the object n export the excel using button via macro. But note that, macro not work in web without ajax client. In macro, u can set format as u like.
Thanks & Regards, Mayil Vahanan R Please close the thread by marking correct answer & give likes if you like the post.
