title: Can I Create a Single HighCharts Graph from Multiple Data Sources (Multiple GoogleSheets in this case)
body: <p>I’m trying to use data from multiple GoogleSheets to produce a single HighChart graph.
  I’d like to do this without moving all the data into one area of a single spreadsheet, particularly as I want to use the drilldown option which would make it difficult to collect all the data together.
  I thought I could pass the columns as an array and then reference the array in the data property of my chart, but I’m struggling to do that with even one column from one sheet.</p>
  
  <p>I have searched for answers online, but I have not found anything relating to highcharts getting data from multiple sources.
  Previous Research:
  Using GoogleSheets Data as an array before creating the chart: (Removed Link) - The problem is that I could only use one GoogleSheets reference here as the chart object sits inside the data object.</p>
  
  <p>API documentation - (Removed Link) – tells me I can access the columns but that’s not the part I’m having problems with</p>
  
  <p>Querying the Chart: (Removed Link) - I have actually considered making hidden charts, then interrogating the data and making new charts from those, but that seems like a very long way round and I’m still not sure I could grab all the data I need.</p>
  
  <p>Using two GoogleSheets for separate charts on the same page: (Removed Link) I have done this.</p>
  
  <p>Please could you help me to understand how I can access the properties and methods of this object outside of the object itself?</p>
  
  <p>Thank you.</p>
  
  <p>My Code:</p>
  
  <pre><code>        //Function to produce a data array ***Not Working - Cannot extract array from object method***
      function getData(){
  
      Highcharts.data({
          googleSpreadsheetKey: '12x66_QEkTKg_UzvpHEygdTmfnu7oH81pSQYn78Hxt80',
          googleSpreadsheetWorksheet: 4,
          startColumn: 16,
          endColumn: 22,
          startRow: 63,
          endRow: 76,
  
          parsed: function (columns) {
              var dataTest2 = [];
              var columnLength = columns[1].length;
              for (i = 0; i &lt; columnLength; i = i + 1) { 
                  dataTest2.push(columns[1][i]);
  
              }
  
              alert(dataTest2); //This works here, but not if I move it outside of the method, even if I return it.
              var testReturn = this.googleSpreadsheetKey; //trying to return any property using "this" - I've also tried this.googleSpreadsheetKey.value but still undefined
              return testReturn; //returns "Undefined" 
          }
  
      });
  
  
      }
  </code></pre>