The Chart result block visualizes several calculated values together as a bar, horizontal bar, or doughnut chart — ideal for comparing breakdowns, splits, and contributions.
When to use it
Use a Chart result when one number is not enough and you want to show how several values relate: a cost breakdown, a before/after comparison, or the share of a total. Each value (a "data series") is its own formula cell with its own label and color.
Add the block
- In the editor, switch to the Output view.
- Click + Add and choose Chart.
- Select the block to open its settings.
Choose the chart type
In the Chart group, use the Chart Type toggle to switch between:
- Bar — vertical bars.
- Horizontal bar — bars running left to right.
- Doughnut — a ring showing each value's share.
You can change the type at any time without re-entering your data.
Add data series
Each series is a separate value plotted on the chart.
- In the Chart group, click Add + to create a series.
- Click the cell box to enter assign mode, then pick the formula cell that holds this series' value.
- Set a color for the series.
- Enter a Data Label (for example "Rent", "Utilities") — this is what shows in the legend and tooltip.
Repeat for each value you want to plot. To remove a series, hover over it and click the delete icon.
Format the values
In the Chart group:
- Number Format — Number, Currency, or Percentage. Currency reveals a currency selector.
- Decimal places — digits after the decimal point.
The chosen format is applied to the values shown in chart tooltips.
Title and spacing
In the Title group, set a Chart Title (with an optional description) shown above the chart, and adjust Block Spacing for padding above and below the block.