I created a script in javascript to display yearly data in one graph. The years overlap each other for easy comparison. Here is an image with an example:
<https://lh6.googleusercontent.com/-lV00xWZ4yic/U8GDkBeIxvI/AAAAAAAACsk/c8jxdvICWOM/s1600/graph.png> Now I would like to use the same data set in a Google Spreadsheet and create a graph with the built-in graphs, but I can't get it to work. Here is an example of the data set: I've tried pivot tables, but then I can't get it formatted correctly. I've tried using queries to generate a new table, but none is compatible with the graphs to display multiple sets of yearly data in one graph. 2014-061132014-051192014-041112014-031212014-021172014-011162013-12136 2013-111062013-101292013-091082013-081112013-07852013-061012013-051192013-04 1042013-031202013-021192013-0166 Can someone please share their thoughts on this? Thanks in advance. -- You received this message because you are subscribed to the Google Groups "Google Spreadsheets API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
