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]> 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]. > 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. > -- Daniel LaLiberte <https://plus.google.com/100631381223468223275?prsrc=2> - 978-394-1058 [email protected] <[email protected]> 562D 5CC, Cambridge MA [email protected] <[email protected]> 9 Juniper Ridge Road, Acton MA -- 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.
