0

I have a table that can have any number of rows but fixed number of columns.

I'm able to chart the graph by column but now I want to chart them up by switching rows and column. From the Sheet I can do it with a single click "Swtich rows or column" in chart selection. How should I implement the same using Sheets APIv4? I'm using python sdk, if that helps.

T K Sourabh
  • 351
  • 2
  • 8

1 Answers1

1

Unfortunately this is not possible via Sheets API or Charts API

As a workaround you can create the graph with the data from a dummy sheet which you populate with transposed data - either programmaticaly or by cell formula.

Have a look at this post for transposing in Python.

ziganotschka
  • 25,866
  • 2
  • 16
  • 33