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.
