As far as I know there is no automatic way to get Excel to update a
chart on a webpage. You could record a macro that does just that and
have the macro run whenever you update the data (or better yet when
you save the workbook) but any solution you come up with will require
some amount of VBA programming.
On Mon, 21 Apr 2008 07:58:04 -0700, Signguy
wrote:

I want to create a chart, put it up on a webpage and when I update the data I
want it to update the chart and update the chart on the webpage.

I've used the "Save as web page" feature but this only creates a static gif
and not a dynamic link. Anyone got any tips? Bueller? Bueller?