Evolução Patrimonial com planilha

by O Aportador Financeiro

HTML

<script type="text/javascript" src="https://www.gstatic.com/charts/loader.js"></script>
  <div id="chart_div"></div>

JavaScript

google.charts.load('current', {'packages': ['corechart', 'bar'], 'language': 'pt-br'});
      google.charts.setOnLoadCallback(drawStacked);

      function drawStacked() {
         var query = new google.visualization.Query('https://docs.google.com/spreadsheets/d/1-zaR3f8M08uALYs4AJ1lI5KED86oRZ8Q7PUSbqKhSdo/gviz/tq?range=Painel!B2:G8');
         query.send(handleQueryResponse);
      }

      function handleQueryResponse(response) {
         var data = response.getDataTable();
         var options = {        
             isStacked: true,
             legend: { position: 'top', maxLines: 3 },
             hAxis: {
                title: 'Período',
	  	textStyle: {                       
            	    bold: true            
          	},
          	viewWindow: {
                  min: [7, 30, 0],
                  max: [17, 30, 0]
            	}
             },
             vAxis: {
          	title: 'Valores em R$',
          	format: 'decimal',
          	textStyle: {
            	   bold: true            
          	}
             }
         };
         var chart = new google.visualization.ColumnChart(document.getElementById('chart_div'));
         chart.draw(data, options);
      }