CelesteCS Chart (from 2026-09-16: renamed from the generic "Chart" to avoid being confused with Confluence's own built-in legacy Chart macro, which has the same short name and shows up right next to it in the macro browser search results - look for CelesteCS Chart specifically, not just "Chart") renders a Bar, Line or Pie chart as a diagram, built directly from a range of cells on the page (and, optionally, a range of cells to use as labels). Just like Numerical Expression's formulas, the chart is recalculated fresh on every page view, so it always stays in sync with the underlying table data – no manual re-drawing or re-uploading an image is needed when the source numbers change.

Confluence table of monthly sales and the CelesteCS Chart bar chart drawn from it

Example: a bar chart drawn by CelesteCS Chart from the Sales column of the table above it.

New!

Chart macro has the following parameters:

Parameter Description
[String] Data range (required) The range of cells to plot, specified using the same Excel-like range-reference syntax as other Math macros and functions, for example 'Table1.B2:B6'. The range may be located on the current or another wiki page, just as with Numerical Expression operands. Each range must be a single column or a single row. New! For several lines or bar groups, list up to 10 ranges separated by a semicolon, for example 'Table1.B2:B7; Table1.C2:C7'.
[String] Labels range (default=empty) An optional range of cells to use as labels for each data point – category names for a Bar or Pie chart, or point labels along a Line chart. When left empty, the data points are drawn with no labels at all. If supplied but shorter than the data range, the extra data point(s) beyond the end of the labels range are drawn unlabelled rather than causing an error.
[Enum] Chart type (default='Bar') The type of chart to draw. May have one of the following values:
  • Bar
  • Line
  • Pie
An unrecognised value falls back to Bar rather than causing an error.
[String] Title (default=empty) An optional title shown above the chart.
[String] Color (default='#4C72B0') The chart's fill/line color when Colors is empty. Accepts a HEX color code (#rgb or #rrggbb) or a plain CSS color keyword name (for example 'blue'); any other value falls back to the default color.
[Enum] Axes (default='None') New! None, Axes, or Axes and gridlines. With axes the chart shows a value scale on the left and the labels along the bottom; gridlines add light horizontal lines at each scale step. Negative values are shown below zero.
[String] Series names (default=empty) New! Comma-separated names of the data ranges, in the same order, for example 'Plan, Actual'. They are shown in a legend under the chart.
[String] Colors (default=empty) New! Comma-separated colours, one per data range (Bar, Line) or per slice (Pie), for example '#4C72B0, #DD8452'. HEX codes or colour names.
[Number] Width (default=400) New! Chart width in pixels, 200 to 1200.
[Number] Height (default=260) New! Chart height in pixels, 150 to 800.

A chart that uses none of the new settings looks exactly as before. The chart text follows the dark theme. The new settings need Math 27.5.0 or later on Data Center.

Line chart with axes, gridlines, two series and a legend drawn by CelesteCS Chart from a table

Example: Chart type Line, Data range 'Table1.B2:B7; Table1.C2:C7', Labels range 'Table1.A2:A7', Series names 'Target, Actual', Axes and gridlines, Colors '#4C72B0, #DD8452', 700 x 320. Step by step: an Excel-style line chart in Confluence.

The chart is drawn as a self-contained diagram directly in the page – no external image file or attachment is created – and, like all Math macros, is recalculated on every page load, so it always reflects the current values in the referenced range.