I need to run a macro once changes were made to a chart via the use of Chart Filters (via the funnel icon) or after clicking on an active chart and using Select Data to uncheck/check series boxes. I’m hoping there is a possible solution to one of the two questions below:
1. Can a macro be triggered to run related to the above actions before a person can exit out of the chart and onto the spreadsheet it is on?
2. Or, is there something that can trigger a macro once a person does exit out of the chart and onto the spreadsheet it is on?
Including the macro here might be helpful in forming a solution. This macro needs to run so that the series can pull the max-Y value the chart has automatically determined, and therefore, allow it to be properly graphed on the chart. As you can see, it has to happen after the fact.
Thoroughly stumped here. Any help will be greatly appreciated!
Bookmarks