The following AppleScript code sets the size of the last chart added to a sheet in Excel - to 30cm wide and 20cm tall. (I experimented with the numerical values but I don’t understand them.)
tell application "Microsoft Excel" tell active sheet tell last chart object set height to 567 set width to 850.5 end tell end tell end tell
This was tough as there’s not much on the web about this.
I have a question, though:
How to I get the selected chart, not just the last one added? (Usually the last one added is the one I want to resize but I’d rather not assume that.)
(The above script will be run from Keyboard Maestro, and probably triggered by a button in Metagrid.)