Hello, I have been tasked with automating (as much as possible) the data gathering and updating process for our market reports.
The process is as follows:
Pull data (automatic)
The data is automatically fed into various charts, which then automatically adjust their scalings according to the new data (changing horizontal axis, etc)
These charts are then used in various powerpoints, which are expected to have been updated when the data was updated.
So far, I've been able to paste the charts so that the DATA itself is updated, but it does NOT adjust the axes like I do on the Excel sheets (or, in this case, like is done via macro).
Is there any way that I can make this happen, or are we forever cursed to have to copy and paste the charts in every single time we update the data?
Alternately, is there a workaround or easier method which you have used/discovered to make this happen?
Surely I'm not the only person who's ever wanted to do something like this.....
Bookmarks