Charts based on multiple ranges

Charts based on multiple ranges

Posted by: hghanta on 10 April 2018, 2:07 pm EST

• 

  hghanta

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 10 April 2018, 2:07 pm EST

  Is it possible to have chart rendered based multiple ranges

  Eg. A1:C5, A7:C10

• 

  deepak.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 11 April 2018, 6:04 am EST

  Hello,

  You can have multiple chart series and set data for them. Please have a look at the documentation given below on how to set the series for a chart:

  http://help.grapecity.com/spread/SpreadSheets11/webframe.html#ConfiguringSeries.html

  Thanks,
  
  Deepak Sharma

• 

  hghanta

  • Post Options:
  • Link
    Copy

  Posted 13 April 2018, 10:26 am EST - Updated 3 October 2022, 11:19 am EST

  

  1139×389 15 KB

  I was able to skip Sony PS4 & Q3 altogether by splitting the data range i have into multiple ranges
  
  Is this possible in spread.Sheets ?

• 

  deepak.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 16 April 2018, 10:36 am EST

  Hello,

  With Spread.Sheets currently there seems to be no direct way of having non contiguous range for data points. You would need to remove the row/column before setting the range. Or may set the value as 0 before setting the data range.

  Thanks,
  
  Deepak Sharma

• 

  hghanta

  • Post Options:
  • Link
    Copy

  Posted 17 April 2018, 11:33 am EST

  Both the solutions proposed are not flexible. Can you please discuss the same with your product management & ensure the same is added as part of your backlog ?

• 

  deepak.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 18 April 2018, 10:14 am EST

  Hello,

  I have submitted it as an enhancement request for future release. The request id for this is 257247.

  Thanks,
  
  Deepak Sharma

• 

  deepak.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 19 April 2018, 4:52 am EST

  Hello,

  Development team suggested that you can hide the row or column for which you do not want to show the data in chart. Then the chart will also ignore these hidden data.

  Thanks,
  
  Deepak Sharma