I have a project where I calculate 5 values monthly for numerous account managers(AMs) in a master file. I maintain a Worksheet that has a rolling 12 month set of data for each value for each AM. I then add 2 Charts to the right of the 12 months of data. Monthly I copy data to individual files for each AM. Part of that process is to copy data from the master file table that shows the 5 values for 12 months. I do this by filtering the table to each specific AM and then copying and pasting the data. I would like to also copy the 2 Charts but I am struggling to make that happen (Yes, I could replicate code that created the Charts in the master file in the first place but hoping I can find a way to copy the already created Charts).
So my question is, when I have the master file filtered to the rows of data for a specific AM, is there a way to identify the 2 Charts that are also visible? Any help is much appreciated.
So my question is, when I have the master file filtered to the rows of data for a specific AM, is there a way to identify the 2 Charts that are also visible? Any help is much appreciated.