Hello everyone, welcome back to the Keep Productive YouTube channel
It is francesco here in today's video i'm gonna be passing over to William Nutt. Who runs
NuttLabs and they are basically a
notion consultancy, but they also do a
fantastic newsletter and resource called Notion VIP
Which is perfect for those who are building out their notion now, I actually checked out their product notion chance
Which has been on products home for a while
so in today's video i'm actually gonna pass over to will who's actually gonna dive into
The charts had to create one and how to embed one inside of your notion account
So thank you very much to Will coming on and I will pass over to will guys and I hope you have a fantastic
Weekend if you new here subscribe to both will and I i'll see you in a bit guys Cheers
Thanks so much Francesco, it's a pleasure to join you as Francesco mentioned
I'm William Nutt of nutt labs and we're an integrated digital strategy firm and notion consultancy based in New York
And I also run the website notion VIP where I publish tools and insights about all things
notion and among those tools is notion charts, which you can access at notion VIP slash charts and
Notion charts allows any user to create charts and embed them in their notion pages and those charts are styled and generated
Specifically for notions so that we've nicely into your pages content
so in this sample dashboard
you can see that we have a variety of different chart types and
these charts are going to use the same colors that you can use for your text and notion and
They're also interactive so you can hover over them to reveal additional
information
So until notion releases its API these charts are gonna pull their information
Dynamically from Google sheets and that means you can update the information easily and you can even automate it using Google sheets
Integrations, so let's take a look at how it works
the first step is preparing your Google sheet and
Within notion charts under the data range field
you're gonna have a link to some demo data and that demo data shows you just how to
structure your data for the various chart types
So you can see here that we have
Sample data for line charts bar and column charts pie and donut charts and then geo charts
So let's use the line chart data to create a line chart that showcases consulting income by month
With your data properly structured you want to ensure that your sheet is publicly accessible
We're gonna use notions API to accommodate private data. So in the meantime, you're not gonna want to use
notion charts for any sensitive information
So you'll click the share button at the top of the screen and you'll just ensure that anyone with the link can view
the document and
Then you want to copy your sheet ID and you'll do that
By grabbing this of characters between the d slash and the slash edit
So you'll copy that and you'll go back over into
notion charts and you'll paste it in the first field and
Then you need the sheet name or the tab name of your document in our case. That's data structures
and
Then you want the precise data range
So for our line chart that's going to be a three by B 15
And
Then you can customize your chart
so for the chart type ours is going to be a line chart which is the default and
Then you can choose light mode or dark mode and then you'll choose the formatting for your axes labels
so we're working with dates and
Currency so we're gonna choose our formatting occur accordingly and
Then you'll choose your colors as I mentioned
You can choose among the same colors that you use for your text and notion and for this chart of line chart
We're just going to have one color. Let's use that notion pink and
then the last step is to
Opt-in to the notion VIP newsletter
which of course I recommend and then you'll hit the make magic button and what that's going to do is it's going to generate a
special URL that you can copy-and-paste
That special URL and when you do that you'll have the option to create
embed
and
boom
There's your chart which you can resize and as you resize it to fit nicely within your content
You'll see the chart respond in real time. Now if this last step gives you any trouble
Be sure to use the notion
desktop app
Instead of the web app because that embed block can be a little finicky within the web app
But once you get the chart in place, it's going to display properly
everywhere and
That's notion charts. I'd love to see what you come up with using the tool
Feel free to pass along any of your creations on Twitter. My handles act William Nutt and
Thanks so much for tuning in to this quick dinner demo, and be sure to check out notion VIP for some
additional resources about notion