Set Series values to a cell range

Set Series values to a cell range

Posted by: GEPHILLIPS on 8 April 2019, 7:05 am EST

• 

  GEPHILLIPS

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 8 April 2019, 7:05 am EST

  I can set values in a series one value at a time.

  If these values are already in my Spread control, how can I set the series to the cell range?

• 

  manish.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 9 April 2019, 10:02 pm EST

  Hi,
  
  In case of Creating Chart, please refer to the following documentation which shows how to use the CellRange to create Spread Chart.
  
  http://help.grapecity.com/spread/SpreadNet12/ASP2/webframe.html#spweb-chartcode.html

  Further, if you bind SpreadControl with DataTable, please refer to the following documentation:
  
  http://help.grapecity.com/spread/SpreadNet12/ASP2/webframe.html#spweb-chartdatabound.html

  Please let us know how the Spread Control is showing the values that you would like to bind to the series.
  
  Also, please share which Series you would like to display.

  Regards,
  
  Manish Gupta

• 

  GEPHILLIPS

  • Post Options:
  • Link
    Copy

  Posted 10 April 2019, 12:48 am EST

  I have a template spreadsheet that already has a chart in it.

  But I do need to update the range it uses at run time.

• 

  manish.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 12 April 2019, 4:46 am EST

  Hi,
  
  We are investigating on this. We will update you shortly.

  Regards,
  
  Manish Gupta

• 

  manish.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 14 April 2019, 10:49 pm EST

  Hi,
  
  We are sorry for the inconvenience.
  
  With the current release, the Chart data source/range can’t be changed/updated. For this, we have forwarded this enhancement request to the concerned team for further investigation with internal tracking id 271600. We will let you know as we get an update on this.

  Regards,
  
  Manish Gupta