jimmy2times
Board Regular
- Joined
- Aug 8, 2014
- Messages
- 69
Hello everyone,
I have 10 charts embedded in the same worksheet. I need to extend the horizontal axis of the chart each time the graph is updated. So the data source would extend from M23 to N23 this week and next week from N23 to O23 and so on.
How can I write a macro so all the charts will automatically update by plotting the next column in the data source?
I would be grateful for any help because at the moment I am doing this manually.
Many thnaks
I have 10 charts embedded in the same worksheet. I need to extend the horizontal axis of the chart each time the graph is updated. So the data source would extend from M23 to N23 this week and next week from N23 to O23 and so on.
How can I write a macro so all the charts will automatically update by plotting the next column in the data source?
I would be grateful for any help because at the moment I am doing this manually.
Many thnaks