Workbooks
Charts and KPI cards
Add charts and KPI cards to a Business Central workbook: chart live data or cells, click a column to drill down, and show a KPI as progress to its target.
updated: applies-to: 1.0.0.0
Charts and KPI cards sit on top of the sheet. They read your cells or your live data, and they refresh with them.
Insert a chart
- On the Insert tab, choose Chart. There are nine types: Column, Bar, Line, Area, Pie, Doughnut, Combo, Waterfall and Sparkline.
- Under Data from, choose Live data and pick a live data block, such as a monthly sales pivot. Or choose Cells and pick the data range, the categories and the series names.
- Give it a title. A title can quote a cell in brackets, for example the year's total.
- Choose the legend, the number format, for example thousands, and whether to show data labels. Then choose Insert.
More options in the same dialog:
- Series side by side, stacked or 100% stacked.
- A second axis for a combo chart, and totals for a waterfall chart.
- A color scheme with a base color, and gridlines.
Drill down from a chart
A chart on live data reads that block, and it refreshes with it. Click a column, and Business Central opens the entries behind it.
Insert a KPI card
- Type the target in a cell.
- On the Insert tab, choose KPI card.
- Give it a Label, and set the Value to a cell, for example the fourth quarter.
- Compare with another cell, such as the third quarter, and set the Target to the cell with the target.
- Under Card, choose Progress to target, with a Ring or a bar.
The card shows the change against the comparison and how close the value is to the target.
Other KPI options:
- Change as shows the change as a percent, a difference or percentage points.
- Warning at and Critical at turn the card's status to Attention or Critical.
- Trend draws a range of cells as a small line.
- Direction says whether higher or lower is better.
- Accent sets the card's color.
Move and resize
Drag a chart or a card by its title bar to move it, and drag its corner to resize it. Both snap to the cells. Charts and cards print as pictures in Print and PDF.
When to use it
Use charts and KPI cards when a number needs to be seen at a glance, right next to the data behind it.