Skip to content
Bitta Apps

Chapter 2 of 4Page 6 of 12

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

  1. On the Insert tab, choose Chart. There are nine types: Column, Bar, Line, Area, Pie, Doughnut, Combo, Waterfall and Sparkline.
  2. 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.
  3. Give it a title. A title can quote a cell in brackets, for example the year's total.
  4. Choose the legend, the number format, for example thousands, and whether to show data labels. Then choose Insert.
Insert chart dialog with the nine chart types, data from cells or live data, title, colors, legend and number format

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.

Posted Sales Invoice Lines opened by clicking a column of a chart on live data

Insert a KPI card

  1. Type the target in a cell.
  2. On the Insert tab, choose KPI card.
  3. Give it a Label, and set the Value to a cell, for example the fourth quarter.
  4. Compare with another cell, such as the third quarter, and set the Target to the cell with the target.
  5. Under Card, choose Progress to target, with a Ring or a bar.
Insert KPI card dialog with the label, value cell, compare with, target, progress to target and a ring

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.
Sales dashboard with a monthly chart, a quarter trend line and a Q4 sales KPI card showing 96 percent of target on a ring

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.

Next step

Ready to try Bitta Sheets?