Notion Charts – Top 3 Ways to Visualize Data in Notion?

Suppose you’re running a business. And, you need to show some charts or graphs to your clients. Can you do that in Notion?

Or maybe you need to see how your sales are progressing each month.

Or perhaps, you want to turn your Google sheet data into a beautiful chart and show them on your Notion pages.

Can you do all of these?

In this post, I am going to show you 3 ways to add visual charts, graphs, and even diagrams right inside your Notion workspace.

So, let’s explore each way and become a Pro Notion user:

Notion charts to visualize Data in Notion

Embed Google Sheet

Embed Google Sheet

Have a large collection of data in a Google sheet?

Love to turn them into beautiful graphs or charts?

You can definitely do that with Notion Vip.

You can use any Google Sheet and turn it into embeddable charts.

You can create a Bar, Column, Pie, Line, Donut, and even a Map with your data.

And, you know what? These charts are perfectly optimized for Notion.

You might be thinking, isn’t it difficult to do that?

Absolutely not!

Let me show you how…

First, go to this link. And also open the Google sheet from which you want to use your data.

For this to work, at first, you need to make sure your Google sheet is accessible with a link.

To do that, just click the Share button and change Restricted to Anyone with the link can view.

Change the sharing option

Then, go to your Address Bar and copy the portion (both numbers and letters) between the /d/ and /edit. This is your Google Sheet Document ID.

Copy the Document ID

Now go back to Notion Vip and paste the Document ID in the first box.

Now, in the second box, type the name of your Sheet from which you want to showcase your data.

Then, you have to enter the Data Range. The easiest way to do that is to go to your Google sheet and click-n-drag the portion of data you want to use in your charts.

Now look at the top-left corner and you will see the Data Range. Just copy that and paste it into the 3rd Box.

Enter the Data Range
Connect the Google sheet

Now comes the fun part. You’ll get the option to customize your chart.

Chart customization options

You can customize them any way you like. Select the chart type, theme, axis formatting, even the colors of your chart.

Craft your pallet

After you’re satisfied with the style, click the Make Magic button and it will give you a link.

Now copy the link and paste it into any of your Notion pages and click Embed.

Notion chart

That’s it. Now you can show your data in a beautiful chart inside the Notion.

Hold on. I have a Pro Tip for you.

Would you love to use your Notion data to make charts and auto-update them as you change the data in Notion?

Well, you can do that too.

Just use automation tools like Zapier, Automate.io, or Integromat to pass the data from Notion to a Google Sheet. Create the chart using that Google Sheet as I already showed you.

Now, whenever you update any data in your Notion database, the chart will automatically be updated.

Here you go! Now you know how to show charts or graphs in your Notion workspace.

LucidChart

LucidChart

What if you need to create a custom chart or diagram and show that in Notion?

There is a way too.

You can use the LucidChart app. It’s a virtual whiteboard tool. You can draw here, create diagrams, flowcharts, use images, etc. You can create any custom shapes too. The only limit is your imagination.

After you’ve created a diagram or chart, you have to export that into a PDF document.

To do that, click the Share button. Go to Publish and click on Full Document (URL) to select Single Page (PDF/Image).

Now click the Publish Page button. Then look below it and under the Published Links, you will find the link to download it.

Sharing options

Then go to Notion and enter “/” and choose Embed PDF. Now all you have to do is to upload the PDF and voilà!

You have your charts embedded in your Notion page.

Whimsical

Whimsical

You are probably thinking, Lucidchart is great for creating charts. But, what if I need to edit it later on?

Do I need to export and embed the PDF every time I make a new change?

No, you don’t.

Here is another tool that is more powerful than Lucidchart. It auto-updates every time you make new changes.

On Whimsical too, you can make flowcharts, diagrams, mind maps, various shapes, and even add tables.

To add them to your Notion workspace, go to the top right section of the Whimsical document and click on the Lock button.

Under Anyone with a link, you will see an option – has no access. Click that and choose any option you prefer.

Whimsical sharing options

Then copy the link and go back to Notion. Now paste the link and click Embed Whimsical Board. Your entire Whimsical board will be visible here.

Embedding the Whimsical Board

You can zoom in or out, move across the board, and even edit it. Just click the Whimsical icon and it will be opened in your browser.

Now make any changes you want and the graph or diagrams will be updated in the Notion.

Isn’t it amazing?

From now on, you don’t have to worry about embedding the Charts every time you make a new change.

You’re welcome!

Bonus: Embed a Google Data Studio Report in Notion

 Embed a Google Data Studio Report in Notion

Like the other ones, you can also embed a Google Data Studio Report inside your Notion Workspace.

For this go to your report and click on the Share button (on the top right). Under Manage Access, Click Off-only specific people can access and from the drop-down menu click Anyone with the link can view.

Manage the access

Then go back and click the drop-down arrow beside the Share button and choose < > Embed Report. A window will pop up.

Embedding the report

Now click the Enable Embedding checkbox if it isn’t enabled. And, also click the Embed URL to get the link.

Embed URL

Now from the link box, copy the link and get back to your Notion.

Now type “/” and select Embed. Then paste the link and click Embed Link.

Notionchart embed option

And guess what? Your Google Data Studio Report is being embedded too inside your Notion workspace.

Beautiful, isn’t it?

Conclusion

Data is only a number. But a chart or diagram is a story.

Charts can say so much more than just written words. That’s why it’s better to incorporate them into your system.

But which tool or workflow should you choose?

It depends.

If you’ve to deal with loads of data, using Google Sheets will be the best option for you.

But if you need more control over your charts or diagrams, Lucidchart or Whimsical is more than perfect.

Love to have a beautiful and interactive dashboard? You can’t go wrong with Google Data Studio.

So, let us know which one you have gone for.