0:02 okay let's learn how to create a
0:04 different types of charts first have a
0:07 look we have a really simple table which
0:09 consists of fruits theater and their
0:12 prices in order to create a chart first
0:15 we have to highlight our table data go
0:17 for the insert select the chart so by
0:20 default if your table consists of only
0:22 one there as in our case which is on the
0:25 price column so your chart will be like
0:28 pie charts let's just start editing the
0:31 appearance of this chart on the top side
0:33 here you can see the title of your
0:37 charts let's type Here Fruit prices in 2022
0:42 after that let's have a look this chart
0:45 editors part which consists of two
0:46 sections which are set up and
0:49 customizing inside of setup you can see
0:52 chart type I'm going to change this pie
0:55 chart into 3D pie chart okay you can
0:58 also easily change this pie chart like a
1:00 column based charts bar chart or even
1:03 like line charts okay and the next step
1:06 here we can see the customizing in this
1:08 customizing let's have a look all this
1:11 labeled parts first let me open up the
1:14 chart Style inside of chart Style you
1:15 can change the background color let's
1:18 apply the one color like this you can
1:21 also maximize the items inside and after
1:24 that here comes the pie chart instead of
1:27 pie chart you can add some donut hole if
1:30 I was select here 25 you will see it
1:32 like this small hole and then what else
1:34 we can do we can also label our slices
1:37 let's click here I'm going to select the
1:39 value so now on every slice I can see
1:43 the price of give even fruits so you can
1:46 also convert all these stingy based
1:48 values into percentage actually it
1:51 depends on how you're going to visualize
1:53 your data okay this is all about the
1:57 style of your text for example let me
2:00 say this part so as you see the style of
2:03 the step also has changed next one is
2:06 the pie slices so depending on your
2:09 fruit type you can also change their
2:12 slice colors for example the first one
2:14 is the Apple let's say Apple's color
2:17 will be red one the second one is the TV
2:20 the color will be green one and the last
2:22 one the banana the color will be like
2:24 yellow so then here we have a distance
2:26 from the sensor if you're going to
2:28 visualize or even just analyze only one
2:30 fruit you can make a distance from the
2:32 center let's say I'm going to do it for
2:36 the Apple part again 25 okay and then
2:38 the last one is the legend section
2:41 Legend it means where you have to locate
2:43 all your fruit theaters so by default
2:45 they are on the bottom side but you can
2:48 easily move them to the left side to the
2:50 right side or even to the top sides next
2:52 one let's have a look we have another
2:55 table which illustrates the students
2:57 grades for test number one and test
3:00 number two again let's highlight our
3:02 table go inside of insert select the chart
3:04 chart
3:07 okay here we are now we can see the bar
3:09 chart or it's also called column charts
3:11 so the first step that I'm going to do
3:13 is to rename it let's say it is a student's
3:14 student's Gray
3:15 Gray
3:17 so now I'm going to go inside of
3:19 customizing let's have a look at the
3:22 chart Style let's make it 3D column
3:25 charts okay again you can change either
3:27 the background color it's up to you how
3:29 to visualize later
3:32 okay the next one we can see here chart
3:35 exist titles again I already have a
3:37 chart title if I look at the horizontal
3:40 one it says just a student so I'm going
3:42 to rename it like students me
3:44 me
3:46 okay so all my changes that I did here
3:48 is already available here you can also
3:50 rename them by just double clicking this
3:54 section and uh here vertically we can
3:57 see the numbers let's give a title for
4:00 this vertical numbers I'm going to click
4:03 this vertical axis let's type here Grace
4:05 Grace
4:10 Auto 100 the text that I have typed here
4:14 is already available in this my uh chart
4:17 section okay what else I can do let's go
4:19 for the series section and let's uh
4:22 click this data labels to label all the
4:25 students grades for the both tests in
4:27 the same manner you can also change the
4:29 color for this given columns too and
4:32 also one more thing if I will change the
4:35 grid for one student so then my column
4:37 charts also will be changed because
4:39 these two are connected with each other
4:42 and at the same time you have to make
4:45 sure that your data on this chart is
4:47 clear so which means the audience should
4:50 understand your chart without your table
4:52 there okay so okay here I can see the
4:54 students create their names and they
4:57 test both tasks so it's really readable
4:59 clear and understandable
5:01 so the next part here we have another
5:04 table which illustrates the number of
5:06 courses and the year here on the top
5:09 side so inside of the Sable we can see
5:11 just random numbers actually these
5:13 numbers mean the number of students that
5:15 have registered for this indicated
5:18 courses in this years so let's say I'm
5:21 going to highlight my whole table right
5:23 now let's go for the insert select the
5:25 chart again let's change this column
5:28 chart like light chart okay I can see
5:30 here the courses on the bottom side this
5:32 is the number of students so here again
5:34 by double clicking you can rename them
5:37 and also add here vertical line let's
5:39 say I'm going to create a column chart
5:41 for all these indicated courses but only
5:44 for the last year okay so you have to
5:46 highlight these two columns by pressing
5:47 the control button let's go for the
5:50 insert okay here we are I can see here
5:51 the courses from Massachusetts to
5:54 chemistry and vertically we can see here
5:57 that 2022 so now let's say my column
5:59 chart should illustrate the number of
6:02 students only for English course but all
6:05 in all these indicated years again I am
6:07 going to highlight this in my header
6:09 section let's highlight this English
6:12 part let's go for the insert and select
6:14 the chart okay my this column chart
6:19 illustrates not only English course but
6:22 also ICT and biology courses so even if
6:26 I have highlighted on the English row it
6:29 also illustrates the data above English
6:32 courses too like ICT course biology
6:35 courses so let's fix this problem okay
6:38 again I'm going to go inside of setup
6:41 section right now on the bottom side I
6:43 mean the horizontally I can see all my
6:46 three courses and the 12th side we can
6:49 see all these ears with different colors
6:52 so in the serious part we also can see
6:55 all these years so now inside of series
6:58 section if I could see the courses then
7:01 it will be really easy for me to delete
7:03 the extra ones and leave out all the
7:06 English course in order to locate all
7:08 those courses instead of section first
7:10 thing that they have to do is to click
7:13 this part switch the order of rows and
7:16 columns let's click it let's go inside
7:18 of ICT click the three dots and remove
7:21 it biology remove it so now I can see
7:24 all my English course and just easily
7:26 rename it like English
7:30 versus years yes years or you can also
7:31 type the number of reduced to the
7:34 students in English course between and
