Escribal
Back to Docs

Spreadsheet

Charts

This group adds and manages charts on a sheet. It can insert nine chart types — bar/column, line, pie, area, scatter (XY), bubble, doughnut, radar and a bar + line combo — and then edit an existing chart: change the data it points at, set the chart or axis titles, show or hide the legend, apply a built-in style, and move, resize, reposition or delete it.

Prerequisite: before using any of these instructions, the workflow must already have an XLSX spreadsheet created or opened (with Create spreadsheet). Every instruction works on a sheet (tab) inside that spreadsheet, identified by name (Sheet1 by default), which must already exist — and the data the chart shows should already be in its cells.

These concepts recur across several instructions in this group; they are explained here once.

  • Document: indicates which document in the workflow the instruction applies to. If left empty, the current document is used. If the document doesn’t exist, the instruction simply does nothing.

  • The sheet must already exist: the Sheet name field chooses which tab the instruction works on, and defaults to Sheet1. If no sheet with that name is found, the instruction does nothing and the workflow continues with the next instruction.

  • Data ranges use spreadsheet notation: fields like Category range, Values range, X range, Y range and Size range point at the cells that hold the data, written the spreadsheet way — Sheet1!$A$1:$A$5. The chart stores these references; the bars, lines and slices are drawn when you open the file in a spreadsheet app.

  • Where the chart sits (anchoring): the Insert instructions place a chart by its top-left anchor cell — Anchor column and Anchor row, both counted from 1 (1 = column A / the first row) — and a size given in whole cells: Width in columns and Height in rows. A width or height of 0 (or a negative one) would make the chart invisible, so it is raised to one cell.

  • A chart needs data: if the Values range (the Y range on scatter and bubble charts) is left empty, the Insert instruction does nothing rather than adding an empty chart. Likewise, Change Chart Data Range with an empty range and Set Chart Title / Set Axis Title with empty text leave the chart as it is instead of blanking it.

  • Which chart (chart number): instructions that edit an existing chart identify it by its position on the sheet, Chart number, counted from 1 in the order the charts were added (the first chart is 1, the second 2, …). If there is no chart at that position, the instruction does nothing and the workflow continues with the next instruction.

  • Saving the new chart’s number: every Insert instruction offers a Save chart number field. Fill it in with a name and the position of the chart it just created is saved under that name — so you don’t have to count the charts already on the sheet. Feed it straight into the Chart number (from variable) field of any instruction that edits a chart.

  • Chart style: a built-in style number from 1 to 48. In the Insert instructions a Style index of 0 means “no explicit style”.

  • Dynamic values (@name): in any text field (sheet name, ranges, titles, series names, legend position, axis, …) you can type @ followed by the name of a value saved earlier in the workflow, and it will be replaced by that value.

  • “From variable” fields: the @name trick only works in text fields. The number options (like Chart number, Style index, Anchor column, Width in columns, Hole size, …) each have a companion “from variable” field:

    • If you leave it empty, the value chosen in the normal field is used.
    • If you fill it in with the name of a saved value, the engine ignores the normal field and reads the number from that variable.

    This is mainly for chaining instructions. If you only work with fixed values, you can ignore these fields.

Apply Chart Style .xlsx

Applies one of the built-in visual styles to an existing chart.

When to use it: to restyle a chart you already inserted — changing its colors and overall look in one step.

Parameter Meaning Default Required
Document Document the instruction applies to (current document) No
Sheet name Tab holding the chart. Supports @name Sheet1 No
Chart number Which chart on the sheet, counted from 1 1 No
Style index Built-in style number 1–48 2 No
Chart number (from variable) Reads the chart number from a saved value (empty) No
Style index (from variable) Reads the style number from a saved value (empty) No

Important behavior: the style number is clamped to the 1–48 range. If there is no chart at Chart number, the instruction does nothing.

Change Chart Data Range .xlsx

Repoints an existing chart at different data ranges, without recreating it.

When to use it: when the chart is fine but the cells it should read have changed (for example after adding more rows of data).

Parameter Meaning Default Required
Document Document the instruction applies to (current document) No
Sheet name Tab holding the chart. Supports @name Sheet1 No
Chart number Which chart on the sheet, counted from 1 1 No
Category range New range for the categories / X values. Supports @name Sheet1!$A$1:$A$5 No
Values range New range for the values / Y values. Supports @name Sheet1!$B$1:$B$5 No
Chart number (from variable) Reads the chart number from a saved value (empty) No

Important behavior: updates every series in the chart — the category (and scatter/bubble X) references are set to Category range, and the value (and Y) references to Values range. If there is no chart at Chart number, the instruction does nothing.

Delete Chart .xlsx

Removes a chart from the sheet.

When to use it: to discard a chart that is no longer needed.

Parameter Meaning Default Required
Document Document the instruction applies to (current document) No
Sheet name Tab holding the chart. Supports @name Sheet1 No
Chart number Which chart on the sheet, counted from 1 1 No
Chart number (from variable) Reads the chart number from a saved value (empty) No

Important behavior: deletes the chart and its placement. If that was the sheet’s last drawing, the (now empty) drawing container is cleaned up too. If there is no chart at Chart number, the instruction does nothing.

Insert Area Chart .xlsx

Inserts an area chart (a line chart with the space beneath the line filled in).

When to use it: to emphasize the magnitude of a value over a sequence of categories — for example cumulative totals over time.

Parameter Meaning Default Required
Document Document the instruction applies to (current document) No
Sheet name Tab to place the chart on. Supports @name Sheet1 No
Category range Cells for the category labels. Supports @name Sheet1!$A$1:$A$5 No
Values range Cells for the values. Supports @name Sheet1!$B$1:$B$5 No
Series name Name of the data series (legend label). Supports @name Series 1 No
Title Chart title (empty = no title). Supports @name (empty) No
Show legend Yes = show the legend Yes No
Style index Built-in style 1–48; 0 = none 0 No
Anchor column Top-left cell column, from 1 (1 = column A) 4 No
Anchor row Top-left cell row, from 1 (1 = first row) 2 No
Width in columns How many columns wide the chart is 10 No
Height in rows How many rows tall the chart is 15 No
Show legend (from variable) Reads the yes/no value from a saved value (empty) No
Style index (from variable) Reads the style number from a saved value (empty) No
Anchor column (from variable) Reads the anchor column from a saved value (empty) No
Anchor row (from variable) Reads the anchor row from a saved value (empty) No
Width in columns (from variable) Reads the width from a saved value (empty) No
Height in rows (from variable) Reads the height from a saved value (empty) No
Save chart number Name to save the new chart’s number under (empty) No

Important behavior: a title is only shown when Title isn’t empty. If the named sheet doesn’t exist, the instruction does nothing. If Save chart number is filled, the new chart’s number (its position among the sheet’s charts) is saved there.

Insert Bar Chart .xlsx

Inserts a bar or column chart.

When to use it: to compare values across categories — vertical columns by default, or horizontal bars.

Parameter Meaning Default Required
Document Document the instruction applies to (current document) No
Sheet name Tab to place the chart on. Supports @name Sheet1 No
Category range Cells for the category labels. Supports @name Sheet1!$A$1:$A$5 No
Values range Cells for the values. Supports @name Sheet1!$B$1:$B$5 No
Series name Name of the data series (legend label). Supports @name Series 1 No
Title Chart title (empty = no title). Supports @name (empty) No
Horizontal Yes = horizontal bars; No = vertical columns No No
Show legend Yes = show the legend Yes No
Style index Built-in style 1–48; 0 = none 0 No
Anchor column Top-left cell column, from 1 (1 = column A) 4 No
Anchor row Top-left cell row, from 1 (1 = first row) 2 No
Width in columns How many columns wide the chart is 10 No
Height in rows How many rows tall the chart is 15 No
Horizontal (from variable) Reads the yes/no value from a saved value (empty) No
Show legend (from variable) Reads the yes/no value from a saved value (empty) No
Style index (from variable) Reads the style number from a saved value (empty) No
Anchor column (from variable) Reads the anchor column from a saved value (empty) No
Anchor row (from variable) Reads the anchor row from a saved value (empty) No
Width in columns (from variable) Reads the width from a saved value (empty) No
Height in rows (from variable) Reads the height from a saved value (empty) No
Save chart number Name to save the new chart’s number under (empty) No

Important behavior: Horizontal switches between bar and column direction. A title is only shown when Title isn’t empty. If the named sheet doesn’t exist, the instruction does nothing. If Save chart number is filled, the new chart’s number (its position among the sheet’s charts) is saved there.

Insert Bubble Chart .xlsx

Inserts a bubble chart — an XY chart where a third value sets each point’s size.

When to use it: to show three numeric dimensions at once (position X, position Y, and magnitude as the bubble size).

Parameter Meaning Default Required
Document Document the instruction applies to (current document) No
Sheet name Tab to place the chart on. Supports @name Sheet1 No
X range Cells for the X values. Supports @name Sheet1!$A$1:$A$5 No
Y range Cells for the Y values. Supports @name Sheet1!$B$1:$B$5 No
Size range Cells for the bubble sizes. Supports @name Sheet1!$C$1:$C$5 No
Series name Name of the data series (legend label). Supports @name Series 1 No
Title Chart title (empty = no title). Supports @name (empty) No
Show legend Yes = show the legend Yes No
Style index Built-in style 1–48; 0 = none 0 No
Anchor column Top-left cell column, from 1 (1 = column A) 4 No
Anchor row Top-left cell row, from 1 (1 = first row) 2 No
Width in columns How many columns wide the chart is 10 No
Height in rows How many rows tall the chart is 15 No
Show legend (from variable) Reads the yes/no value from a saved value (empty) No
Style index (from variable) Reads the style number from a saved value (empty) No
Anchor column (from variable) Reads the anchor column from a saved value (empty) No
Anchor row (from variable) Reads the anchor row from a saved value (empty) No
Width in columns (from variable) Reads the width from a saved value (empty) No
Height in rows (from variable) Reads the height from a saved value (empty) No
Save chart number Name to save the new chart’s number under (empty) No

Important behavior: both axes are value axes (there are no category labels). A title is only shown when Title isn’t empty. If the named sheet doesn’t exist, the instruction does nothing. If Save chart number is filled, the new chart’s number (its position among the sheet’s charts) is saved there.

Insert Combo Chart .xlsx

Inserts a combination chart: columns and a line together, optionally with the line on a second axis.

When to use it: to show two related series with different scales — for example revenue as columns and a percentage as a line.

Parameter Meaning Default Required
Document Document the instruction applies to (current document) No
Sheet name Tab to place the chart on. Supports @name Sheet1 No
Category range Cells for the shared category labels. Supports @name Sheet1!$A$1:$A$5 No
Bar values range Cells for the column series. Supports @name Sheet1!$B$1:$B$5 No
Line values range Cells for the line series. Supports @name Sheet1!$C$1:$C$5 No
Bar series name Legend label for the columns. Supports @name Bars No
Line series name Legend label for the line. Supports @name Line No
Title Chart title (empty = no title). Supports @name (empty) No
Line on second axis Yes = put the line on a secondary (right) axis No No
Show legend Yes = show the legend Yes No
Style index Built-in style 1–48; 0 = none 0 No
Anchor column Top-left cell column, from 1 (1 = column A) 4 No
Anchor row Top-left cell row, from 1 (1 = first row) 2 No
Width in columns How many columns wide the chart is 10 No
Height in rows How many rows tall the chart is 15 No
Line on second axis (from variable) Reads the yes/no value from a saved value (empty) No
Show legend (from variable) Reads the yes/no value from a saved value (empty) No
Style index (from variable) Reads the style number from a saved value (empty) No
Anchor column (from variable) Reads the anchor column from a saved value (empty) No
Anchor row (from variable) Reads the anchor row from a saved value (empty) No
Width in columns (from variable) Reads the width from a saved value (empty) No
Height in rows (from variable) Reads the height from a saved value (empty) No
Save chart number Name to save the new chart’s number under (empty) No

Important behavior: both series share the category labels, and the line joins its points with straight segments. With Line on second axis set to Yes, the line gets its own right-hand scale. A title is only shown when Title isn’t empty. If the named sheet doesn’t exist, the instruction does nothing. If Save chart number is filled, the new chart’s number (its position among the sheet’s charts) is saved there.

Insert Doughnut Chart .xlsx

Inserts a doughnut chart — like a pie, but with a hole in the middle.

When to use it: to show parts of a whole with a lighter look, or when you want a ring shape.

Parameter Meaning Default Required
Document Document the instruction applies to (current document) No
Sheet name Tab to place the chart on. Supports @name Sheet1 No
Category range Cells for the slice labels. Supports @name Sheet1!$A$1:$A$5 No
Values range Cells for the slice values. Supports @name Sheet1!$B$1:$B$5 No
Series name Name of the data series. Supports @name Series 1 No
Title Chart title (empty = no title). Supports @name (empty) No
Hole size Size of the center hole, as a percentage (10–90) 50 No
Show legend Yes = show the legend Yes No
Style index Built-in style 1–48; 0 = none 0 No
Anchor column Top-left cell column, from 1 (1 = column A) 4 No
Anchor row Top-left cell row, from 1 (1 = first row) 2 No
Width in columns How many columns wide the chart is 10 No
Height in rows How many rows tall the chart is 15 No
Hole size (from variable) Reads the hole size from a saved value (empty) No
Show legend (from variable) Reads the yes/no value from a saved value (empty) No
Style index (from variable) Reads the style number from a saved value (empty) No
Anchor column (from variable) Reads the anchor column from a saved value (empty) No
Anchor row (from variable) Reads the anchor row from a saved value (empty) No
Width in columns (from variable) Reads the width from a saved value (empty) No
Height in rows (from variable) Reads the height from a saved value (empty) No
Save chart number Name to save the new chart’s number under (empty) No

Important behavior: Hole size is clamped to the 10–90 range. A title is only shown when Title isn’t empty. If the named sheet doesn’t exist, the instruction does nothing. If Save chart number is filled, the new chart’s number (its position among the sheet’s charts) is saved there.

Insert Line Chart .xlsx

Inserts a line chart.

When to use it: to show a trend across categories — for example a value changing over time.

Parameter Meaning Default Required
Document Document the instruction applies to (current document) No
Sheet name Tab to place the chart on. Supports @name Sheet1 No
Category range Cells for the category labels. Supports @name Sheet1!$A$1:$A$5 No
Values range Cells for the values. Supports @name Sheet1!$B$1:$B$5 No
Series name Name of the data series (legend label). Supports @name Series 1 No
Title Chart title (empty = no title). Supports @name (empty) No
Smooth Yes = smooth curved line; No = straight segments No No
Show markers Yes = show a dot at each data point Yes No
Show legend Yes = show the legend Yes No
Style index Built-in style 1–48; 0 = none 0 No
Anchor column Top-left cell column, from 1 (1 = column A) 4 No
Anchor row Top-left cell row, from 1 (1 = first row) 2 No
Width in columns How many columns wide the chart is 10 No
Height in rows How many rows tall the chart is 15 No
Smooth (from variable) Reads the yes/no value from a saved value (empty) No
Show markers (from variable) Reads the yes/no value from a saved value (empty) No
Show legend (from variable) Reads the yes/no value from a saved value (empty) No
Style index (from variable) Reads the style number from a saved value (empty) No
Anchor column (from variable) Reads the anchor column from a saved value (empty) No
Anchor row (from variable) Reads the anchor row from a saved value (empty) No
Width in columns (from variable) Reads the width from a saved value (empty) No
Height in rows (from variable) Reads the height from a saved value (empty) No
Save chart number Name to save the new chart’s number under (empty) No

Important behavior: Smooth and Show markers control the line’s look. A title is only shown when Title isn’t empty. If the named sheet doesn’t exist, the instruction does nothing. If Save chart number is filled, the new chart’s number (its position among the sheet’s charts) is saved there.

Insert Pie Chart .xlsx

Inserts a pie chart.

When to use it: to show how a single series splits into parts of a whole.

Parameter Meaning Default Required
Document Document the instruction applies to (current document) No
Sheet name Tab to place the chart on. Supports @name Sheet1 No
Category range Cells for the slice labels. Supports @name Sheet1!$A$1:$A$5 No
Values range Cells for the slice values. Supports @name Sheet1!$B$1:$B$5 No
Series name Name of the data series. Supports @name Series 1 No
Title Chart title (empty = no title). Supports @name (empty) No
Show legend Yes = show the legend Yes No
Style index Built-in style 1–48; 0 = none 0 No
Anchor column Top-left cell column, from 1 (1 = column A) 4 No
Anchor row Top-left cell row, from 1 (1 = first row) 2 No
Width in columns How many columns wide the chart is 10 No
Height in rows How many rows tall the chart is 15 No
Show legend (from variable) Reads the yes/no value from a saved value (empty) No
Style index (from variable) Reads the style number from a saved value (empty) No
Anchor column (from variable) Reads the anchor column from a saved value (empty) No
Anchor row (from variable) Reads the anchor row from a saved value (empty) No
Width in columns (from variable) Reads the width from a saved value (empty) No
Height in rows (from variable) Reads the height from a saved value (empty) No
Save chart number Name to save the new chart’s number under (empty) No

Important behavior: a pie shows a single series, so only the first column of values is used. A title is only shown when Title isn’t empty. If the named sheet doesn’t exist, the instruction does nothing. If Save chart number is filled, the new chart’s number (its position among the sheet’s charts) is saved there.

Insert Radar Chart .xlsx

Inserts a radar chart (also called a spider chart), where categories radiate from a center.

When to use it: to compare several measures on a common scale — for example the strengths of an item across several criteria.

Parameter Meaning Default Required
Document Document the instruction applies to (current document) No
Sheet name Tab to place the chart on. Supports @name Sheet1 No
Category range Cells for the category labels. Supports @name Sheet1!$A$1:$A$5 No
Values range Cells for the values. Supports @name Sheet1!$B$1:$B$5 No
Series name Name of the data series (legend label). Supports @name Series 1 No
Title Chart title (empty = no title). Supports @name (empty) No
Filled Yes = fill the area inside the shape; No = outline with markers No No
Show legend Yes = show the legend Yes No
Style index Built-in style 1–48; 0 = none 0 No
Anchor column Top-left cell column, from 1 (1 = column A) 4 No
Anchor row Top-left cell row, from 1 (1 = first row) 2 No
Width in columns How many columns wide the chart is 10 No
Height in rows How many rows tall the chart is 15 No
Filled (from variable) Reads the yes/no value from a saved value (empty) No
Show legend (from variable) Reads the yes/no value from a saved value (empty) No
Style index (from variable) Reads the style number from a saved value (empty) No
Anchor column (from variable) Reads the anchor column from a saved value (empty) No
Anchor row (from variable) Reads the anchor row from a saved value (empty) No
Width in columns (from variable) Reads the width from a saved value (empty) No
Height in rows (from variable) Reads the height from a saved value (empty) No
Save chart number Name to save the new chart’s number under (empty) No

Important behavior: Filled switches between a filled radar and an outline with markers. A title is only shown when Title isn’t empty. If the named sheet doesn’t exist, the instruction does nothing. If Save chart number is filled, the new chart’s number (its position among the sheet’s charts) is saved there.

Insert Scatter Chart .xlsx

Inserts a scatter (XY) chart, plotting points from paired X and Y values.

When to use it: to show the relationship between two numeric variables, with or without connecting lines.

Parameter Meaning Default Required
Document Document the instruction applies to (current document) No
Sheet name Tab to place the chart on. Supports @name Sheet1 No
X range Cells for the X values. Supports @name Sheet1!$A$1:$A$5 No
Y range Cells for the Y values. Supports @name Sheet1!$B$1:$B$5 No
Series name Name of the data series (legend label). Supports @name Series 1 No
Title Chart title (empty = no title). Supports @name (empty) No
Show lines Yes = connect the points with lines; No = markers only No No
Show legend Yes = show the legend Yes No
Style index Built-in style 1–48; 0 = none 0 No
Anchor column Top-left cell column, from 1 (1 = column A) 4 No
Anchor row Top-left cell row, from 1 (1 = first row) 2 No
Width in columns How many columns wide the chart is 10 No
Height in rows How many rows tall the chart is 15 No
Show lines (from variable) Reads the yes/no value from a saved value (empty) No
Show legend (from variable) Reads the yes/no value from a saved value (empty) No
Style index (from variable) Reads the style number from a saved value (empty) No
Anchor column (from variable) Reads the anchor column from a saved value (empty) No
Anchor row (from variable) Reads the anchor row from a saved value (empty) No
Width in columns (from variable) Reads the width from a saved value (empty) No
Height in rows (from variable) Reads the height from a saved value (empty) No
Save chart number Name to save the new chart’s number under (empty) No

Important behavior: both axes are value axes. Show lines switches between a line-and-marker and a markers-only look. A title is only shown when Title isn’t empty. If the named sheet doesn’t exist, the instruction does nothing. If Save chart number is filled, the new chart’s number (its position among the sheet’s charts) is saved there.

Move Chart To Sheet .xlsx

Moves a chart from one sheet to another sheet, placing it at a chosen position.

When to use it: to relocate a chart onto a different tab — for example gathering all charts on a dedicated dashboard sheet.

Parameter Meaning Default Required
Document Document the instruction applies to (current document) No
Source sheet name Tab the chart is currently on. Supports @name Sheet1 No
Chart number Which chart on the source sheet, from 1 1 No
Target sheet name Tab to move the chart to. Supports @name Sheet1 No
Anchor column Top-left cell column on the target, from 1 1 No
Anchor row Top-left cell row on the target, from 1 1 No
Width in columns How many columns wide the chart is 10 No
Height in rows How many rows tall the chart is 15 No
Chart number (from variable) Reads the chart number from a saved value (empty) No
Anchor column (from variable) Reads the anchor column from a saved value (empty) No
Anchor row (from variable) Reads the anchor row from a saved value (empty) No
Width in columns (from variable) Reads the width from a saved value (empty) No
Height in rows (from variable) Reads the height from a saved value (empty) No

Important behavior: the chart is copied to the target sheet and the original is removed from the source. If either sheet does not exist, or there is no chart at Chart number on the source, the instruction does nothing.

Position Chart .xlsx

Moves and resizes a chart on its sheet by setting a new top-left position and size.

When to use it: to place an existing chart at exact coordinates (and, in the same step, set how many cells it spans).

Parameter Meaning Default Required
Document Document the instruction applies to (current document) No
Sheet name Tab holding the chart. Supports @name Sheet1 No
Chart number Which chart on the sheet, from 1 1 No
Anchor column New top-left cell column, from 1 1 No
Anchor row New top-left cell row, from 1 1 No
Width in columns How many columns wide the chart is 10 No
Height in rows How many rows tall the chart is 15 No
Chart number (from variable) Reads the chart number from a saved value (empty) No
Anchor column (from variable) Reads the anchor column from a saved value (empty) No
Anchor row (from variable) Reads the anchor row from a saved value (empty) No
Width in columns (from variable) Reads the width from a saved value (empty) No
Height in rows (from variable) Reads the height from a saved value (empty) No

Important behavior: sets both the top-left corner and the bottom-right corner (top-left + width/height). If there is no chart at Chart number, the instruction does nothing.

Resize Chart .xlsx

Changes a chart’s size while keeping its top-left corner where it is.

When to use it: to make an existing chart bigger or smaller without moving it.

Parameter Meaning Default Required
Document Document the instruction applies to (current document) No
Sheet name Tab holding the chart. Supports @name Sheet1 No
Chart number Which chart on the sheet, from 1 1 No
Width in columns New width, in columns 10 No
Height in rows New height, in rows 15 No
Chart number (from variable) Reads the chart number from a saved value (empty) No
Width in columns (from variable) Reads the width from a saved value (empty) No
Height in rows (from variable) Reads the height from a saved value (empty) No

Important behavior: the top-left corner stays fixed; only the bottom-right corner moves to apply the new size. If there is no chart at Chart number, the instruction does nothing.

Set Axis Title .xlsx

Sets the title of an axis (X or Y) on an existing chart.

When to use it: to label what an axis represents — for example “Month” on the X axis and “Sales” on the Y axis.

Parameter Meaning Default Required
Document Document the instruction applies to (current document) No
Sheet name Tab holding the chart. Supports @name Sheet1 No
Chart number Which chart on the sheet, from 1 1 No
Axis Which axis, chosen from a list: X (horizontal) or Y (vertical) X (horizontal) No
Axis title The text to show on the axis. Supports @name Axis Label No
Chart number (from variable) Reads the chart number from a saved value (empty) No

Important behavior: Axis is picked from a list, so it does not accept @name. X labels the horizontal (category) axis, Y the vertical (value) axis; the Y title is rotated as usual. For scatter/bubble charts (which have no category axis) X uses the first value axis and Y the second. Any previous title on that axis is replaced. If there is no chart at Chart number, or the chart has no plot area/axis, the instruction does nothing.

Set Chart Title .xlsx

Sets (or replaces) the main title of an existing chart.

When to use it: to give a chart a heading after inserting it, or to rename it.

Parameter Meaning Default Required
Document Document the instruction applies to (current document) No
Sheet name Tab holding the chart. Supports @name Sheet1 No
Chart number Which chart on the sheet, from 1 1 No
Title The chart title text. Supports @name Chart Title No
Chart number (from variable) Reads the chart number from a saved value (empty) No

Important behavior: any existing title is removed first and the new one put in its place. If there is no chart at Chart number, the instruction does nothing.

Set Legend Visibility .xlsx

Shows or hides the legend of an existing chart, and chooses where it sits.

When to use it: to turn the legend on or off, or move it to a different edge.

Parameter Meaning Default Required
Document Document the instruction applies to (current document) No
Sheet name Tab holding the chart. Supports @name Sheet1 No
Chart number Which chart on the sheet, from 1 1 No
Visible Yes = show the legend; No = hide it Yes No
Position Where the legend sits, chosen from a list: bottom, top, left or right Bottom No
Chart number (from variable) Reads the chart number from a saved value (empty) No
Visible (from variable) Reads the yes/no value from a saved value (empty) No

Important behavior: Position is picked from a list, so it does not accept @name. The current legend is removed first; if Visible is Yes a new one is added at Position. If there is no chart at Chart number, the instruction does nothing.

This documentation is the help of the application, and it comes underCreative Commons Attribution 4.0.