0:00
Hey everybody. In this video tutorial,
0:01
I'm going to show you how to create and
0:03
customize charts in a Google Sheets
0:06
spreadsheet. Right? So, as you can see,
0:07
we have created this nice uh pie chart
0:09
here using this uh project management
0:12
table we have with project names and
0:15
budget and we can see the share of a
0:17
specific project in the total budget.
0:19
So, how you can do the same? So, how you
0:21
can create charts and customize them
0:24
later. The best practice is to first
0:26
create the data set that you want to
0:28
create a chart from. And once you have
0:30
the data set, you have to select the
0:32
data set you want to show in the chart.
0:34
So let's say in this example, we want to
0:37
show the budget of specific projects in
0:39
a nice chart. So once you selected the
0:42
data, all you have to do is click on
0:44
insert and select chart from this
0:46
drop-down list. And as you can see by
0:48
default Google Sheets is clever enough
0:51
to know that we can use a pie chart
0:54
here. But if you want to use another
0:56
chart type you can select that here. So
0:59
we can have a bar chart column chart
1:01
combo chart then you have to add more
1:03
data. But let's keep it now with pie
1:06
chart. Then you can add uh labels here
1:10
as you can see. So here we can change
1:12
the labels as you can see but this makes
1:15
more sense with the project name and
1:17
then you can not only change the values
1:19
here but you can also customize the
1:21
chart. So you have a lot of
1:23
customization options. I'm not going to
1:25
go over all of them. You can change the
1:27
legend formatting the chart axis and
1:30
titles. So you can change title text
1:33
here. So as you can see the chart title
1:35
has been updated with this. You can
1:38
change the font of that. You can change
1:40
the pie slices of a specific project in
1:44
this example or you can change the
1:46
complete style, the border color and the
1:49
chart style as well like so with the
1:52
background color. So as you can see you
1:54
have many customization option here but
1:56
all this how you can create and
1:58
customize charts in a Google sheet
2:00
spreadsheet. I hope you found this
2:03
tutorial useful. If you want to get
2:04
access to our complete Google Sheets
2:07
function database or our Google Sheets
2:09
shortcut keys ebook for free and other
2:12
Google Sheets resources and Google
2:14
Sheets templates, then make sure to
2:16
check the links in the description
2:17
below. Also, if you want to learn more
2:19
about how to use Google Sheets, make
2:21
sure to check out our YouTube channel
2:23
and playlists where we have a ton of
2:24
tutorials and more Google Sheets
2:26
tutorials are coming up. So, also make
![Video thumbnail for How To Create And Customize Charts In Google Sheets Spreadsheet? [in 2025]](https://video-meta.open.video/resized-posters/9NCt0BVJlA2/res640.webp?cb=1)
