00:00In the name of Allah, As-Salaam-Alaikum
00:03Learning with Em-Dorzima, Khusham-Deed
00:05In this lecture, I will teach you Pivot Chart
00:09Pivot Chart and Simple Chart are flexible
00:14and Simple Chart is a constant
00:18Simple Chart is fixed data
00:21but Pivot Chart is summarized data
00:25There are many variables that you can modify
00:30Let's go to computer screen and learn Pivot Chart
00:40Here we go to computer screen
00:43This is our table
00:46Pivot Chart
00:48Pivot Chart
00:50Pivot Chart
00:52There are two options
00:54We can select table or range
00:56We have already selected
00:58The other option is New Worksheet
01:00We want to select chart
01:02We want to select existing
01:03We want to select existing
01:04We want to select this option
01:07We want to select chart
01:09We want to select here
01:10Okay
01:11Blank Chart
01:12Open
01:13We want to show data
01:14We want to select region
01:16We want to access
01:18We want to select sales
01:21Some values
01:22Central
01:23North
01:24South
01:25This is near
01:26Sal
01:2715000
01:2820100
01:29This is
01:30near range
01:31We are set
01:32It's near region
01:33And here
01:34We can select region
01:36By region
01:37We can select regions
01:38Or here
01:39As we can select names
01:40From categories
01:41To determine
01:42What we source
01:43What we are
01:44Table
01:45We can select
01:46North
01:47South
01:48Clear
01:49How we can select
01:50That is why it's a good deal.
01:53And, with this cost of good sold development,
01:55I will add this value as well as well.
01:57It's a good deal.
01:58So, cost of good sold,
02:01We will give our sales,
02:02and we can get the sales.
02:07We can accept the of cash,
02:08but the cost of good sold.
02:12We will have sales.
02:16It's a good sales price.
02:18this is sales and cost of goods here we have margin clearly
02:23we have to know how much margin available is available and filter
02:27if we have date we have to apply date we have to change our date
02:33or here we can change our date 27th
02:40ok this is just the kashif data which is 5000 plus sales
02:47and the cost of goods sold.
02:51In addition, you can change the elements from the chart.
02:57You can click and activate the options.
03:02The second option is chart styles.
03:05If you want style, you can keep your requirements.
03:10You can use style.
03:12There are options in Microsoft Excel.
03:16If you like color, you will see the options.
03:20In the option, you can select the scheme.
03:23You can start with the left.
03:25We have the values in sales and cost of goods sold.
03:31You can select two options.
03:33You can choose blue and orange,
03:35and you can select the option.
03:36You can select the scheme.
03:38I hope that you will understand.
03:43If you understand any confusion in the comment box, please share it in the comments.
03:48We'll see you in the next lecture.
03:51Allah Hafiz.
Comments