How to build charts from database data on Notion

intermediate 8 min read Updated 2026-03-18

Quick Answer

Create charts in Notion by adding a database view, then selecting the Chart view type and configuring your data columns for visualization. Notion supports bar charts, line charts, and pie charts based on your database properties.

Try Notion Full Notion Review

Prerequisites

Existing Notion workspace
Database with numerical data
Basic understanding of Notion databases
Data organized in columns suitable for visualization

Step-by-Step Instructions

Prepare your database with chartable data

Ensure your Notion database contains numerical properties that can be visualized. Add Number, Formula, or Rollup properties if needed. Your data should have at least one numerical column and one categorical column (like Text, Select, or Date) for grouping.

Clean up your data first - remove empty rows and ensure consistent formatting for better chart visualization.

Create a new database view

Open your database and click the + Add a view button next to existing views at the top. Select Chart from the view type dropdown menu. Give your chart view a descriptive name like 'Sales by Month' or 'Project Progress Chart'.

Configure the chart type and data source

In the chart configuration panel, select your preferred chart type: Bar chart, Line chart, or Pie chart. Choose the X-axis (horizontal) property for categories and Y-axis (vertical) property for values. For pie charts, select the Slice by property for segments and Value property for sizing.

Bar charts work best for comparing categories, line charts for trends over time, and pie charts for showing proportions.

Set up data aggregation

Choose how to aggregate your data using the Calculate dropdown. Options include Count (number of entries), Sum (total values), Average, Min, Max, or Median. This determines how multiple data points are combined for each category.

Use 'Count' to show frequency, 'Sum' for totals, and 'Average' for typical values in each category.

Apply filters and sorting

Click Filter to limit which database entries appear in your chart. Add conditions like date ranges, specific categories, or value thresholds. Use Sort to order your chart data by specific properties in ascending or descending order.

Filtering helps focus on relevant data periods or categories, making your charts more meaningful.

Customize chart appearance

Adjust the chart's visual properties in the view settings. You can modify the Color scheme, toggle Show values on data points, and adjust the Chart size. For line charts, enable or disable Show points and Smooth curves options.

Keep colors consistent with your workspace theme and enable value labels for better readability.

Save and share your chart

Click Done or press Escape to save your chart view. The chart will appear as a new tab in your database views. You can share the chart by copying the database link or embedding it in other Notion pages using /link and pasting the database URL.

Create multiple chart views of the same database to show different perspectives of your data.

Common Issues & Troubleshooting

Chart appears empty or shows no data

Check that your database has entries with values in the selected properties. Verify your filters aren't excluding all data and ensure the aggregation method matches your data type.

Chart view option is not available

Ensure you're using Notion's paid plan as chart views are a premium feature. Update your Notion app to the latest version if the option is still missing.

Data appears incorrectly grouped or aggregated

Review your X-axis and Y-axis property selections. Make sure you're using the correct data types - categories should use Text or Select properties, while values need Number properties.

Chart doesn't update with new database entries

Refresh the page or click on the chart view tab again. Charts should auto-update, but browser caching might delay changes. Check if new entries meet your filter criteria.

Prices mentioned in this guide are pulled from current plan data and may change. Always verify on the official Notion website before purchasing.

Visit Notion View Notion Pricing