addedInput schema / $defs / Axis
Added value: +{
+ "properties": {
+ "labels": {
+ "default": "next_to_axis",
+ "description": "Tick label position; to hide them, number_format ';;;'.",
+ "enum": [
+ "next_to_axis",
+ "low",
+ "high"
+ ],
+ "type": "string"
+ },
+ "log": {
+ "type": "boolean"
+ },
+ "major_gridlines": {
+ "description": "Default: on for the value axis, off for categories.",
+ "type": "boolean"
+ },
+ "major_unit": {
+ "type": "number"
+ },
+ "max": {
+ "type": "number"
+ },
+ "min": {
+ "type": "number"
+ },
+ "minor_gridlines": {
+ "type": "boolean"
+ },
+ "number_format": {
+ "type": "string"
+ },
+ "reverse": {
+ "type": "boolean"
+ },
+ "title": {
+ "type": "string"
+ }
+ },
+ "type": "object"
+}
addedInput schema / $defs / Bins
Added value: +{
+ "properties": {
+ "count": {
+ "maximum": 1000,
+ "type": "integer"
+ },
+ "overflow": {
+ "description": "One bin for values above this.",
+ "type": "number"
+ },
+ "underflow": {
+ "description": "One bin for values at or below this.",
+ "type": "number"
+ },
+ "width": {
+ "description": "Values per bin.",
+ "type": "number"
+ }
+ },
+ "type": "object"
+}
addedInput schema / $defs / BoxPlot
Added value: +{
+ "properties": {
+ "inner_points": {
+ "type": "boolean"
+ },
+ "mean_line": {
+ "type": "boolean"
+ },
+ "mean_marker": {
+ "default": true,
+ "type": "boolean"
+ },
+ "outliers": {
+ "default": true,
+ "type": "boolean"
+ },
+ "quartiles": {
+ "default": "exclusive",
+ "enum": [
+ "exclusive",
+ "inclusive"
+ ],
+ "type": "string"
+ }
+ },
+ "type": "object"
+}
removedInput schema / $defs / ChartOptions / description
Removed value: -"Chart titles, size and legend."
addedInput schema / $defs / ChartOptions / properties / bins
Added value: +{
+ "$ref": "#/$defs/Bins",
+ "description": "Histogram, or pareto of numbers. Default: automatic."
+}
addedInput schema / $defs / ChartOptions / properties / box
Added value: +{
+ "$ref": "#/$defs/BoxPlot"
+}
addedInput schema / $defs / ChartOptions / properties / colors
Added value: +{
+ "description": "Hex, per series or pie slice in order. A series' color wins.",
+ "items": {
+ "type": "string"
+ },
+ "type": "array"
+}
addedInput schema / $defs / ChartOptions / properties / connector_lines
Added value: +{
+ "default": true,
+ "description": "Waterfall.",
+ "type": "boolean"
+}
addedInput schema / $defs / ChartOptions / properties / data_labels
Added value: +{
+ "$ref": "#/$defs/DataLabels",
+ "description": "All series; a series' own data_labels win."
+}
addedInput schema / $defs / ChartOptions / properties / grouping
Added value: +{
+ "default": "standard",
+ "description": "Stacked: column, bar, line, area.",
+ "enum": [
+ "standard",
+ "stacked",
+ "percent_stacked"
+ ],
+ "type": "string"
+}
removedInput schema / $defs / ChartOptions / properties / height_cm / description
Removed value: -"Chart height in cm."
removedInput schema / $defs / ChartOptions / properties / height_cm / exclusiveMinimum
Removed value: -0
removedInput schema / $defs / ChartOptions / properties / height_cm / title
Removed value: -"Height Cm"
addedInput schema / $defs / ChartOptions / properties / legend
Added value: +{
+ "description": "Default: Excel's for the type.",
+ "enum": [
+ "right",
+ "left",
+ "top",
+ "bottom",
+ "none"
+ ],
+ "type": "string"
+}
addedInput schema / $defs / ChartOptions / properties / markers
Added value: +{
+ "description": "Line charts.",
+ "type": "boolean"
+}
addedInput schema / $defs / ChartOptions / properties / parent_labels
Added value: +{
+ "default": "overlapping",
+ "description": "Treemap group labels.",
+ "enum": [
+ "overlapping",
+ "banner",
+ "none"
+ ],
+ "type": "string"
+}
addedInput schema / $defs / ChartOptions / properties / plot_color
Added value: +{
+ "description": "Hex.",
+ "type": "string"
+}
addedInput schema / $defs / ChartOptions / properties / scatter_style
Added value: +{
+ "default": "markers",
+ "enum": [
+ "markers",
+ "lines_markers",
+ "lines",
+ "smooth_markers",
+ "smooth"
+ ],
+ "type": "string"
+}
addedInput schema / $defs / ChartOptions / properties / secondary_y_axis
Added value: +{
+ "$ref": "#/$defs/Axis",
+ "description": "For series with secondary_axis; pareto: the percentage axis (0 to 1)."
+}
removedInput schema / $defs / ChartOptions / properties / show_legend
Removed value: -{
- "default": true,
- "description": "Show the series legend.",
- "title": "Show Legend",
- "type": "boolean"
-}
addedInput schema / $defs / ChartOptions / properties / smooth
Added value: +{
+ "description": "Line charts.",
+ "type": "boolean"
+}
addedInput schema / $defs / ChartOptions / properties / style
Added value: +{
+ "description": "Excel 2007 chart style (1 grayscale, 2 colorful, 3-8 one accent color).",
+ "maximum": 48,
+ "type": "integer"
+}
removedInput schema / $defs / ChartOptions / properties / title / anyOf
Removed value: -[
- {
- "type": "string"
- },
- {
- "type": "null"
- }
-]
removedInput schema / $defs / ChartOptions / properties / title / default
Removed value: -null
removedInput schema / $defs / ChartOptions / properties / title / description
Removed value: -"Chart title."
removedInput schema / $defs / ChartOptions / properties / title / title
Removed value: -"Title"
addedInput schema / $defs / ChartOptions / properties / title / type
Added value: +"string"
addedInput schema / $defs / ChartOptions / properties / title_size
Added value: +{
+ "description": "Points. Default 14.",
+ "maximum": 72,
+ "minimum": 6,
+ "type": "integer"
+}
addedInput schema / $defs / ChartOptions / properties / totals
Added value: +{
+ "description": "Waterfall: 1-based positions of total points.",
+ "items": {
+ "type": "integer"
+ },
+ "type": "array"
+}
removedInput schema / $defs / ChartOptions / properties / width_cm / description
Removed value: -"Chart width in cm."
removedInput schema / $defs / ChartOptions / properties / width_cm / exclusiveMinimum
Removed value: -0
removedInput schema / $defs / ChartOptions / properties / width_cm / title
Removed value: -"Width Cm"
addedInput schema / $defs / ChartOptions / properties / x_axis
Added value: +{
+ "$ref": "#/$defs/Axis",
+ "description": "Category axis (no min, max, major_unit, log, number_format); x values in scatter and bubble."
+}
removedInput schema / $defs / ChartOptions / properties / x_axis_title
Removed value: -{
- "anyOf": [
- {
- "type": "string"
- },
- {
- "type": "null"
- }
- ],
- "default": null,
- "description": "Horizontal axis title.",
- "title": "X Axis Title"
-}
addedInput schema / $defs / ChartOptions / properties / y_axis
Added value: +{
+ "$ref": "#/$defs/Axis"
+}
removedInput schema / $defs / ChartOptions / properties / y_axis_title
Removed value: -{
- "anyOf": [
- {
- "type": "string"
- },
- {
- "type": "null"
- }
- ],
- "default": null,
- "description": "Vertical axis title.",
- "title": "Y Axis Title"
-}
removedInput schema / $defs / ChartOptions / title
Removed value: -"ChartOptions"
addedInput schema / $defs / DataLabels
Added value: +{
+ "properties": {
+ "number_format": {
+ "type": "string"
+ },
+ "position": {
+ "description": "Column, bar (not stacked: outside_end), waterfall, histogram, pareto: center, inside_end, inside_base, outside_end. Line, scatter, bubble: center, above, below, left, right. Pie: center, inside_end, outside_end, best_fit.",
+ "enum": [
+ "center",
+ "inside_end",
+ "inside_base",
+ "outside_end",
+ "above",
+ "below",
+ "left",
+ "right",
+ "best_fit"
+ ],
+ "type": "string"
+ },
+ "show": {
+ "default": [
+ "value"
+ ],
+ "description": "'percent': pie and doughnut only. Empty: none.",
+ "items": {
+ "enum": [
+ "value",
+ "percent",
+ "category",
+ "series"
+ ],
+ "type": "string"
+ },
+ "type": "array"
+ }
+ },
+ "type": "object"
+}
addedInput schema / $defs / ErrorBars
Added value: +{
+ "properties": {
+ "axis": {
+ "default": "y",
+ "description": "'x': scatter and bubble.",
+ "enum": [
+ "y",
+ "x"
+ ],
+ "type": "string"
+ },
+ "direction": {
+ "default": "both",
+ "enum": [
+ "both",
+ "plus",
+ "minus"
+ ],
+ "type": "string"
+ },
+ "end_cap": {
+ "default": true,
+ "type": "boolean"
+ },
+ "kind": {
+ "enum": [
+ "fixed",
+ "percent",
+ "std_dev",
+ "std_error"
+ ],
+ "type": "string"
+ },
+ "value": {
+ "description": "Amount, percentage or standard deviations; not for 'std_error'.",
+ "type": "number"
+ }
+ },
+ "required": [
+ "kind"
+ ],
+ "type": "object"
+}
addedInput schema / $defs / SeriesSpec
Added value: +{
+ "properties": {
+ "categories": {
+ "description": "Default: the top-level `categories`. Scatter and bubble: x values.",
+ "type": "string"
+ },
+ "color": {
+ "description": "Hex, e.g. '#C00000': fill, or the line of line and scatter series.",
+ "type": "string"
+ },
+ "data_labels": {
+ "$ref": "#/$defs/DataLabels",
+ "description": "Overrides options.data_labels."
+ },
+ "error_bars": {
+ "$ref": "#/$defs/ErrorBars"
+ },
+ "line_width_pt": {
+ "maximum": 20,
+ "type": "number"
+ },
+ "marker": {
+ "enum": [
+ "circle",
+ "square",
+ "diamond",
+ "triangle",
+ "x",
+ "star",
+ "dash",
+ "dot",
+ "plus",
+ "none"
+ ],
+ "type": "string"
+ },
+ "marker_size": {
+ "maximum": 72,
+ "minimum": 2,
+ "type": "integer"
+ },
+ "name": {
+ "description": "Text, or a sheet-qualified cell like 'Data!B1'.",
+ "type": "string"
+ },
+ "secondary_axis": {
+ "description": "Use options.secondary_y_axis, a second value axis.",
+ "type": "boolean"
+ },
+ "sizes": {
+ "description": "Bubble charts.",
+ "type": "string"
+ },
+ "trendline": {
+ "$ref": "#/$defs/Trendline"
+ },
+ "type": {
+ "description": "Draw it differently from chart_type (combo chart).",
+ "enum": [
+ "column",
+ "line",
+ "area"
+ ],
+ "type": "string"
+ },
+ "values": {
+ "description": "One row or column, e.g. 'Data!B2:B13' (no sheet: the chart's). Scatter and bubble: y values.",
+ "type": "string"
+ }
+ },
+ "required": [
+ "values"
+ ],
+ "type": "object"
+}
addedInput schema / $defs / Trendline
Added value: +{
+ "properties": {
+ "equation": {
+ "type": "boolean"
+ },
+ "order": {
+ "description": "Polynomial. Default 2.",
+ "maximum": 6,
+ "minimum": 2,
+ "type": "integer"
+ },
+ "period": {
+ "description": "Moving average.",
+ "maximum": 255,
+ "minimum": 2,
+ "type": "integer"
+ },
+ "r_squared": {
+ "type": "boolean"
+ },
+ "type": {
+ "enum": [
+ "linear",
+ "exponential",
+ "logarithmic",
+ "polynomial",
+ "power",
+ "moving_average"
+ ],
+ "type": "string"
+ }
+ },
+ "required": [
+ "type"
+ ],
+ "type": "object"
+}
removedInput schema / properties / anchor_cell
Removed value: -{
- "description": "Cell where the chart's top-left sits.",
- "title": "Anchor Cell",
- "type": "string"
-}
addedInput schema / properties / at
Added value: +{
+ "description": "Top-left cell. Omit for a new chart sheet named `sheet`.",
+ "type": "string"
+}
addedInput schema / properties / categories
Added value: +{
+ "description": "Labels for series without their own.",
+ "type": "string"
+}
changedInput schema / properties / chart_type / description
Previous value: -"Kind of chart to draw."New value: +"Excel 2016 types (waterfall to funnel) need `at`; they take no combo, trendline, colors or secondary axis."
changedInput schema / properties / chart_type / enum
Previous value: -[
- "column",
- "bar",
- "line",
- "area",
- "pie",
- "scatter"
-]New value: +[
+ "column",
+ "bar",
+ "line",
+ "area",
+ "pie",
+ "doughnut",
+ "radar",
+ "scatter",
+ "bubble",
+ "waterfall",
+ "histogram",
+ "pareto",
+ "box_whisker",
+ "treemap",
+ "sunburst",
+ "funnel"
+]
removedInput schema / properties / chart_type / title
Removed value: -"Chart Type"
removedInput schema / properties / data_range
Removed value: -{
- "description": "Data with a header row, labels in the first column and one series per further column, e.g. 'A1:C13'.",
- "title": "Data Range",
- "type": "string"
-}
removedInput schema / properties / data_sheet
Removed value: -{
- "anyOf": [
- {
- "type": "string"
- },
- {
- "type": "null"
- }
- ],
- "default": null,
- "description": "Sheet holding the data. Default: `sheet`.",
- "title": "Data Sheet"
-}
addedInput schema / properties / name
Added value: +{
+ "description": "Unique among the sheet's charts and images.",
+ "type": "string"
+}
addedInput schema / properties / options / $ref
Added value: +"#/$defs/ChartOptions"
removedInput schema / properties / options / anyOf
Removed value: -[
- {
- "$ref": "#/$defs/ChartOptions"
- },
- {
- "type": "null"
- }
-]
removedInput schema / properties / options / default
Removed value: -null
removedInput schema / properties / options / description
Removed value: -"Titles, size and legend. Default: none."
removedInput schema / properties / path / description
Removed value: -"Path to an .xlsx, .xlsm, .xltx or .xltm file. Relative paths are resolved in the server's workbook directory when one is configured; otherwise use an absolute path."
removedInput schema / properties / path / title
Removed value: -"Path"
addedInput schema / properties / replace
Added value: +{
+ "description": "Name of a chart to replace in place, keeping its name unless `name` is given.",
+ "type": "string"
+}
addedInput schema / properties / series
Added value: +{
+ "description": "Instead of `source`: any ranges, on any sheet.",
+ "items": {
+ "$ref": "#/$defs/SeriesSpec"
+ },
+ "type": "array"
+}
addedInput schema / properties / series_in
Added value: +{
+ "default": "columns",
+ "description": "'rows': one series per row of `source`.",
+ "enum": [
+ "columns",
+ "rows"
+ ],
+ "type": "string"
+}
removedInput schema / properties / sheet / description
Removed value: -"Worksheet name, e.g. 'Sheet1'."
removedInput schema / properties / sheet / title
Removed value: -"Sheet"
addedInput schema / properties / source
Added value: +{
+ "description": "Header row, labels in the first column, a series per further column, e.g. 'A1:C13'. Scatter: x first. Bubble: x, y, size. Excel 2016 types: leading text columns are labels (levels), number columns the series.",
+ "type": "string"
+}
changedInput schema / required
Previous value: -[
- "path",
- "sheet",
- "data_range",
- "chart_type",
- "anchor_cell"
-]New value: +[
+ "path",
+ "sheet",
+ "chart_type"
+]
removedInput schema / title
Removed value: -"create_chartArguments"
changedOutput schema / (root)
Previous value: -{
- "properties": {
- "result": {
- "title": "Result",
- "type": "string"
- }
- },
- "required": [
- "result"
- ],
- "title": "create_chartOutput",
- "type": "object"
-}New value: +null