Blank data in line chart price series

Blank data in line chart price series

Posted by: ic-s on 16 April 2018, 10:27 pm EST

• 

  ic-s

  • Post Options:
  • Link
    Copy

  Posted 16 April 2018, 10:27 pm EST

  Is there a way of making line charts ignore blanks in a price series (as in using NA() in Excel charts, rather than reading the cell value as zero??

• 

  deepak.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 18 April 2018, 4:19 am EST

  Hello,

  This currently looks not possible. I have submitted it as an enhancement request to the development team. Request id for this issue is 257221.

  Thanks,
  
  Deepak Sharma

• 

  ic-s

  • Post Options:
  • Link
    Copy

  Posted 18 April 2018, 6:58 pm EST

  Thanks Deepak,

  While they are there could they look at being able to use Range Names in the chart series?

  And X Axis labels for a column chart when there are negative values - the labels need to be lowered rather than stay near the axis.

  Andrew Woods

• 

  deepak.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 20 April 2018, 7:04 am EST

  Hello,

  I have submitted it to the bug database as a feature request. It may get added to the future version of SpreadJS. The request id for this is : 257359

  Thanks,
  
  Deepak Sharma