Chart Customization
Every chart has a settings panel for choosing its data and type, and for styling it until it is ready to present.
Data and Chart Type
Click a chart, then click the settings button in its toolbar (or the menu button at the top right of the canvas). The panel has two tabs: Data and Style.
The Data tab controls what the chart shows:
Source frame: the frame the chart reads from.
Chart type: a green dot marks the types that suit your columns.
X axis and Y axis: pick columns. Use fx on a Y column to change its aggregation, and Add another column to plot more than one series.
Click Update chart to apply your changes.
The Data tab
To switch type quickly, use the chart type dropdown in the chart toolbar. It also marks recommended types.
The chart type dropdown in the chart toolbar
Available Chart Types
Line
Bar
Stacked bar
Horizontal bar
Area
Pie
Scatter
Bubble
Histogram
Number card
Style Tab
The Style tab has a rail of sections down its left edge: General, Axis & Grid, Legend & Labels, Chart-Specific, Number Format and References. Hover an icon to see its name. Sections that don't apply are hidden, for example Axis & Grid for pie charts and number cards.
General
Background colour, border, chart type, the chart title (text, size, bold, italic, underline and colour) and the axis titles.
Style → General
Legend & Labels
Legend: position (top, bottom, left or right), horizontal or vertical layout, text style, or hide it.
Data labels: show values on the chart, with format, position (top, center or bottom; inside or outside for pie) and text style.
Tooltip: text style and a custom tooltip format.
Chart-Specific
Every chart gets a colour palette: Default, Green, Pastel, Vibrant, Dark, Neon, Grayscale, or build your own with as many colours as you need. The rest depends on the chart type:
Line and area: line width and style, markers (size and shape), and area opacity.
Bar: corner radius and orientation.
Pie: inner radius (above 0 makes a donut), outer radius, pull out a segment, and a center label.
Scatter: point size, shape and opacity.
Number card: value display, font size and formatting, plus a subtitle.
Axis & Grid
Pick the axis in Select Axis to Configure, then set:
Grid lines: show or hide, colour, opacity, width and line style.
Axis labels and tick lines: show or hide each, and rotate labels from -90° to 90°.
Style → Axis & Grid
Number Format and Transformations
Value format: Number, Currency (with a currency symbol) or Percentage, plus decimal precision.
Thousand separator: comma (1,000), period (1.000) or space (1 000).
Large numbers: K, M and B notation, or a fixed unit (thousands, millions or billions).
Transformations: show cumulative values, show as percentages (useful for stacked bars), or add a moving average.
Reference Lines and Tooltips
Reference Lines
Mark a target or threshold. In References, click Add Reference Line, then set the value, a label, its colour and the line style (solid, dashed or dotted). Add as many as you need, and remove one with its bin icon.
Style → References
Tooltips
Hover any bar, point or slice to see its category and exact value.