Bitta Sheets · Part 13 · 1:51 · YouTube
Business Central KPI Dashboard with Live Charts
What this video covers
Build a KPI dashboard on live Business Central data inside a workbook: charts from live data or from cells, and KPI cards with a comparison and a target.
Pick from nine chart types, title a chart with a value from a cell, and click a column to open the entries behind it.
Transcript
Marcus wants to see how the quarter is going, at a glance. Charts and a KPI card on live data give him that. Here's how to add charts and KPI cards to a workbook.
Charts and KPI cards sit on top of the sheet. They read your cells or your live data, and they refresh with them. On the Insert tab, choose Chart. There are nine types, from column and line to waterfall and sparkline.
Take the data from a live data block. Here, the monthly sales pivot. Give it a title, hide the legend, and show the numbers in thousands. The chart reads the pivot, and it refreshes with it.
Click a column, and Business Central opens the entries behind it. Charts can also read cells. Pick the range, and give it a title that quotes a cell, like the year's total.
A line chart of the quarters, with a label on every point. For a KPI card, first type a target in a cell. Insert a KPI card. Its value is a cell, here the fourth quarter.
Compare it with the third quarter, and point it at the target. Show it as progress to target, on a ring. The card shows the change against the last quarter, and how close it is to the target.
Drag a chart by its title bar to move it, and drag its corner to resize it. Both snap to the cells. Use charts and KPI cards when a number needs to be seen at a glance,
right next to the data behind it. Next, scheduled sending: email a workbook on a fixed day.
More Bitta Sheets videos
All videos
1:18OverviewEdit Business Central Tables Live in a Spreadsheet
2:08Part 1Edit Business Central Data in an Excel-Style Sheet
3:08Part 2Business Central Bulk Update Without Export and Import
2:50Part 3Business Central Budget in a Spreadsheet, Written Back Live
2:35Part 4Business Central Budget Entry by Department
2:56Part 5Business Central Consolidation: Companies and Account Mapping