Chart series using range name

Chart series using range name

Posted by: ic-s on 11 December 2017, 12:02 am EST

• 

  ic-s

  • Post Options:
  • Link
    Copy

  Posted 11 December 2017, 12:02 am EST

  Is it possible to use defined range names in chart series?

  I can’t seem to do this.

  Such a function provides great flexibility with charts in Excel (which is not Excels strength).

  Regards

  Andrew

• 

  deepak.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 11 December 2017, 11:27 am EST

  Hello,

  You can use the range name for chart data. Please have a look at the code below:

  
   <script type="text/javascript">
          var chart_columnClustered, sheet;
          var spread;
          window.onload = function () {
              spread = new GC.Spread.Sheets.Workbook(document.getElementById("spreadSheet"), { sheetCount: 1 });
            
              sheet = spread.getActiveSheet();
              sheet.suspendPaint();
  
              //prepare data for chart
              sheet.setValue(0, 1, "Q1");
              sheet.setValue(0, 2, "Q2");
              sheet.setValue(0, 3, "Q3");
              sheet.setValue(1, 0, "Mobile Phones");
              sheet.setValue(2, 0, "Laptops");
              sheet.setValue(3, 0, "Tablets");
              sheet.addCustomName("customName3", "=$A$1:$D$4", 0, 0);
              for (var r = 1; r <= 3; r++) {
                  for (var c = 1; c <= 3; c++) {
                      sheet.setValue(r, c, parseInt(Math.random() * 100));
                  }
              }
            // var cname = sheet.getCustomName("customName3");
              //add columnClustered chart
              chart_columnClustered = sheet.charts.add('chart_columnClustered', GC.Spread.Sheets.Charts.ChartType.columnClustered, 250, 20, 600, 400, "customName3");         
              sheet.resumePaint();
          }
      </script>
  
  

  I hope it helps.

  Thanks,
  
  Deepak Sharma