- Notion Business Systems
- Posts
- 7 Tips For Making Better Notion Chartsđ
7 Tips For Making Better Notion Chartsđ
Charts have a lot of functionality packed into them, but not everyone is making the most of them...
7 Tips For Better Notion Charts đ
Notion Charts have been out for a while now. If youâre still struggling to get the hang of them, hopefully these 7 tips will help unlock some things for you.
Todayâs newsletter in bullet points:
7 pro tips for better Notion Charts;
A new tutorial video walking through these tips and examples; and
Landmark Lifetime is having a significant sale this weekâif youâve had your eye on it, nowâs a good time to lock it in.
7 Tips For Notion Charts
Use 1 database with many properties: One of the most common mistakes/issues I see people making when working with Notion charts is trying to combine data across multiple databases.
They have an expenses database, a revenue database, and another database trying to connect the two⌠Unfortunately, Notion charts arenât really friendly to pulling data from multiple sources (yet). And so the best practice, Iâve found, is to think about a larger category for your databases, then add tags and properties to filter your data and charts from there.
So, for example, if you wanted to create a Profit-Loss chart, you could achieve this with Notion charts by having:
- 1 database called âTransactionsâ;
- A âTypeâ property with revenue and expenses;
- A formula to turn âexpenseâ items into negative values; and
- Simply use Notion chartsâ native âSumâ property to calculate the positive - negative values in your chart for you đInclude a Date property by default: There are a couple of reasons to do this. Firstly, most charts will benefit from having some time-series component to themâtracking revenue month to month, for exampleâand so youâre going to need that information anyway.
But also because Notion has packed a bunch of neat features into their native Date property that will let you combine values, filter elements and and work with charts in really useful ways.
So, donât just add a text property and write âJan. 5thâ. Make sure you use Notionâs native Date property and reap the benefits.Right type for the right data: Hereâs the quick breakdown:
đ Vertical Bar Charts & Line Charts: Best when you have a Time or Date element
đŠ Donut Chart: Best when you have a no time element, but want to break up a larger sum into its respective categories;
âĄď¸ Horizontal Bar Chart: Great for tracking progress or counts, again when there is no date element needed in the visualization (e.g. Projects & Tasks).Duplicate your chart views: Once you have your database setup and youâve configured your first chart, the fastest way to create new charts is to simply hit âDuplicateâ on the existing view. Donât waste time reconfiguring every chart, just duplicate an existing chart đ¤ˇ
Use filters: Best filters to use with charts:
- Categories: Filter for a specific tag or type of item;
- Date: Filter by relative dates to capture items, say, in the âlast 30 daysâ;
- Status: Filter out items that are already completed, or filter for items that are âOverdueâ;
- Size: Filter for items that meet a certain size condition, for example, filter to only show revenue items that are > $1000.Make it simple to add new data: In the video, I show how you can add Notion buttons to automate the process of adding new items to a selected database from anywhere in your workspace. But you can also simply use filtered table views to make it easier to add new items into the correct categories/date periods.
Style it simply: Avoid overdoing it with Notionâs colorful charts. You can use color to signal certain things about what each chart represents. Whether thatâs using green and red for Revenue and Expenses respectively, or using a specific color for a department of the business (like âOrangeâ for content, etc.). You can often communicate a lot of information very quickly by simply making better use of color in your chartsâand not overwhelming the workspace with multi-colored charts everywhere! đ
And thatâs it. Take a look at the video for more details, and I hope you find these tips useful!
And as mentioned at the top, Landmark Lifetime is currently on a significant sale. If youâd like to secure it at this current reduced price, nowâs the time :)
Best,
Gerrard
Founder @landmarklabs.co