Formatting Charts
Once a chart shows the right data, formatting is what makes it readable: order, scales, colors, table styles, and what to do when labels collide.
Select a chart and the chart editor opens on the right. The settings are spread over three sections of it, and a few live outside it altogether:
| Section | What it holds |
|---|---|
| Axes | Which levels sit on which axis, their order, and comparisons |
| Formatting | Number and legend toggles, Scales and Digits, and the styling dialog for data series, columns and rows |
| Advanced Formatting | Stack Totals, empty data series, cross effects, Bridge Settings and other per-chart-type options |
| Outside the chart editor | A node’s own default scale, and the workspace setting for responsive text |
Charts
Put the level values in a custom orderSorting Level Values →Show a change as a delta or a percentageDelta Comparisons →Set the scale, decimals or range of an axis, or add a second oneAxis Scales and Decimals →Cut a large value range so small differences stay visibleY-Axis Breaks in Charts →Set the color, text style or value visibility of a data seriesStyling Data Series, Columns and Rows →Stack data series and label their totalStacking and Stack Totals →Scale one node’s numbers everywhere it is chartedDefault Scale Settings in Nodes →Let text scale with the size of the windowResponsive Chart Text Sizes →Get back values that disappeared where labels collideOverlapping Data Labels →
Tables
Switch the table style, resize columns or merge header cellsTable Formatting →Mark subtotal and total rows, or indent themStyling Data Series, Columns and Rows →
Related
- Data Display in Charts and Tables: which data a chart or table shows, and at which aggregation.
- Chart Types: which chart or tile to use in the first place.
- Creating Charts: adding a chart, duplicating one, and saving a configuration as a template.