Dan, That does help indeed! Thank you. So I'm going to try the chart range filter, but I'm looking for an example that accesses spreadsheet data and outputs a graph. I thought this might help, but it doesn't seem to be applicable in my situation: http://code.google.com/apis/ajax/playground/?type=visualization#data_source_request
Thanks for any additional advice, S On Monday, November 5, 2012 9:28:06 PM UTC-8, Daniel LaLiberte wrote: > > Hi Shad, > > You might want to investigate using AppsScripts with your spreadsheet in > order to trigger generating a new chart when your spreadsheet is updated. > But I believe the chart you have displayed within your spreadsheet will > already be updated automatically. > > Regarding the question of how to show the data for all the months of every > year, you have too much data to show within the space limitations, at least > with that type of chart, as you point out, so you would need either an > annotated time line chart (like the finance charts) or add a chart range > filter to another chart, such as the column chart or combo chart, but this > would have to be done in a separate web page. See > http://code.google.com/apis/ajax/playground/?type=visualization#chartrangefilter_controlfor > an example. > > By the way, there are some other ways to see all the data in the chart > embedded in the spreadsheet. The annotated time line chart is available, > but your data would need to be restructured to accomodate it's requirement. > You might want to consider that the bar chart can use stacked mode, or > similar, the area chart can be stepped. Also, the scatter chart works, but > none of these options show the data very well, so you are probably better > off using the chart range filter. > > Hope that helps. > dan > > > On Sat, Nov 3, 2012 at 6:42 PM, Shad Keene <[email protected]<javascript:> > > wrote: > >> I have a spreadsheet here: >> https://docs.google.com/spreadsheet/ccc?key=0ArG5bgzT22kKdFVOdnJ6X0lOaW5NWE16YzV4QTZEWHc#gid=0 >> >> It has a lot of data and is updated manually every month or so. What I'd >> like is a chart that is updated automatically every time the spreadsheet is >> updated. Also, I'm having a hard time creating a chart that shows all the >> months for each year. Is there a way to do this via a chart similar to the >> google finance charts? I've attempted a chart on the spreadsheet as you >> can see, but it only shows a few of the months and the others aren't shown. >> >> Thanks for any help, >> >> S >> >> -- >> You received this message because you are subscribed to the Google Groups >> "Google Chart API" group. >> To view this discussion on the web visit >> https://groups.google.com/d/msg/google-chart-api/-/hbB0uckHycYJ. >> To post to this group, send email to >> [email protected]<javascript:> >> . >> To unsubscribe from this group, send email to >> [email protected] <javascript:>. >> For more options, visit this group at >> http://groups.google.com/group/google-chart-api?hl=en. >> > > > > -- > Daniel LaLiberte <https://plus.google.com/100631381223468223275?prsrc=2> > - 978-394-1058 > [email protected] <javascript:> 562D 5CC, Cambridge MA > [email protected] <javascript:> 9 Juniper Ridge Road, Acton MA > > -- You received this message because you are subscribed to the Google Groups "Google Chart API" group. To view this discussion on the web visit https://groups.google.com/d/msg/google-chart-api/-/uyBqFPH0Uk4J. 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.
