There a lot many different types of charts in my dashboard and I want to change the font size of all these charts ( except Pivot and Straight ) from 12 to 10. Going to each chart and changing the font size looks laborious because there are lot many of them and also hidden charts exist ( enabled when special conditions are met).
Please let me know of there is some easier way of doing this.
For this kind of things a macro might be handy. Unfortunately I don't have one handy at the moment. Perhaps searching this site will unearth one.
An alternative could to make all objects visible temporarily using the Show All Sheets and Objects option on the Security tab of the Document Properties window. Then change one chart to your liking. Next double click the Format Painter Tool icon in the Design workbar. Then click on the caption of chart you changed to copy its format. And then click the caption of all the other objects.