Hey:
I have many charts that I am continuously updating. As I add the next months data I must then manually update my charts to show the current data. Is there a way either through functions or through a macro that I can have the chart automatically pick the most recent 12 month period?
I have many charts that I am continuously updating. As I add the next months data I must then manually update my charts to show the current data. Is there a way either through functions or through a macro that I can have the chart automatically pick the most recent 12 month period?