How to display hidden data on a chart?

How to display hidden data on a chart?

Posted by: asarkar on 21 November 2018, 12:38 pm EST

• 

  asarkar

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 21 November 2018, 12:38 pm EST - Updated 3 October 2022, 11:03 am EST

  The chart data and the chart are in the same sheet. When I hide a column that contains a series for the chart, that series disappears from the chart.

  Is there a way to still display the hidden series on the chart without having to create another sheet for the hidden data?

  

  1079×880 77.6 KB

  

  1018×882 60.9 KB

• 

  reeva.dhingra

  

  • Post Options:
  • Link
    Copy

  Posted 22 November 2018, 12:37 am EST

  Hello,

  You can set the column’s width to zero instead of hiding it as given in code below:-

  sheet.setColumnWidth(1, 0, GC.Spread.Sheets.SheetArea.viewport);
  

  Hope it helps.

  Thanks,
  
  Reeva