Advanced Excel · Schema

ChartInput

Request to create a chart.

AutomationBusiness IntelligenceData AnalysisData ProcessingExcelMicrosoftSpreadsheets

Properties

Name Type Description
type string Chart type.
sourceData string A1-style data range.
seriesBy string How series are plotted.
View JSON Schema on GitHub

JSON Schema

excel-api-chartinput-schema.json Raw ↑
{
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "title": "ChartInput",
  "description": "Request to create a chart.",
  "type": "object",
  "properties": {
    "type": {
      "type": "string",
      "description": "Chart type.",
      "example": "ColumnClustered"
    },
    "sourceData": {
      "type": "string",
      "description": "A1-style data range.",
      "example": "Sheet1!A1:B10"
    },
    "seriesBy": {
      "type": "string",
      "description": "How series are plotted.",
      "enum": [
        "Auto",
        "Columns",
        "Rows"
      ]
    }
  }
}