Get AI summaries of any video or article — Sign up free
The ultimate guide to Notion Charts (9 examples) thumbnail

The ultimate guide to Notion Charts (9 examples)

Thomas Frank Explains·
6 min read

Based on Thomas Frank Explains's video on YouTube. If you like this content, support the original creators by watching, liking and subscribing to their content.

TL;DR

Notion Charts are native database layout views that graph directly from database properties, letting dashboards stay synced with live data.

Briefing

Notion Charts turn database views into live, configurable graphs—so teams can build dashboards that pull directly from their data instead of maintaining separate spreadsheets. The core breakthrough is that charts are “native layout types” for Notion databases: once a chart view is added, it can graph almost any database property, sort it, style it, and—crucially—respond to filters and formulas. That combination is what makes the examples practical, from tracking Pokémon stats to monitoring task throughput and sales performance.

The guide starts with a simple bar chart built from a Pokedex-style dataset. A chart view is created by switching a database view’s layout type to “Chart,” then selecting a chart type (vertical bar, horizontal bar, line, or pie). The x-axis is mapped to a property (like the Pokémon name), while the y-axis is mapped to a numeric property (like HP). The y-axis can use different aggregation modes—values, sum, or average—so the same chart framework can show individual records or rollups across groups. Sorting is then applied (for example, HP high to low), and styling options such as auto-color, grid lines, axis labels, and data labels help make the chart readable.

From there, the examples scale in complexity by changing what “grouping” means. Instead of plotting each Pokémon, the guide groups by Pokémon type and graphs the average HP per type. In task management, charts become operational: an automation sets a “completed” date when a task status changes to done, enabling a line chart that counts tasks completed each day. Another chart uses a relation between tasks and projects to show task status distribution per project, and a “workload” chart uses a horizontal bar layout with filtering to exclude completed tasks—so managers can see who is overloaded based on “to-do” and “in progress” counts.

Level two introduces formulas as a way to create new chart-ready groupings. A multi-select “type” property can’t directly produce only “single vs dual” categories, so a formula computes a “type count” (length of the type list) and the chart graphs that derived value. The guide then builds customer-specific sales charts using another formula (“order total”) that sums product prices across related sales records via map and sum. A line chart is filtered to a single customer, then embedded into a database template using self-referential filters—so every new customer page automatically gets its own chart.

Level three delivers multi-series comparisons. Notion can’t natively multi-series multiple properties from a single record, so the guide uses a modeling workaround: create a separate “stats” table where each row represents one stat value tied to a Pokémon, then group by stat type to generate multi-series charts. For sales comparisons, it creates formula properties that bucket orders into “current period” vs “last period” and compute “day in cycle,” letting a line chart compare the last 30 days against the prior 30 days on the same graph.

Finally, the guide addresses practical constraints: free plans get only one chart view, exports are limited (charts can be downloaded as PNG/SVG rather than exported normally), and future improvements are expected—especially drill-downs that would let users click a data point to see the underlying database rows. The overall message is clear: charts become genuinely powerful when combined with relations, filters, and formulas that reshape raw data into the exact groupings dashboards need.

Cornell Notes

Notion Charts are database layout views that graph data directly from Notion properties, enabling dashboards without exporting to spreadsheets. The guide shows how to map x- and y-axes, choose chart types (bar, line, pie), and use numeric aggregations like values, sum, and average. Practical dashboards rely on relations (tasks↔projects, sales↔products) and filters (e.g., exclude completed tasks) to control what data appears. Formulas unlock new groupings—such as “single vs dual type” via type list length or customer-specific sales totals via map/sum across related records. For multi-series comparisons, the guide uses data modeling and formula “bucketing” to compare current vs previous periods on the same chart.

How does a basic Notion chart decide what goes on the x-axis and y-axis?

A chart view is created by setting a database’s layout type to “Chart,” then choosing a chart type (vertical bar, horizontal bar, line, or pie). The x-axis is mapped to a property that identifies each data point—such as the Pokémon “name” property, which also shows page icons. The y-axis is mapped to a numeric property—such as HP—and can use aggregation modes like “values,” “sum,” or “average.” After mapping, sorting can be applied (for example, HP high to low) and styling options can adjust colors, grid lines, axis labels, and data labels.

Why do numeric aggregation options (values vs average vs sum) matter once grouping changes?

When each x-axis item represents a single record, “values” works like a direct readout. But when the x-axis represents groups made from multiple records—like averaging HP by Pokémon type—aggregation becomes essential. In the Pokedex example, the x-axis is “type,” and the y-axis switches from count to HP with the aggregation set to “average,” producing results like an average HP of 81.5 for Dragon types and 56.5 for Bug types.

How does the “tasks done per day” chart get its x-axis data?

It depends on a “completed” date property that updates when task status changes to done. An automation sets “completed” to today’s date when status becomes complete. The line chart then graphs the “completed” date on the x-axis using a date granularity like “day,” while the y-axis stays on “count” to show how many tasks were completed each day. On free plans without automations, the guide notes you’d need to set the completion date manually or use an alternative like scripts/API.

What’s the difference between showing tasks by project and building a workload chart?

The project chart uses a relation between tasks and projects: the project relation becomes the x-axis, and task status can be grouped on the y-axis to show counts by status within each project. The workload chart instead uses a horizontal bar layout where the y-axis is team members (user profiles) and the chart is filtered to only include tasks in “to do” or “in progress,” omitting completed tasks. Grouping/visibility and filtering both affect which tasks contribute to each person’s workload.

How can formulas create chart categories that don’t exist as properties?

The guide uses formulas to derive a new property used by the chart. For “single vs dual type,” the Pokedex “type” property is a multi-select. A formula computes “type count” as length(types), outputting 1 for single-type Pokémon and 2 for dual-type Pokémon. The chart then uses “type count” as the x-axis grouping, producing only the two categories even though the original type list contains many options.

How does the guide build multi-series charts despite Notion’s limitation on multi-property series?

Notion multi-series charts can’t directly use multiple stat properties from a single record. The workaround is to normalize data into a separate “stats” table where each row represents one stat value tied to a Pokémon, with a “stat type” property (HP, attack, defense) defining the series groups. The chart then uses Pokémon as the x-axis, a numeric “value” as the y-axis, and groups by “stat type” to create multiple series. For sales period comparisons, formulas bucket each order into “current period” vs “last period” and compute “day in cycle,” then the chart groups by that derived period.

Review Questions

  1. In a Notion chart, what changes when the x-axis represents groups of multiple records rather than individual records?
  2. Describe how relations and filters work together in the workload chart to prevent completed tasks from skewing results.
  3. Why does the guide create a separate stats table for multi-series charts, and what properties does that table need?

Key Points

  1. 1

    Notion Charts are native database layout views that graph directly from database properties, letting dashboards stay synced with live data.

  2. 2

    Chart creation starts with selecting a chart layout type and mapping x-axis and y-axis properties, then choosing an aggregation mode like values, sum, or average.

  3. 3

    Filters can be applied to charts to change which underlying rows contribute to the graph, enabling “active work only” views like workload charts.

  4. 4

    Relations let charts pull from connected databases (tasks↔projects, sales↔products), making it possible to chart rollups that aren’t stored directly on a single table.

  5. 5

    Formulas are the main tool for creating new chart categories and metrics—such as type counts, completion dates, and customer-specific order totals.

  6. 6

    Self-referential filters in templates allow each new customer page to automatically show a chart filtered to that page’s customer record.

  7. 7

    Multi-series comparisons often require data modeling (e.g., a stats table) and formula bucketing because Notion can’t multi-series multiple properties from a single record directly.

Highlights

Charts are configured by mapping database properties to axes, then using aggregation (values/sum/average) to match whether each x-axis item is a single record or a group.
A “completed” date automation turns task status changes into a time-series chart of tasks finished per day.
Customer-specific sales charts are built by summing related product prices with map+sum, then applying the result via template self-referential filters.
Multi-series charts require either normalized data (stats table with stat type grouping) or formula-based bucketing (current vs last 30-day periods).
Free plans limit chart usage to a single chart view, and chart export is handled via PNG/SVG downloads rather than standard page export.

Topics