Google Apps Script: How to set “Use column A as labels” in chart embedded in spreadsheet?

by

Found it! Set the option useFirstColumnAsDomain to true with EmbeddedChartBuilder.setOption.

This option appears to be undocumented. I found it by going to “Publish chart” (click on the chart, then select from the drop-down in the top right) and inspecting the JavaScript data structure in the given code. To be exact, I created a chart with “Use column A as labels” unchecked, grabbed the publish data structure, then checked “use column A as labels”, grabbed the new publish data structure, and compared the two. To compare, I suggest normalizing the JSON and running diff. This technique can be used to reverse-engineer any settings in the chart editor.

More Related Contents:

  1. Refresh data retrieved by a custom function in Google Sheet
  2. How do you create a “reverse pivot” in Google Sheets?
  3. Create Google Calendar Events from Spreadsheet but prevent duplicates
  4. ultimate short custom number formatting – K, M, B, T, etc., Q, D, Googol
  5. Apps Script: how to get hyperlink from a cell where there is no formula
  6. Retrieving Google Sheets cell border style programmatically
  7. Determining the last row in a single column
  8. Cannot find method getRange(number,number)?
  9. You do not have permission to call openById
  10. Google Apps Script, copy one spreadsheet to another spreadsheet with formatting
  11. Single Google Form for multiple Sheets [duplicate]
  12. Adding Buttons To Google Sheets and Set value to Cells on clicking
  13. How do I communicate a page(modal dialog) with its sibling (sidebar)?
  14. How to replace text in Google Spreadsheet using App Scripts?
  15. Custom function throws a “You do not have the permission required to setValue” error
  16. Margins parameters for Google spreadsheet export as PDF
  17. Google Apps Script: Dynamically creating spreadsheet menu items
  18. Script to convert .XLSX to Google Sheet and move converted file
  19. Hidden field in a Google Form
  20. Apply multiple font colors to the text in a single Google Sheets cell
  21. How to evaluate a spreadsheet formula within a custom function?
  22. Google Sheet use Importxml error could not fetch url [duplicate]
  23. On Edit doesnt work if cell auto updates – Need a workaround Google Sheets
  24. Adding a property to an Html template gives error “Object does not allow properties to be added or changed”
  25. Use script in all spreadsheets
  26. Iterate over range, append string to each
  27. Can the google spreadsheet ‘query’ function be used in google apps script?
  28. Custom Functions and Recalculation
  29. How to create INDIRECT array string of multiple sheet references in Google Sheets?
  30. google script openById : You do not have permission to perform that action

Leave a Comment