The flexible table chart type

The table is your dashboard workhorse: pick the metrics you need, show difference columns, make it readable with heatmaps and conditional formatting — and export to Excel and natively editable PowerPoint, with formatting preserved.

Try DataLion free
DataLion table widget with metrics, subcolumns and heatmap formatting

DataLion's table chart type shows counts, percentages by row, column and total, valid %, mean, median and index. It supports subcolumns, difference columns, in-cell heatmaps and conditional formatting, plus flexible sorting. Tables export to Excel and natively editable PowerPoint — with formatting preserved.

  • 🇩🇪 Made in Munich
  • GDPR-compliant
  • DPA included
  • Hosted in Germany

Trusted by research, insights & media teams

  • YouGov
  • SevenOne Media
  • Mediengruppe RTL Deutschland
  • Nielsen Sports
  • mobile.de
  • 50+ interactive chart types
  • 20+ statistical methods (R)
  • 2 weeks release cadence
  • ISO 27001 certified data centers (Germany)

Counts, percentages, mean, median and index

The DataLion table shows exactly the number you need: counts (absolute values), percentages by row, column and total, plus valid % that cleanly removes missing values from the base.

For metric questions you add mean and median, and the index relates each cell to the total sample — so you spot over- and under-represented groups at a glance. Several metrics can sit side by side as subcolumns.

  • Counts and percentages by row, column and total
  • Valid % with missing values removed
  • Mean and median for metric questions
  • Index against the total sample
DataLion table with counts, percentages, mean and index in subcolumns

Subcolumns and difference columns

Place groups right next to each other: with subcolumns you compare target groups, regions or waves in a single table. A difference column computes the change between two columns and shows it right alongside — no side calculation.

That way you read the development wave by wave straight from the table. When you need complete banners and significance testing, the crosstabs page has you covered.

  • Subcolumns for groups, regions and waves
  • Difference columns show the change right alongside
  • No helper columns, no side calculation
  • For banners and significance: see crosstabs
DataLion table with subcolumns and a difference column between two waves

Heatmaps, formatting, sorting — and export

Make the table readable at a glance: color cells as an in-cell heatmap or flag outliers with conditional formatting by threshold. Sort freely by any column, ascending or descending, so the most important values sit on top.

And the best part: tables export to Excel and as natively editable PowerPoint — with the formatting preserved. For more on colouring, see the conditional formatting page.

  • In-cell heatmaps and conditional formatting
  • Freely sortable by any column
  • Export to Excel and natively editable PowerPoint
  • Formatting preserved on export
DataLion table with an in-cell heatmap and conditional formatting, export-ready for PowerPoint

See DataLion with your own data

Start a free trial or book a personal demo — from raw data to a finished dashboard.

Try it free Book a demo
We now work much more efficiently, giving us more time to take care of the derivations and insights from the data for the customers.
Jens Falkenau, Vice President of Market Research · Nielsen Sports
Read the case study →

More on tables & charts

Guides in the help center

Common questions about the table chart type

Which metrics can a DataLion table show?
Counts (absolute values), percentages by row, column and total, valid %, mean, median and index. Several metrics can sit side by side as subcolumns.
What is a difference column?
A difference column computes the change between two columns — say two waves or two groups — and shows it right in the table, with no side calculation or helper columns.
Can I sort and colour tables?
Yes. You sort freely by any column, ascending or descending, and colour cells with an in-cell heatmap or conditional formatting by threshold, so outliers become instantly visible.
Is the formatting preserved on export?
Yes. Tables export to Excel and as natively editable PowerPoint — the formatting, including heatmaps and conditional formatting, is preserved.
How is the table different from crosstabs?
The table is the flexible chart type for your dashboard — for metrics, difference columns, formatting and export. Complete banners with nested subcolumns and significance testing are built on the crosstabs page.

Build your first table

Try DataLion free: metrics, difference columns, heatmaps and export in one widget. Or get a demo of how flexible the table chart type is.

Try it free Book a demo