This may help: http://code.google.com/intl/bo/apis/visualization/documentation/spreadsheets.html
--edge On Wed, Jan 26, 2011 at 6:55 AM, Elijah Gregory <[email protected]> wrote: > I'm not familiar enough with Google Docs to say whether it's possible. > My instinct is to say no, Docs does not emulate Excel in that way, > though there may be another Google Code offering that could help. As > for Excel, 2007 has data export (i.e. importing from), you can choose > a variety of file types and data formats. The problem is that none of > those formats are "Google Chart URL". Most likely you would have to > code a script (e.g. in Perl) that would read the file Excel had > exported, take the relevant data in to an array, and then output that > array in to a well-formed Charts URL. > > I just looked in to Charts briefly, and "Tools-->Scripts" looks like > your best bet for getting the functionality from Google Docs which you > seek. > > Good luck! > > ~Elijah > > On Tue, Jan 25, 2011 at 6:57 AM, FinancialDataSeeker > <[email protected]> wrote: >> thanks for your reply. Im actually looking to copy data from google >> docs into a google chart. Basically, the only way i can see to add >> data to the google charts is manually and im wondering if there is >> some automated way of importing data from a spreadsheet, whether excel >> or google docs. >> >> Thanks >> >> On Jan 25, 6:40 am, Elijah Gregory <[email protected]> wrote: >>> Yes, it is possible, but this forum is for answering questions >>> regarding the charts API (hence [email protected]), >>> and your issue is about how to copy data from Google Docs to a URL on >>> your own website. Sorry. >>> >>> ~Elijah >>> >>> On Mon, Jan 24, 2011 at 3:54 PM, FinancialDataSeeker >>> >>> >>> >>> >>> >>> >>> >>> <[email protected]> wrote: >>> > Basically i want to set up a spreadsheet in my google account that has >>> > columns of data that are constantly updated. I want a chart that is >>> > embedded on my website to automatically update from new information >>> > that is added to the spreadsheet daily. Is it possible to have a chart >>> > be fed information automatically from a spreadsheet? >>> >>> > Thanks so much. >>> >>> > -- >>> > You received this message because you are subscribed to the Google Groups >>> > "Google Chart API" group. >>> > To post to this group, send email to [email protected]. >>> > To unsubscribe from this group, send email to >>> > [email protected]. >>> > For more options, visit this group >>> > athttp://groups.google.com/group/google-chart-api?hl=en. >> >> -- >> You received this message because you are subscribed to the Google Groups >> "Google Chart API" group. >> To post to this group, send email to [email protected]. >> To unsubscribe from this group, send email to >> [email protected]. >> For more options, visit this group at >> http://groups.google.com/group/google-chart-api?hl=en. >> >> > > -- > You received this message because you are subscribed to the Google Groups > "Google Chart API" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/google-chart-api?hl=en. > > -- You received this message because you are subscribed to the Google Groups "Google Chart API" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/google-chart-api?hl=en.
