Hi all,
I have a chart that I would like to change the source data of. The source data would be dependant on a set of values within a data validation field. Then when I click a "Refresh" button, the chart will be updated with a set of values depending on what is selected in the data validation.
I've thought about having the values in one set of cells and using a formula for these cells, derived from the data validation but this just simply isn't feasible. Is there some VB code that can change the source data of a particular chart?
Hope this explains my dilema, thanks for your help.
Cheers,
Benno
Bookmarks