Google charts - Hide columns

by barbarina

HTML

<script src="https://www.google.com/jsapi?fake=.js"></script>
<body>
  <div id="chart_div" style="width: 900px; height: 500px;"></div>

  <!--button type="button" id="hideSales">Hide Sales</button>
  <button type="button" id="showSales">Show Sales</button>
  <button type="button" id="hideExpenses">Hide Expence</button>
  <button type="button" id="hide3">Hide 3</button-->
  
  <button type="button" id="hideNothing">Show all</button>
  <button type="button" id="soloSal">soloSal</button>
  <button type="button" id="soloExp">soloExp</button>
  <button type="button" id="solo3">solo3</button>

</body>

JavaScript

google.load("visualization", "1", {
    packages: ["corechart"]
  });
  google.setOnLoadCallback(drawChart);

var options;

  function drawChart() {
    var data = google.visualization.arrayToDataTable([
      ['Year', 'Sales', 'Expenses', 'terza','storico1s', 'storico2e','storico3'],
      ['2004', 1000, 400, 900,350, 500,780],
      ['2005', 1170, 460, 850,500, 500,520],
      ['2006', 660, 1120, 700,1000, 500,900],
      ['2007', 1030, 540, 1200,600, 500,1100]
    ]);
    options = {
      title: 'Company Performance',
      isStacked: true,
      series: {2:{type: 'area'}, 3:{type: 'area'}, 5:{type: 'area'}},
      
    vAxis: {minValue:0, maxValue:3000}
    };
    var chart = new google.visualization.ColumnChart(document.getElementById('chart_div'));

    chart.draw(data, options);

/*
    var hideSal = document.getElementById("hideSales");
    hideSal.onclick = function() { //levo blu e giallo 0 -2 
      view = new google.visualization.DataView(data);
      
      console.log('hideSal');
      var cols = view.getViewColumns();
      for(var c=0; c<cols.length; c++){
      console.log(cols[c]);
      	//var p = cols[c].getColumnProperty('')
      }
      
      view.hideColumns([1,3]);
      //view.setColumns([2,4]);
      options.series[1]={type:'area'};
      chart.draw(view, options);
      
      console.log('hided');
      cols = view.getViewColumns();
      for(var c=0; c<cols.length; c++){
      console.log(cols[c]);
      	//var p = cols[c].getColumnProperty('')
      }
      
    }
    
     var showSal = document.getElementById("showSales");
    showSal.onclick = function() { //levo blu e giallo 0 -2 
      view = new google.visualization.DataView(data);
      
      console.log('showSal');
      var cols = view.getViewColumns();
      for(var c=0; c<cols.length; c++){
      console.log(cols[c]);
      	//var p = cols[c].getColumnProperty('')
      }
      
      //view.setColumns([1,3]);
      //view.setColumns([2,4]);
     ...