Switch Row/Column

Switch Row/Column

Posted by: dpandey on 15 October 2025, 8:29 am EST

• 

  dpandey

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 15 October 2025, 8:29 am EST - Updated 15 October 2025, 8:36 am EST

  I am trying to implement this Switch Row/Column functionality for charts using SpreadJS.
  
  So how SpreadJS is implementing this , is there any command for this in spreadJs , using which i can use or import this functionality. Or they simply transpose the data and then update the chart accordingly.
  
  Thanks & Regards

  

  3390×1904 496 KB

  

  3394×1934 498 KB

• 

  chirag.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 15 October 2025, 11:17 am EST - Updated 15 October 2025, 11:22 am EST

  Hi Deepak,

  It is possible to switch the data orientation between rows and columns in the SpreadJS charts by using the switchDataOrientation method.

  You can refer to the SpreadJS Charts Demo that demonstrates this functionality (see below).

  Please let us know if you require any further assistance.

  Kind Regards,
  
  Chirag

  References:

  1. switchDataOrientation: https://developer.mescius.com/spreadjs/api/classes/GC.Spread.Sheets.Charts.Chart#switchdataorientation
  2. SpreadJS Charts Demo: https://developer.mescius.com/spreadjs/demos/features/charts/basic-chart/purejs

  Working: