Hi! I create a linechart from a google sheet with two lines and want to have two separate areas - one for each line, one on top and one underneath. Also, options for the chart do not work.
So my questions: can I split the chart in two different areas - a crosshair above both would be nice and how do I insert option (e.g. line colors) here is my code: <html> <head> <meta charset="UTF-8"> <meta http-equiv="content-type" content="text/html; charset=utf-8"> <title>COT Gold</title> <link rel="stylesheet" href="cot1.css"> <!-- One script tag loads all the required libraries! Do not specify any chart types in the autoload statement. --> <script type="text/javascript" src='https://www.gstatic.com/charts/loader.js'></script> <script type="text/javascript"> // Load the Visualization API and the corechart package. google.charts.load('current', {'packages':['corechart']}); // Set a callback to run when the Google Visualization API is loaded. google.charts.setOnLoadCallback(drawChart); function drawChart() { // Create data table 1. var queryString = encodeURIComponent(); var query = new google.visualization.Query( 'https://docs.google.com/spreadsheets/d/14KASFMnH2-Bgw-687Zuf7DjTk1aoYGuSSUr3fw7T8w4/edit#gid=0'); query.setQuery('select A, AB, B'); query.send(handleQueryResponse); } function handleQueryResponse(response) { if (response.isError()) { alert('Error in query: ' + response.getMessage() + ' ' + response.getDetailedMessage()); return; } var data = response.getDataTable(); // Instantiate and draw our chart, passing in some options. var chart = new google.visualization.LineChart(document.getElementById('chart1_div')). draw(data, {vAxes:[ {viewWindowMode:'explicit', viewWindow:{ max:-100000, min:-500000 }, }, ], series:[ {targetAxisIndex:1}, {targetAxisIndex:0} ], } ); } </script> </head> <body> <div id="chart1_div"></div> </body> </html> -- 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 google-visualization-api+unsubscr...@googlegroups.com. To post to this group, send email to google-visualization-api@googlegroups.com. Visit this group at https://groups.google.com/group/google-visualization-api. To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/8cbf3d0b-d90f-473c-968a-e44b404f3df7%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.