I have a spreadsheet that has multiple charts on multiple tabs. The data that is used for these charts is stored to the left of the chart in tables and when I add or remove rows to these tables the physical size of the chart changes.
What I want is a macro that I can use on ANY chart that I SELECT and then format the size of that chart only to 2.4" height by 4.05" in width. The macro recorder names the specific chart ("Chart 1", "Chart 2", etc...) but I want to be able to select the chart I am working on and run the macro to format that specific chart only. Is this possible and if so can someone show me that way?
Thanks!
What I want is a macro that I can use on ANY chart that I SELECT and then format the size of that chart only to 2.4" height by 4.05" in width. The macro recorder names the specific chart ("Chart 1", "Chart 2", etc...) but I want to be able to select the chart I am working on and run the macro to format that specific chart only. Is this possible and if so can someone show me that way?
Thanks!
