Hi Dave, You can add a query to filter out the empty string values the data source is returning. Just add 'query': 'SELECT * WHERE D<>""' as an option. Demo here: http://jsfiddle.net/walkingeyerobot/KGfGU/
-Mitch On Sat, Mar 9, 2013 at 11:00 AM, Dave Lalande <[email protected]> wrote: > I am having two minor issues with getting these charts to draw as desired. > > I can't seem to get both charts to draw on the same page and the table > chart has an extra row. I can get one or the other. > > I want these charts to file in as the data comes in each month. > > My code: > > <script type="text/javascript" src="http://www.google.com/jsapi > "></script> > <script type="text/javascript"> > google.load('visualization', '1.0'); > function drawVisualization() { > google.visualization.drawChart({ > "containerId": "visualization_div", > "dataSourceUrl": " > https://spreadsheets.google.com/a/google.com/tq?range=D1:F14&key=0AhCv9Xu_eRnSdFNhSzNQUFd3b1ZfRHgtQURINFpzeGc&gid=1 > ", > "refreshInterval": 5, > "chartType": "ComboChart", > "options": { > "pointSize": 5, > "height": 300, > "width": 600, > "titlePosition": "out", > "title": "Advance Directives", > "titleTextStyle": {color: "black", fontName: "Arial", fontSize: "20"} > } > }); > } > function drawVisualization1() { > google.visualization.drawChart({ > "containerId": "table_div", > "dataSourceUrl": " > https://spreadsheets.google.com/a/google.com/tq?range=D1:F14&key=0AhCv9Xu_eRnSdFNhSzNQUFd3b1ZfRHgtQURINFpzeGc&gid=1 > ", > "refreshInterval": 5, > "chartType": "Table", > "options": { > "height": 300, > "width": 600, > "title": "The Data", > "alternatingRowStyle": true, > "showRowNumber" : false > } > }); > } > google.setOnLoadCallback(drawVisualization); > </script> > > Thanks for any help you can offer. I'm sure it's something easy I am > overlooking. > > -- > 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?hl=en. > For more options, visit https://groups.google.com/groups/opt_out. > > > -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
