00:00Bismillahirrahmanirrahim. Assalamualaikum. Learning with Embror Zima, Khoosh Angeet.
00:04Today I will teach you that you can represent your chart in the way you can represent your data.
00:10Which you can represent your data in the way you can represent your chart in the way you can represent
00:14your chart.
00:16Let's go to computer screen and learn the chart in the way you can learn.
00:25This is the week table which we have in the last lecture in the last lecture.
00:28This is the chart which we have studied in the way we have learned from the chart.
00:29This is the chart which we have studied the chart, which we have studied the format and see the elements
00:35from which we can hide and hide.
00:38In this lecture we have set the charts to draw the data to look at the data.
00:47As you can see the charts, we can compare it to the data.
00:51We can compare it to the data.
00:58create create we press alt f1 this column chart draw
01:02shortcut is here we have column chart
01:07this chart title was done with our title
01:11and here we have January February sale and cost of goods sold
01:15here we go to change data
01:21we go to line chart
01:23we go to line chart
01:24we go to line chart
01:26we go to element
01:28add data label
01:30grid line
01:31primary major vertical
01:34we go to
01:36January February March
01:39top bottom
01:40we go to clear
01:42we go to add
01:43we go to
01:46pi chart
01:48pi chart
01:50pi chart
01:52pi chart
01:53we go to
01:53here we go to
01:58background
01:59legend
02:01we go to
02:05data bar
02:07we go to
02:11data label
02:12more options
02:13select
02:13data labels
02:14here we go to data
02:17options
02:17label contains
02:20value from cell
02:21we go to cell
02:24where we go to data
02:26cancel
02:29series name
02:30series name
02:31we go to
02:33we go to
02:35here
02:36we go to
02:39here
02:43pi chart
02:45single
02:46data
03:15data
03:17January
03:195209%
03:20this point
03:21difference
03:22is
03:229.1
03:269.2
03:269.3
03:27fraction
03:28we go to
03:319
03:368.3
03:412
03:429
03:429
03:439
03:439
03:449
03:449
03:449
03:449
03:449
03:449
03:459
03:45Quando separator, we will keep this in the middle of the past, February.
03:48Then, 5,000.
03:50Then, 9%.
03:51Then, we keep this separator and in the middle of the second half,
03:54this will not go away.
03:58As the initial line has to keep the ticker again.
04:00And as we will do, this is a period where we are going to split them.
04:06We will do new lines.
04:07In new lines, we will get our data disturbed by each one.
04:11Every one will be different from each one.
04:12The visibility is better from each one.
04:14but it's a little bit to keep it in order to keep it
04:18we will fill it in semicolon
04:22later, label positions
04:25center, if you want to keep it in the center
04:29and it's very congested
04:31inside end
04:32it's very congested
04:34because we have more than 12 months
04:37it's 1-2 months
04:38it's going to go
04:41outside end
04:42outside end
04:44it's better
04:46and best fit
04:47it's better
04:49but it's a symmetry
04:51in the entire direction
04:54number setting
04:55we don't need to do it
04:57which we have done
04:59we have already
05:02data label
05:03select
05:03control
05:04control
05:05b
05:06bolt
05:07or
05:07home
05:08home
05:09here
05:10we can
05:11bolt
05:11bolt
05:12here
05:13we can
05:13change
05:16type
05:17bar chart
05:18here
05:19bar
05:20here
05:49here
05:50one problem
05:51we have
05:51we have
05:52months
05:53we have
05:53January
05:54February
05:54March
05:55April
05:55May
05:56June
05:56July
05:56we have
05:57start
05:57here
05:59we have
06:00copy
06:01here
06:02we have
06:02paste
06:03years
06:072014
06:102015
06:11we have
06:132015
06:14We have
06:15us
06:15to
06:16run
06:16now
06:27then
06:28here
06:29here
06:31we have
06:31this
06:32here
06:33here
06:33and sales
06:35and here is another word
06:37horizontally access bar
06:391,2,3,4,5,6
06:41which is written here
06:43these two problems
06:45for this
06:47manually
06:48undo
06:50undo
06:51manually
06:53here
06:57insert
06:58insert
06:58insert
06:59insert
07:01this
07:03another
07:05one,2,3
07:07here
07:09select data
07:11here
07:13legend entries
07:14series
07:17here
07:19horizontal
07:20axis
07:211,2,3,4,5
07:24edit
07:24select
07:27range
07:29select
07:30range
07:30and
07:31this
07:32is
07:33ok
07:34here
07:34data
07:35as it is
08:17select
08:18one
08:18one
08:18one
08:18one
08:18one
08:18one
08:18two
08:18one
08:18one
08:18one
08:18Okay, so this is our data from 2025 to come.
08:25This is the common problem that we have to do with figures.
08:31Select here, here, here, here, here.
08:36We have to start our data from heading.
08:38We have to start our chart.
08:41We have to copy and copy.
08:44We should copy the product from MS Word.
08:49We will paste it and we will paste it.
08:51We will paste it here and we will paste it.
08:54We will paste it here and put it here for a small amount.
08:55And here we will create an option.
08:58Let's close the data out.
09:03Now we have to go to the slide and add this.
09:06We also have to add this.
09:10Then we paste it in and create it.
09:13We will paste it.
09:16We can select this chart.
09:18Now we can select the chart design chart format.
09:22This chart design means all the changes.
09:23We can select this chart.
09:26We can select here data label.
09:28We can select the data label.
09:29This is the options we can select here.
09:33We can double click here.
09:36Then we will open it for right-and-click.
09:38we can choose, we can change all the values. Now, we can change everything. We want to
09:45change the size of 9. We can select the data label. We can select each single. We can
09:53select each other. We have to select each other and we can select each other. We will
09:59do this again. We will also click on the data. We will also click on the data. We will
10:05we can do this with our powerpoint
10:09here we can create a new presentation
10:11we can create a new design
10:15we can create this without save
10:17close
10:19so this is our lecture
10:22chart
10:23if you have any confusion
10:25you want to share my comment
10:26you will have a lot of ideas
10:29we will meet in the next lecture
10:31Allah Hafiz
Comments