Add a live Chart of your Spreadsheet inside Business Central (Advanced Spreadsheets and Reporting)
Adding a live chart to a spreadsheet in Business Central with the Advanced Spreadsheets and Reporting app. A table region on the Customer table feeds a column chart of customer sales, and the chart updates when the data changes. The app is free to try in a sandbox cloud environment.
- Introduction and spreadsheet setup
- Creating a data table region from customer table
- Adding and configuring a chart region
- Mapping data and categories to the chart
- Preview and conclusion
Overview
Erik Hougaard shows, in about three minutes, how to add a live chart to a spreadsheet using the Advanced Spreadsheets and Reporting app for Business Central. He first sets up the spreadsheet, then creates a table region from the Customer table with columns for number, name and sales.
He then adds a chart region, chooses a column chart, and maps the data and categories to show customer sales. He explains that the table region pulls data out of Business Central, so the chart is live and updates when the data changes. The app is free to try and use in a sandbox cloud environment.
Key points
- A table region grabs (displays) data from a Business Central table; the demo uses the Customer table with number, name and sales columns.
- A chart region is added to the spreadsheet as a new region, named, and configured with a data range and a categories range.
- The demo uses a column chart to show customer sales.
- The data is live: if anything changes in Business Central, it is updated.
- The region needs a name before it can be saved and previewed.
- The Advanced Spreadsheets and Reporting app is free to try and use in a cloud sandbox.
Features
Every feature below: status not stated, demoed.
| Feature | At |
|---|---|
| Live charts in spreadsheets | 1:15 |
| Table regions for data display | 0:26 |
| Advanced Spreadsheets and Reporting app | 0:00 |
| Column charts | 1:26 |
AL objects mentioned
As heard in the captions. A name that matches one object page by exact type and name links to it; the others stay as named.
Quotes
- 0:00 “How to add a live chart to your spreadsheet using the advanced spreadsheets and reporting app for Business Central.”
- 0:26 “this is just a table region meaning that we’re grabbing data out of Business Central”
- 1:03 “So this is live, right? So if anything happens, this will be updated.”
- 2:35 “The app is free to try uh and use in a sandbox cloud sandbox.”
Disclaimers in the video
- 2:35 other: The app is free to try and use in a sandbox cloud sandbox
Presenters (as heard): Eric.