Charts and dashboards

Add charts and number cards to a sheet, show a spreadsheet as an animated full-screen dashboard with filters, put dashboards on a TV, and pin charts to Analytics.

Add a chart

Select the data - the first row holds the names of the series, the first column the labels - and press Insert > Chart (or the chart button). The chart appears beside the data and the Chart panel opens on the right:

Kind: columns, bars, lines, areas, pies, doughnuts, columns and lines together, scatter, funnel, number card or gauge.
Title, Data range (or Use selection), Stacked, Show values, Legend and Colours.

Drag a chart to move it and its bottom right corner to size it. Hover a chart for its buttons: edit, pin to Analytics and delete. Charts follow the cells: when a number changes - by hand, by a formula or by fresh app data - the chart changes too. Hidden and filtered-out rows stay out of charts.

Number cards and gauges

A number card shows one big number with a title: Insert > Number card. Its Value is a formula or a cell, like =SUM(B5:B40) or =-ELLIBO.BALANCE("income","2026"). Add Compare with - another formula - and the card shows the change in per cent with an arrow, green or red.

A gauge shows a value between a lowest and a highest number (a target), like sales against this month's goal.

The dashboard

Press Dashboard at the top of a spreadsheet. Its charts and number cards fill the screen in a grid:

cards rise in one after another, charts draw themselves and numbers count up;
the filters (see Live data from your apps) sit at the top - change one and every chart moves to its new values;
it refreshes itself every few minutes (Settings) - or press the refresh button;
on a phone the cards stack one under another.

View > Dashboard settings chooses which sheets show, and whether each sheet's table shows under its charts. Tick List this spreadsheet under Dashboards to find it under Dashboards in the menu.

TV mode

On the dashboard, press the TV button: the dashboard goes full screen with a dark background, and after the number of seconds set in Settings moves on to the next dashboard, then the next, round and round. Press Esc to stop. TV mode is on Professional and up.

Charts on Analytics dashboards

Press the pin button on a chart to make it available to Ellibo Analytics. In Analytics, edit a dashboard and use Spreadsheet chart to add it. The chart is drawn live from the spreadsheet, with each viewer's own access. Standard and up.