The chart is dynamic by default, and the only thing that would suppress
automatic updating would be setting the calculation to manual. If the word
CALC appears in the lower-left corner of the status bar, just press F9 to
update all formulas and charts.

No need to code anything...
--
Kevin Backmann


"Joe" wrote:

Hi,

I would like to have a button, which when clicked refreshes the source data
in the excel chart object. I want to write a MACRO.

The data which is used for the chart/graph keeps changing hence want to
automate the same.

Thanks in advance!