rafaelspeixoto
Board Regular
- Joined
- May 14, 2007
- Messages
- 85
Hello everyboby.
I need a little help once again with macro writing.
Every month I have to build a powerpoint presentation with charts containing data of the whole year up to last month's data. In other words, I have to update the source data of each chart (adding one more column corresponding to the following month).
Is there a way for me to just choose the last month (maybe from a cell with validation) and make each chart source data change based on that? The only way I have figured out would be to write one chart range for each possible month for each chart, but it is obviously not very efficient...
Thanks a lot in advance
I need a little help once again with macro writing.
Every month I have to build a powerpoint presentation with charts containing data of the whole year up to last month's data. In other words, I have to update the source data of each chart (adding one more column corresponding to the following month).
Is there a way for me to just choose the last month (maybe from a cell with validation) and make each chart source data change based on that? The only way I have figured out would be to write one chart range for each possible month for each chart, but it is obviously not very efficient...
Thanks a lot in advance