How can I update the charts' soure data programmatically?
- Thread starter meninnet
- Start date
- Joined
- Mar 21, 2011
- Messages
- 1,960
- Reaction score
- 0
- Points
- 36
- Excel Version(s)
- O365
You need to apply the SetSourceData method of the chart.
Is there a way to do find and replace in the 'Select Data' dialogue box to make it quicker and easier to specify a different source sheet for a chart's data. For example, if I have 2 sheets with identical formats (created by copying sheet 1 to sheet 2), I would like to be able to quickly change the source of charts (on the different sheet, 3) to look at sheet 2 instead of sheet 1, without having to re-select the data or manually edit the path information in the dialogue box.
Are there any such short cuts. I am not familiar with VBA but will learn if necessary because with over 100 charts looking at sheet 1 there has to be an easier way than to manually edit each chart to look at sheet 2 for its source data.
Are there any such short cuts. I am not familiar with VBA but will learn if necessary because with over 100 charts looking at sheet 1 there has to be an easier way than to manually edit each chart to look at sheet 2 for its source data.