Chart view

Chart view
In this Article

Charts help visualize the vast amount of information in your database. Customize your charts so you can see your data in the way that’s most helpful. You can even put charts from multiple databases into a Notion page to create a powerful dashboard 📊


Note: Everyone on a paid plan can create unlimited charts. Members on the Free plan can try one chart for free. Learn more about charts availability here →

Note:

  • Charts can only display up to 200 groups and 50 subgroups at a time (for example, 200 days on the X-axis).

  • If you’re in a large database, your chart may be a little bit slower to update.

  • If your database’s sub-items or sub-tasks aren’t reflecting in your chart, you may have to update your database settings to display all items in your database as a flattened list. To do this, select ••• at the top of your database → Customize {your database's name}Sub-items or Sub-tasks. Next to Show as, adjust the setting to Flattened list. Learn more about viewing sub-items here →

To create a chart in Notion:

  1. In a page, use the slash command /chart.

  2. In the menu that appears, select Vertical bar chart, Horizontal bar chart, Line chart, or Donut chart.

  3. Link an existing database, or select New chart to create a new database.

Note: At this time, you can’t edit database entries from chart view. Use or create another view to edit your data.

Chart view works with existing databases so that it can take your current database items and visualize them. To add a chart view to a database:

  1. In a database, select + next to your existing views. Depending on your screen size, you may have to open the dropdown next to your current view and select Add view.

  2. In the menu that appears, select Chart.

To turn a view in your database into a chart view:

  1. Select ••• at the top of your database.

  2. Select Layout.

  3. Select Chart.

Change your chart type

There are several types of charts you can choose from. To change your chart type:

  1. With your chart view open, select ••• at the top of your database.

  2. Select Vertical bar chart, Horizontal bar chart, Line chart, or Donut chart.

Customize your bar or line chart

Note:

  • The X and Y axis configurations are only available for bar and line charts.

  • Your X and Y axes won’t be able to show rollups, buttons, unique IDs, files and media, or formulas resulting in a list of outputs. Certain formulas, like formulas based on relations and rollups and other complex formulas, may cause charts to take a little bit longer to load.

The X and Y axes of your chart can be configured to show you what’s most important. To configure your X axis:

  1. With your chart view open, select ••• at the top of your database.

  2. Under X axis, you can adjust the following:

    • What to show: Choose the property that should be associated with your X axis. Let’s say you want the X axis to show your tasks by status.

    • Sort by: Choose how your data should be sorted. For example, you might want to sort by ascending status (going from to-do to complete). You can also control what’s shown or hidden from your chart by selecting 👁️ next to any of the options under Visible groups. For example, you might choose to exclude any tasks marked as complete from your chart if you’re only looking to visualize your in-progress tasks. Anything that’s hidden will move to Hidden groups.

    • Omit zero values: Depending on your setup, you may or may not see this option. Toggle this on or off depending on whether you want to include property values for which there are no associated items. For example, let’s say you have a status for paused tasks. If there aren’t any tasks in your database that are paused, you can toggle Omit zero values off if you don’t want the paused status shown in your chart. If you toggle on Omit zero values, you’ll see all of the status options in your chart, even if there are no tasks for some of those status options.

To configure your Y axis:

  1. With your chart view open, select ••• at the top of your database.

  2. Under Y axis, you can adjust the following:

    • What to show: Choose the property that should be associated with your Y axis. You can also choose to show Count, which would show you the number of items associated with your X axis.

    • Group by: Choose the property that you want to group your Y axis by. You can also choose None if you don’t want any grouping.

    • Omit zero values: Depending on your setup, you may or may not see this option. Toggle this on or off depending on whether you want to include property values for which there are no associated items. For example, let’s say you have a status for paused tasks. If there aren’t any tasks in your database that are paused, you can toggle Omit zero values off if you don’t want the paused status shown in your chart. If you toggle on Omit zero values, you’ll see all of the status options in your chart, even if there are no tasks for some of those status options.

    • Cumulative: You’ll see this option if your chart is showing Count or Sum and your X axis property is sorted in ascending order. Toggle on Cumulative if you want your chart to reflect the total amount of information gathered over time. Toggle off Cumulative if you want the chart to reflect the data for the current moment in time. For example, let’s say you have a chart where you’re tracking how many tasks you have completed. You completed two tasks yesterday, and three tasks today. If Cumulative is toggled on, you’ll see two tasks completed yesterday, and five tasks (two from yesterday, three from today) completed today. If Cumulative is toggled off, you’ll see two tasks completed yesterday, and three tasks completed today.

Customize your donut chart

Note: Your donut chart won’t be able to show rollups, buttons, unique IDs, files and media, and certain formulas.

Donut charts can be customized slightly differently from other chart types. To customize your donut chart:

  1. With your chart view open, select ••• at the top of your database.

  2. Under Data, you can adjust:

    • What to show: Choose the property you want your data to show.

    • Each slice represents: Choose the property you want your slices to be organized by.

    • Sort by: Choose how your data should be sorted. For example, you might want to sort by ascending status (going from to-do to complete). You can also control what’s shown or hidden from your chart by selecting 👁️ next to any of the options under Visible groups. For example, you might choose to exclude any tasks marked as complete from your chart if you’re only looking to visualize your in-progress tasks. Anything that’s hidden will move to Hidden groups.

Change your chart style

You can customize the look and feel of your chart. To do this:

  1. With your chart view open, select ••• at the top of your database.

  2. Under Style, you can adjust the following:

    • Color: Choose a color palette for your chart.

    • More style options, which include:

      • Height: Choose from Small to Extra large.

      • Grid line: Choose whether to add a grid line to your horizontal or vertical axes.

      • Axis name: Choose whether to name your X or Y axes.

      • Data labels: In a bar or line chart, toggle this on to label your data points. In a donut chart, select this to choose how you want your data points to be labeled.

      • Smooth line: Toggle this on to make the line in your line chart curved instead of angular.

      • Gradient area: Toggle this on to fill the space under your line chart with a gradient.

      • Show value in center: Toggle this on to show the value in the middle of your donut chart.

      • Color by value: This option will only be visible for bar and donut charts whose color is not Auto or Colorful. Toggle this on to make your data points darker in color as the value increases.

      • Legend: Toggle this on to create a legend for your line or donut chart.

Open up a chart view and you can do the following:

  • Hover over elements of the chart to see labels.

  • Click on a category in the legend to hide groups.

  • Copy the link to the chart.

You can download your chart to share or use elsewhere. To do this:

  1. With your chart view open, select ••• at the top of your database.

  2. Select Save chart as....

  3. Customize the background of your chart. You can preview your chart as you do this.

  4. Select Copy as PNG, Download PNG, or Download SVG. Note that these options aren't currently available on the Android app.

Note: If you’re on a paid plan, you can choose not to include a background in your chart — this will also remove the Made with Notion watermark.

You can bring multiple charts together into a page, then click and drag them around to create a handy dashboard. Learn more about creating dashboards in this guide →

Everyone can try charts. If you’re on a Free plan, you can create one chart, and if you’re on a paid plan, you can create unlimited charts. Learn more about our plans and pricing here →

Note:

  • If you’re on a Free plan, you can delete your one free chart to create another.

  • If you’re on a Free plan and download a template that contains charts, you’ll only be able to see one of the charts in the template (as long as you haven’t already used up your free chart).


Give Feedback

Was this resource helpful?


Powered by Fruition