Thanks Yuval. I already included those same API links in my
post over on the google spreadsheets group. I figured most people here would have already seen them, but thanks for including. I was really hoping there was some way to build the chart using google spreadsheets, but I do not believe transition animation is possible from within spreadsheets app. While charts in google spreadsheets are easy to build, there is no way to save them as templates and they must be rebuilt and customized from scratch. Where as with coding, I suppose it will take a bit more time to build the first chart, but then they could hopefully be replicated more easily with a just query url from the spreadsheet.