Brandon, this looks like your data is out of order, since the line chart just connects points between adjacent rows of your data. But I don't see any problem in the data you posted.
Regardless, you should be able to avoid this problem by sorting the data. One way you can do that is to call getSortedRows() on your data table, which will result in an array of row indices, and then use that to create a DataView and provide that array of rows to the setRows() method. You can find documentation about these methods in the API reference: https://google-developers.appspot.com/chart/interactive/docs/reference On Tue, Jun 2, 2015 at 7:58 AM, Brandon Matthews <[email protected] > wrote: > here's a longer version.. > > {"cols":[{"label":"date","type":"date"},{"label":"Open Short > Pct","type":"number"},{"label":"Total Short > Pct","type":"number"}],"rows":[{"c":[{"v":"Date(2014,11,5)"},{"v":34.18},{"v":25.19}]},{"c":[{"v":"Date(2014,11,15)"},{"v":52.56},{"v":37.97}]},{"c":[{"v":"Date(2014,11,16)"},{"v":49.17},{"v":30.75}]},{"c":[{"v":"Date(2014,11,17)"},{"v":62.29},{"v":49.55}]},{"c":[{"v":"Date(2014,11,18)"},{"v":67.23},{"v":54.03}]},{"c":[{"v":"Date(2014,11,19)"},{"v":55.91},{"v":38.7}]},{"c":[{"v":"Date(2014,11,24)"},{"v":42.81},{"v":34.14}]},{"c":[{"v":"Date(2014,11,26)"},{"v":49.93},{"v":36.04}]},{"c":[{"v":"Date(2014,11,29)"},{"v":39.06},{"v":30.65}]},{"c":[{"v":"Date(2014,11,30)"},{"v":49.16},{"v":40.6}]},{"c":[{"v":"Date(2014,11,31)"},{"v":43.1},{"v":29.89}]},{"c":[{"v":"Date(2015,0,2)"},{"v":59.08},{"v":36.95}]},{"c":[{"v":"Date(2015,0,5)"},{"v":51.65},{"v":39.42}]},{"c":[{"v":"Date(2015,0,6)"},{"v":54.24},{"v":38.51}]},{"c":[{"v":"Date(2015,0,7)"},{"v":39.6},{"v":28.08}]},{"c":[{"v":"Date(2015,0,8)"},{"v":43.18},{"v":32.66}]},{"c":[{"v":"Date(2015,0,9)"},{"v":47.56},{"v":34.51}]},{"c":[{"v":"Date(2015,0,12)"},{"v":44.94},{"v":33.72}]},{"c":[{"v":"Date(2015,0,13)"},{"v":49.61},{"v":36.92}]},{"c":[{"v":"Date(2015,0,14)"},{"v":54.37},{"v":39.46}]},{"c":[{"v":"Date(2015,0,15)"},{"v":51.86},{"v":39.61}]},{"c":[{"v":"Date(2015,0,16)"},{"v":54.68},{"v":28.8}]},{"c":[{"v":"Date(2015,0,20)"},{"v":43.23},{"v":34.97}]},{"c":[{"v":"Date(2015,0,21)"},{"v":50.03},{"v":39.48}]},{"c":[{"v":"Date(2015,0,22)"},{"v":52.77},{"v":36.76}]},{"c":[{"v":"Date(2015,0,23)"},{"v":54.36},{"v":38.3}]},{"c":[{"v":"Date(2015,0,26)"},{"v":40.94},{"v":48.96}]},{"c":[{"v":"Date(2015,0,27)"},{"v":60.84},{"v":46.41}]},{"c":[{"v":"Date(2015,0,28)"},{"v":64.72},{"v":44}]},{"c":[{"v":"Date(2015,0,30)"},{"v":49.43},{"v":38.38}]},{"c":[{"v":"Date(2015,1,2)"},{"v":62.59},{"v":43.19}]},{"c":[{"v":"Date(2015,1,3)"},{"v":65.01},{"v":48.24}]},{"c":[{"v":"Date(2015,1,4)"},{"v":71.46},{"v":58.82}]},{"c":[{"v":"Date(2015,1,5)"},{"v":55.22},{"v":41.61}]},{"c":[{"v":"Date(2015,1,6)"},{"v":53.33},{"v":39.68}]},{"c":[{"v":"Date(2015,1,9)"},{"v":38.51},{"v":29.62}]},{"c":[{"v":"Date(2015,1,10)"},{"v":53.39},{"v":35.96}]},{"c":[{"v":"Date(2015,1,11)"},{"v":53.39},{"v":37.41}]},{"c":[{"v":"Date(2015,1,12)"},{"v":45.87},{"v":34.83}]},{"c":[{"v":"Date(2015,1,13)"},{"v":44.4},{"v":35.86}]},{"c":[{"v":"Date(2015,1,17)"},{"v":44.32},{"v":33.85}]},{"c":[{"v":"Date(2015,1,18)"},{"v":41.47},{"v":34.48}]},{"c":[{"v":"Date(2015,1,19)"},{"v":40.87},{"v":34.76}]},{"c":[{"v":"Date(2015,1,20)"},{"v":55.99},{"v":41.44}]},{"c":[{"v":"Date(2015,1,23)"},{"v":46.03},{"v":37.97}]},{"c":[{"v":"Date(2015,1,24)"},{"v":42.47},{"v":38.7}]},{"c":[{"v":"Date(2015,1,25)"},{"v":55.9},{"v":45.25}]},{"c":[{"v":"Date(2015,1,26)"},{"v":61.01},{"v":51.83}]},{"c":[{"v":"Date(2015,1,27)"},{"v":54.38},{"v":46.89}]},{"c":[{"v":"Date(2015,2,2)"},{"v":56.09},{"v":44.51}]},{"c":[{"v":"Date(2015,2,3)"},{"v":58.33},{"v":45.03}]},{"c":[{"v":"Date(2015,2,4)"},{"v":53.06},{"v":47.17}]},{"c":[{"v":"Date(2015,2,5)"},{"v":45.69},{"v":35.54}]},{"c":[{"v":"Date(2015,2,6)"},{"v":53.39},{"v":47.77}]},{"c":[{"v":"Date(2015,2,9)"},{"v":38.26},{"v":29.33}]},{"c":[{"v":"Date(2015,2,10)"},{"v":55.17},{"v":41.99}]},{"c":[{"v":"Date(2015,2,11)"},{"v":56.34},{"v":38.58}]},{"c":[{"v":"Date(2015,2,12)"},{"v":53.29},{"v":44.01}]},{"c":[{"v":"Date(2015,2,13)"},{"v":61.63},{"v":44.83}]},{"c":[{"v":"Date(2015,2,16)"},{"v":46.96},{"v":32.53}]},{"c":[{"v":"Date(2015,2,17)"},{"v":52.02},{"v":41.26}]},{"c":[{"v":"Date(2015,2,18)"},{"v":47.64},{"v":36.22}]},{"c":[{"v":"Date(2015,2,19)"},{"v":47.71},{"v":36.72}]},{"c":[{"v":"Date(2015,2,20)"},{"v":52.61},{"v":38.42}]},{"c":[{"v":"Date(2015,2,23)"},{"v":46.13},{"v":40.38}]},{"c":[{"v":"Date(2015,2,24)"},{"v":58.74},{"v":46.17}]},{"c":[{"v":"Date(2015,2,25)"},{"v":55.54},{"v":48.48}]},{"c":[{"v":"Date(2015,2,26)"},{"v":59.15},{"v":47.51}]},{"c":[{"v":"Date(2015,2,27)"},{"v":54.27},{"v":47.91}]},{"c":[{"v":"Date(2015,2,30)"},{"v":47.58},{"v":35.55}]},{"c":[{"v":"Date(2015,2,31)"},{"v":40.13},{"v":31.3}]},{"c":[{"v":"Date(2015,3,1)"},{"v":44.61},{"v":37.7}]},{"c":[{"v":"Date(2015,3,2)"},{"v":41.27},{"v":33.63}]},{"c":[{"v":"Date(2015,3,6)"},{"v":58.4},{"v":45.99}]},{"c":[{"v":"Date(2015,3,7)"},{"v":62.34},{"v":52.78}]},{"c":[{"v":"Date(2015,3,8)"},{"v":73.18},{"v":61.87}]},{"c":[{"v":"Date(2015,3,9)"},{"v":63.96},{"v":51.7}]},{"c":[{"v":"Date(2015,3,10)"},{"v":58.84},{"v":44.84}]},{"c":[{"v":"Date(2015,3,13)"},{"v":48.89},{"v":42.17}]},{"c":[{"v":"Date(2015,3,14)"},{"v":43.24},{"v":36.05}]},{"c":[{"v":"Date(2015,3,15)"},{"v":59.38},{"v":52.64}]},{"c":[{"v":"Date(2015,3,16)"},{"v":38.76},{"v":25.06}]},{"c":[{"v":"Date(2015,3,17)"},{"v":51.66},{"v":37.54}]},{"c":[{"v":"Date(2015,3,20)"},{"v":46.23},{"v":33.41}]},{"c":[{"v":"Date(2015,3,21)"},{"v":47.5},{"v":34.63}]},{"c":[{"v":"Date(2015,3,22)"},{"v":51.05},{"v":35.78}]},{"c":[{"v":"Date(2015,3,23)"},{"v":56.48},{"v":45.85}]},{"c":[{"v":"Date(2015,3,24)"},{"v":54.27},{"v":36.13}]},{"c":[{"v":"Date(2015,3,27)"},{"v":64.41},{"v":62.01}]},{"c":[{"v":"Date(2015,3,28)"},{"v":46.82},{"v":29.2}]},{"c":[{"v":"Date(2015,3,29)"},{"v":54.44},{"v":34.81}]},{"c":[{"v":"Date(2015,3,30)"},{"v":55.15},{"v":40.59}]},{"c":[{"v":"Date(2015,4,1)"},{"v":55.29},{"v":40.26}]},{"c":[{"v":"Date(2015,4,4)"},{"v":64.32},{"v":47.8}]},{"c":[{"v":"Date(2015,4,5)"},{"v":47.88},{"v":36.97}]},{"c":[{"v":"Date(2015,4,6)"},{"v":53.1},{"v":39.41}]},{"c":[{"v":"Date(2015,4,7)"},{"v":55.25},{"v":42.52}]},{"c":[{"v":"Date(2015,4,8)"},{"v":56.45},{"v":41.06}]},{"c":[{"v":"Date(2015,4,11)"},{"v":46.37},{"v":30.22}]},{"c":[{"v":"Date(2015,4,12)"},{"v":58.53},{"v":31.91}]},{"c":[{"v":"Date(2015,4,13)"},{"v":56.82},{"v":32.81}]},{"c":[{"v":"Date(2015,4,14)"},{"v":44.77},{"v":33.49}]},{"c":[{"v":"Date(2015,4,15)"},{"v":49.67},{"v":29.77}]},{"c":[{"v":"Date(2015,4,18)"},{"v":65.63},{"v":38.46}]},{"c":[{"v":"Date(2015,4,19)"},{"v":55.56},{"v":30.12}]},{"c":[{"v":"Date(2015,4,20)"},{"v":58.35},{"v":35.99}]},{"c":[{"v":"Date(2015,4,21)"},{"v":44.31},{"v":29.87}]},{"c":[{"v":"Date(2015,4,22)"},{"v":41.93},{"v":34.03}]},{"c":[{"v":"Date(2015,4,26)"},{"v":47.8},{"v":32.14}]},{"c":[{"v":"Date(2015,4,27)"},{"v":44.62},{"v":24.99}]},{"c":[{"v":"Date(2015,4,28)"},{"v":52.83},{"v":29.35}]},{"c":[{"v":"Date(2015,4,29)"},{"v":48.95},{"v":38.2}]},{"c":[{"v":"Date(2015,5,1)"},{"v":49.83},{"v":29.1}]}]} > > > > > > > On Tuesday, June 2, 2015 at 7:19:55 AM UTC-4, Brandon Matthews wrote: > >> Any suggestions on where I might find the problem?I'm hoping this is an >> old issue I cant find because it's so deeply buried by now...:) >> >> >> <https://lh3.googleusercontent.com/-3Qjk4nBNSo8/VW2RH_WthdI/AAAAAAAABGE/mRhU-EgrirY/s1600/y.PNG> >> >> -- > You received this message because you are subscribed to the Google Groups > "Google Visualization API" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to > [email protected]. > Visit this group at > http://groups.google.com/group/google-visualization-api. > For more options, visit https://groups.google.com/d/optout. > -- Daniel LaLiberte <https://plus.google.com/100631381223468223275?prsrc=2> - 978-394-1058 [email protected] <[email protected]> 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 Visualization API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/google-visualization-api. For more options, visit https://groups.google.com/d/optout.
