Thread: Export chart from workbook to html

Hi everyone, my first post and I am having a problem trying to find the answer to this. I have no experience of vba/macros.

I am running excel 2007 and have a workbook with a table of payments and a line-chart that displays the data from that table.

What I need is to link that chart to a html webpage so each time the chart in workbook is updated it then updates the chart on the html.

So far I found a great little vba example on http://pubs.logicalexpressions.com/P...cle.asp?ID=436 and am attaching the example file. It works brilliantly but I do not need table displaying, I would like the chart dispaying

Any addendum on that process would be a button or onevent to run the macro once the file is saved or that button is pressed thus making it a lot quicker to open the workbook, add data thus updating the html chart.

I hope someone can help as my mum's new office is opening this week and I am handling the spreadsheets. Thanks in advance

Do you really need code.

Just save the workbook as an html page with auto republish enabled.
The when the data updates a new html with chart will be created.