---
id: video/iqyfWujhfnE
type: video
title: Add a live Chart of your Spreadsheet inside Business Central (Advanced Spreadsheets and Reporting)
summary: 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.
tier: community
language: en
tags:
  - spreadsheets
  - charts
  - data visualization
  - advanced spreadsheets and reporting
  - table regions
  - live data
system: reporting
review:
  state: reviewed
  by: opus
  at: "2026-10-07T23:18:24.906Z"
  flags: []
generated:
  at: "2026-10-13T00:32:41.360Z"
  pipeline: 0.2.0
  prompts:
    extract-video: 1
    summarize-video: 2
  input_hash: e1cc41ddbfa4e4f8f1d75e110bf5e57dafca86af3da2f48c39874fc38bbac89b
evidence:
  - kind: video
    url: https://www.youtube.com/watch?v=iqyfWujhfnE&t=0s
    title: Add a live Chart of your Spreadsheet inside Business Central (Advanced Spreadsheets and Reporting)
    date: "2026-09-21T19:14:15.000Z"
    commit: null
    t: 0
    quote: How to add a live chart to your spreadsheet using the advanced spreadsheets and reporting app for Business Central.
  - kind: video
    url: https://www.youtube.com/watch?v=iqyfWujhfnE&t=26s
    title: Add a live Chart of your Spreadsheet inside Business Central (Advanced Spreadsheets and Reporting)
    date: "2026-09-21T19:14:15.000Z"
    commit: null
    t: 26
    quote: this is just a table region meaning that we're grabbing data out of Business Central
  - kind: video
    url: https://www.youtube.com/watch?v=iqyfWujhfnE&t=63s
    title: Add a live Chart of your Spreadsheet inside Business Central (Advanced Spreadsheets and Reporting)
    date: "2026-09-21T19:14:15.000Z"
    commit: null
    t: 63
    quote: So this is live, right? So if anything happens, this will be updated.
  - kind: video
    url: https://www.youtube.com/watch?v=iqyfWujhfnE&t=155s
    title: Add a live Chart of your Spreadsheet inside Business Central (Advanced Spreadsheets and Reporting)
    date: "2026-09-21T19:14:15.000Z"
    commit: null
    t: 155
    quote: The app is free to try uh and use in a sandbox cloud sandbox.
links:
  learn: []
  objects:
    - object/table/18
  features: []
  topics: []
  localizations: []
  videos: []
  posts: []
  guidelines: []
video_id: iqyfWujhfnE
channel: yt-hougaard
source_name: Erik Hougaard
url: https://www.youtube.com/watch?v=iqyfWujhfnE
published_at: "2026-09-21T19:14:15.000Z"
duration_s: 170
captions: derived
audience:
  - functional consultant
  - administrator
  - end user
chapters:
  - t: 0
    title: Introduction and spreadsheet setup
  - t: 26
    title: Creating a data table region from customer table
  - t: 63
    title: Adding and configuring a chart region
  - t: 96
    title: Mapping data and categories to the chart
  - t: 143
    title: Preview and conclusion
features:
  - name: Live charts in spreadsheets
    status: unclear
    t: 75
    verified: false
    status_source: video
  - name: Table regions for data display
    status: unclear
    t: 26
    verified: false
    status_source: video
  - name: Advanced Spreadsheets and Reporting app
    status: unclear
    t: 0
    verified: false
    status_source: video
  - name: Column charts
    status: unclear
    t: 86
    verified: false
    status_source: video
objects_mentioned:
  - table Customer
quotes:
  - t: 0
    text: How to add a live chart to your spreadsheet using the advanced spreadsheets and reporting app for Business Central.
    check: exact
  - t: 26
    text: this is just a table region meaning that we're grabbing data out of Business Central
    check: exact
  - t: 63
    text: So this is live, right? So if anything happens, this will be updated.
    check: exact
  - t: 155
    text: The app is free to try uh and use in a sandbox cloud sandbox.
    check: exact
---

# 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.

[Watch on YouTube](https://www.youtube.com/watch?v=iqyfWujhfnE) · Erik Hougaard · 2026-09-21 · 2:50 · tier community · reviewed (checked by Opus)

## 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.

## Chapters

- [0:00](https://www.youtube.com/watch?v=iqyfWujhfnE&t=0s) Introduction and spreadsheet setup
- [0:26](https://www.youtube.com/watch?v=iqyfWujhfnE&t=26s) Creating a data table region from customer table
- [1:03](https://www.youtube.com/watch?v=iqyfWujhfnE&t=63s) Adding and configuring a chart region
- [1:36](https://www.youtube.com/watch?v=iqyfWujhfnE&t=96s) Mapping data and categories to the chart
- [2:23](https://www.youtube.com/watch?v=iqyfWujhfnE&t=143s) Preview and conclusion

## Features

Every feature below: status not stated, demoed.

| Feature | At |
|---|---|
| Live charts in spreadsheets | [1:15](https://www.youtube.com/watch?v=iqyfWujhfnE&t=75s) |
| Table regions for data display | [0:26](https://www.youtube.com/watch?v=iqyfWujhfnE&t=26s) |
| Advanced Spreadsheets and Reporting app | [0:00](https://www.youtube.com/watch?v=iqyfWujhfnE&t=0s) |
| Column charts | [1:26](https://www.youtube.com/watch?v=iqyfWujhfnE&t=86s) |

## 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.

- [table 18 "Customer"](../objects/table/18.md) at [0:39](https://www.youtube.com/watch?v=iqyfWujhfnE&t=39s)

## Quotes

- [0:00](https://www.youtube.com/watch?v=iqyfWujhfnE&t=0s) "How to add a live chart to your spreadsheet using the advanced spreadsheets and reporting app for Business Central."
- [0:26](https://www.youtube.com/watch?v=iqyfWujhfnE&t=26s) "this is just a table region meaning that we're grabbing data out of Business Central"
- [1:03](https://www.youtube.com/watch?v=iqyfWujhfnE&t=63s) "So this is live, right? So if anything happens, this will be updated."
- [2:35](https://www.youtube.com/watch?v=iqyfWujhfnE&t=155s) "The app is free to try uh and use in a sandbox cloud sandbox."

## Disclaimers in the video

- [2:35](https://www.youtube.com/watch?v=iqyfWujhfnE&t=155s) other: The app is free to try and use in a sandbox cloud sandbox

Presenters (as heard): Eric.