Hi, You can do one of two: 1. use the Query object. as can be seen here: http://code.google.com/apis/ajax/playground/?type=visualization#using_the_query_language
2. use an external page and ajax to render a datatable. as can seen here: http://code.google.com/apis/chart/interactive/docs/php_example.html Good luck, On Sun, Dec 25, 2011 at 4:00 PM, Shane <[email protected]> wrote: > Dear All, > > I'm trying to use the Google Analytics motion charts to demonstrate > something. I have all of my data in excel spreadsheets. I see in the > example script (http://code.google.com/apis/chart/interactive/docs/ > gallery/motionchart.html) that the standard way is to enter in the > data directly into the script. For a ton of data, this is obviously > quite a lot of grunt work. Of course, I'm really excited about the > potential of my motion chart - it's quite an extraordinary tool. > > Is there any way I can have the script reference and draw information > directly from a CSV or other file? If so, how would I structure that > file? > > If this isn't possible, is there a relatively simple way to automate > the process of taking my data from the spreadsheet to the script > format necessary to run the motion chart? I must admit that I have > almost no programming experience, though I am pretty savvy with this > stuff and a quick learner. > > Thanks in advance for your help! > > Best regards, > Shane > > -- > You received this message because you are subscribed to the Google Groups > "Google Visualization 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-visualization-api?hl=en. > > -- You received this message because you are subscribed to the Google Groups "Google Visualization 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-visualization-api?hl=en.
