Update Excel charts in real time with Google Docs

For many who do financial work or are writing financial blog sites, and often on business trip friends, it is not easy to update the content of the blog (or unit Web site Collaborative Office System) on the outside is not easily: the lack of professional software greatly restricts their work. If the chart can be synchronized automatically updates in real time, how good! At this time thought of the network is crazy popular online office system, after some pondering found that "Google Docs" can fully implement this function.

Actually using Google Docs to implement this feature is simple:

Step one: Open and log in to the Google document () in IE browser, and open a blank spreadsheet in the Google Document action interface that appears in the "New → spreadsheet" command.

Step two: In a blank spreadsheet, enter the relevant data to generate the chart, if the relevant data has been saved in the local computer in the Excel file, then you can open the Excel file and then select the relevant data, in the Google Document editing window, press "CTRL + V" to paste it into the window.

Step three: Select the related cells in the editing window of the Google document. Click on the "Insert Gadget" button in the upper-right corner of the screen and select the type of tool you want in the Add Gadgets dialog box, which is naturally the relevant chart in the chart class, as I chose the classic "histogram". Click the "Add to Spreadsheet" button below it.

Step Fourth: In the subsequent "Modify" dialog box to confirm the data range, and set whether to use the 3D stereo effects and other options, and finally press the "Apply and Close" button to complete the insert work of the chart.

Fifth step: Is it cool to look at the 3D chart you just inserted? It's also easy to publish it to a blog or website. We do not need a screenshot or upload, just click the Drop-down triangle in the upper right corner of the chart box to execute the "Publish Gadget" command in the Drop-down menu that appears, and a "Publish Gadget" dialog box will pop up to select and copy the HTML code. Then paste it into a blog or Web site, forum edit page on it.

In the future, as long as we update the relevant values in the table in Google Docs, the chart gadget will be automatically updated in real time.