Home > IT Answers > Microsoft Windows > automatic publish of charts to web
Gerrib
150 pts.
 automatic publish of charts to web
Excel Charts, Intranet, Microsoft Excel
On worksheet (5) I have graphs based on the 4 previous sheets. I publish this final sheet as a webpage to the intranet but wanted to find a way for the republishing to be automatic. The graphs are updated once the data is changed but I want the user to use the intranet rather than the spreadsheet.

Software/Hardware used:
ASKED: July 8, 2008  11:49 AM
UPDATED: September 28, 2008  6:48 AM
RELATED QUESTIONS
Answer Wiki:
I've done this exact thing several times before. Setup a macro which calls the data to be updated, then export the last worksheet to a new spreadsheet. Have the macro save the new worksheet to the webserver.
Last Wiki Answer Submitted:  September 28, 2008  6:48 am  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _