Please add similar functionality as addSeria and RemoveSeria for the cateogry. would be nice to be able to fully manipulate charts to update with buttons ( to add & remove data from the source table )
Hello @RHunter
Please elaborate on what you referring to as “category”. Such methods as AddSeria and RemoveSeria already exist for the ApiChart class.
The horizontal axis
There are plenty of methods that interact with horizontal axis available for the ApiChart class. Please specify what exactly you are looking for or provide detailed scenario you would like to achieve.
The only methods I found on the Spreadsheet API are SetMajorHorizontalGridlines and SetMinorHorizontalGridlines.
In my case I want to do a macro that will update the chart by adding or removing series and values from the horizontal axis. It kinda works for now as well but I have problems with it when switching the row/ columns in the chart.
Can you provide your macro for current implementation?