In this tutorial, I'll teach you how to create, format, and customize charts in Microsoft Excel and Word with this step-by-step guide. Perfect for beginners, this video covers everything you need to know about using charts for data visualization. Boost your MS Office skills today!
Keywords of this lecture is given below;
Charts in MS Excel
How to create charts in MS Excel
Data visualization in Microsoft Excel with Charts
MS Excel chart tutorial
Customize charts in MS Excel
Tips for better charts in MS Excel
Formatting of each elements of Chart
Please like the video, subscribe to my channel, and press the Bell Icon to get in touch with new tutorial videos. Don't forget to share with your friends as well.
Through my Channel "Learning with M dot Zee" your go-to destination for mastering Microsoft Office and boosting your productivity.
Microsoft Word Tutoring
Leave a Comment if you have questions, suggestions, or queries.
#tutorial
#computerbasics
#learningwithmdotzee
#learningcomputer
#learningmsoffice
#learning
#tutoring
#microsoft
# word #excel
#tutorialvideo
#tutoring
#review
#printing
#beginners
#beginner
#layout
#sumformula
#sumfunction
#sum
#numbering
#numbertable
#table
#tableinexcel
#cellstyles
#cell #style #styles
#pivot #pivot_table #pivottable
#pivotchart
#chart
Keywords of this lecture is given below;
Charts in MS Excel
How to create charts in MS Excel
Data visualization in Microsoft Excel with Charts
MS Excel chart tutorial
Customize charts in MS Excel
Tips for better charts in MS Excel
Formatting of each elements of Chart
Please like the video, subscribe to my channel, and press the Bell Icon to get in touch with new tutorial videos. Don't forget to share with your friends as well.
Through my Channel "Learning with M dot Zee" your go-to destination for mastering Microsoft Office and boosting your productivity.
Microsoft Word Tutoring
Leave a Comment if you have questions, suggestions, or queries.
#tutorial
#computerbasics
#learningwithmdotzee
#learningcomputer
#learningmsoffice
#learning
#tutoring
#microsoft
# word #excel
#tutorialvideo
#tutoring
#review
#printing
#beginners
#beginner
#layout
#sumformula
#sumfunction
#sum
#numbering
#numbertable
#table
#tableinexcel
#cellstyles
#cell #style #styles
#pivot #pivot_table #pivottable
#pivotchart
#chart
Category
📚
LearningTranscript
00:00سماللہ الرحمن الرحیم السلام علیکم learning down زیدی خوش آمدید
00:05کنار جب اس مدد 원قر میں آپ کو اس کو سکھا ہوں گا چارٹ کے بارے میں
00:08کہ آپ مددation کے مددتے اپنے data کو ویجولی کس طرح present
00:11کر سکتے ہیں چارٹ سے مختلف settings بتاؤں گا جو آپ نےada
00:15بہت اچھے انداز میں presentable بنا سکتے ہیں چلئے آئیے
00:19چلتے ہیں computer screen اور سیکھتے ہیں جس آئے میں
00:26کمپیٹر Advance Perdition
00:27Yes, so we are going to computer screen.
00:29This is a table where there are months and sales.
00:35We want to show it in our chart.
00:39We click on this table.
00:41Then we go to insert.
00:43In the tab, charts,
00:47the first option is recommended charts.
00:51There are predefined options.
00:53You can create a chart.
00:55There are details of the different points.
01:07We can create a chart.
01:11Here we can cancel the chart.
01:15We can select the charts,
01:19the line, the chart chart chart chart chart chart chart.
01:23Here we go to this button and click on the other portion of the button.
01:27Recommended and all chart.
01:30Here we go to the column.
01:32The first option is column.
01:34Column is two options.
01:36Here we go to January and February.
01:38The color is shown here.
01:40The color is shown here.
01:43Column is also shown here.
01:45There are two options.
01:47Column is also shown here.
01:493D style.
01:52Here we go to the column.
01:55Here we go.
01:57Line, pie, chart, bar chart, areas.
02:00Here we go to column.
02:02Here we go to the column.
02:05Here we go to sales.
02:08Here we go to select.
02:10Here we go to OK.
02:12OK.
02:13Here we go to the chart.
02:15Here we go to drag.
02:17Here we go.
02:19Here we go.
02:21Visibility is clear.
02:24Here we go.
02:25Now we go to chart.
02:27Chart parts.
02:28What are the parts?
02:29This is the selection.
02:31This is the chart.
02:33This is the area.
02:34This is the sales.
02:36This is the vertical axis.
02:39This is January, February, March.
02:42This is the horizontal axis.
02:44This is the selection.
02:46This is the plot area.
02:48This is the plot area.
02:49This is the bars.
02:51This is the series.
02:52This is the plot area.
02:54This is the lines.
02:56This is the vertical major grid lines.
02:58This is the lines.
02:59When we apply the options.
03:01When we apply the settings.
03:02This is the settings.
03:03In the dimensions we have minor grid lines.
03:05There are small lines.
03:06But these are major lines.
03:08These lines are the major lines.
03:09These points have the same.
03:11From 2000, 2000, 2000, 3000.
03:13Here we go from the line.
03:14This is basically.
03:15Here we go to chart details.
03:16Chart itself.
03:17The chart itself itself.
03:19This is the chart design and format.
03:23Chart itself.
03:24We will select a few properties.
03:28We will double click on Shortcut.
03:31We will select the chart and properties.
03:35We will double click.
03:38Formit Chart Area.
03:40We'll cross and drag it.
03:43We will click on Formit Data Series.
03:48We will select Formit Access.
03:52We will select this, and we will select the Formit Access.
03:56We will select the Grade Lines and Formit Major Grade Lines.
04:00We will double click on this chart.
04:05We will give the options.
04:07We will give the options.
04:09Here we will fill colors.
04:12We will select the automatic.
04:14We will select the automatic color.
04:18We will select no fill colors.
04:20The content of this one will be shown.
04:24In the chart, we can also select solid color.
04:31Gradient fill also groupe.
04:34We can change two colors.
04:37The style of gradient color is here.
04:39We change the variety color.
04:41The center of dark will be light.
04:43We can change the style in the dark.
04:47Here we can also color.
04:49We can change the position. Linear, Radial, Gradient, we can change the direction. Left-to-right, Right-to-left, Top-to-bottom, which we can change the style of gradient.
05:02We can change the axis of 90 degrees. We want to change the color. We want to change the color.
05:18We can change the axis of the blue. We can change the color. This is the color we can change the color.
05:37We can change the color. We can change the color.
05:43white
05:45green
05:47green
05:49yellow
05:53shade
05:55yellow
05:57yellow
05:59yellow
06:01shade
06:03yellow
06:05shade
06:07white
06:09shade
06:11yellow
06:13yellow
06:15brown
06:17green
06:19yellow
06:21yellow
06:25yellow
06:27yellow
06:29yellow
06:31green
06:33yellow
06:35yellow
06:37green
06:39select
06:49colors
06:50sprechen
06:55black
06:58A function was filled.
06:59If we move on, we can insert the picture.
07:02We also want to insert the picture.
07:04We want to insert the picture and we want to turn the logo.
07:07Title is very small.
07:08We can also make the background.
07:11We can file from our system.
07:14That is what we want to access.
07:16After this, we will go to pattern fill.
07:19Here we go.
07:20This is our pattern.
07:22Title is available on the background.
07:26We want to make pattern.
07:28Next option is automatic.
07:32This is our fill option.
07:34This is the border option.
07:36Border is our automatic option.
07:38We want to click on the border.
07:40We want to click on the border.
07:42We want to go back to title.
07:44We want to solid line.
07:46We want to look at lines.
07:48Then we want to go line.
07:50We want to change the line.
07:52We want to change the color.
07:54As well as two, we want to be able to divide from the border.
08:02We want to click on this border.
08:04In this way, we can change the line
08:06So it will set up to have a sky.
08:08So we have to Laurent uniform governing.
08:10This is a wunderbarство.
08:12So we need to decrease the data.
08:14If you have my begin use max.
08:16This is the roundusu enforced.
08:18So, we need to gain a even morekorbrem vrais.
08:20This is the primary line of resolution.
08:22arrows if we can add to this, we don't have arrows, so we can start and end point deactivate.
08:29This option is a good option. The other option is shadow.
08:32In shadow, we can also give our title to the shade if we want to give it.
08:37This is the style of style, which we can give it, we can give it to the shade.
08:42This is the shade we want to change. We want to change the shade.
08:45We want to change the shade. We want to change the shade.
08:48Transparency's, we can grow or get bigger or lower.
08:52The size we can grow, we can grow.
08:57This is the size we can grow, it is the size we can grow.
09:01Blur we can grow, we can grow.
09:07Angle we can grow.
09:10Distance, text box is the way to keep it.
09:15Shadow of the glow option is the option.
09:17So, this will be a glow.
09:21If we can add a color, we can select this color.
09:24The shade can be done with the shade.
09:26If we finish it, then we can check it out.
09:30This shade can be done with the shade.
09:33Shade can be done with glow.
09:35Glow can be small size.
09:38We can put it here.
09:40We can add a little bit more.
09:43Transparency can be more options.
09:47soft edges
09:49we can make the edges soft
09:51we can make the edges
09:53so we can make the settings
09:55we want to make the settings
09:57because I am going to take it
09:59so we can make the effect so easy
10:01we can make the size
10:03soft edges
10:05we can make it more
10:07add
10:084 3 2 0 1
10:10soft edges
10:11text fill
10:13text fill
10:14solid fill
10:15gradient fill
10:16em que is put in like that
10:19gradeidian set
10:20the color was over
10:21picture
10:23text
10:24text
10:26text
10:27text
10:29text
10:30text
10:31text
10:32text
10:33text
10:35text
10:36text
10:37text
10:40text
10:41text
10:43text
10:44text
10:45we will keep in text in text
10:47transparency
10:49text outline
10:51solid line
10:53this is the same way we can change
10:55text shadow colors
10:57text
10:593D glow
11:01options
11:03text box
11:05bottom
11:07text box
11:09this is the chart area
11:11we have selected
11:13menu open
11:15chart fill
11:17pattern fill
11:19pattern fill
11:21chart background
11:23pattern
11:25pattern
11:27pattern
11:29pattern
11:31picture
11:33texture
11:35texture
11:37texture
11:39texture
11:41texture
11:42mouse
11:43image
11:44image
11:46texture
11:48design
11:50Select from file
11:52location
11:54image
11:56texture
11:58logo
12:00image
12:02texture
12:04texture
12:05texture
12:06texture
12:08left
12:090%
12:10We will add a percentage of this one.
12:13We will add this one.
12:15We will add this one.
12:18This means that you have offset left.
12:21This one can see the percentage of this one.
12:26Because our picture was going to be oval.
12:29So we have this way to get our picture.
12:33And we will add this one.
12:37We will keep this one.
12:3956 है हम राइट से 56 बना देते हैं इसको 56% तो हमारा लोगो जो है वो लेफ्ट पे आ जाएगा क्योंकि वो राइट से उसका आफसेट हो गया राइट पे लोगों को आगे जाने नहीं देगा इसी दर हम टॉप और बॉटम भी कर सकते हैं या अगर हम बॉटम पे भी आफसेट
13:09राइट से भी इसका आफसेट हम और कम कर देंगे यह बन गया और इस पूरे 75 को उठा के हम यहां पे 0 करेंगे इसको हम लेफ्ट पे 75% हम कर देंगे तो हमारा लोगों यह राइट पे शो हो जाएगा इस तरीके से हम इसकी मूवमेट भी कर सकते हैं और लेफ्ट साइट से
13:39लाइट थी बॉर्डर हमारा पॉइंट 75 है इसको हम करते हैं थ्री लाइन स्टाइल हमारी
13:44इसको हम क्लोज ही कर देते हैं फिल के आप्शन को यह बॉर्डर के आप्शन आगे सॉलिड लाइन है थ्री पॉइंट पे आगे ट्रांस्पिरिंसी जिरो रखी हुए कलर इसको हम यह ब्लू कर देते हैं यह टार्क हो गया लाइट कलर थै इस वजह से इवेट इसकी यह हो �
14:14क्रेस कर देते हैं यह हमारी लाइन आगे डबल और बलके इसको मैं डैश यह डबल यह रहने देते हैं इसको यहां से हम टाइप कर देते हैं इसकी डैश डैश के भी बजाए हम इसको यह लंबी लाइन कर देते हैं क्यूंकि मैंने आपको वह सॉफ्ट आइच वह उन चीज
14:44we have to do solid line
14:46we have to do single line
14:48we have to do dashes
14:50this option was cap type
14:52here we have to do
14:54straight
14:56this is cap
14:58we will do flat
15:00square
15:02square
15:04square will be straight
15:06round
15:08we will do rounded shape
15:10we will do flat
15:12we will do flat
15:14we will do
15:16we will move
15:18we will do
15:20second option
15:22corners mode
15:24here
15:26round
15:28we will do
15:30we will do
15:32round
15:34round
15:36round
15:38round
15:40round
15:42round
15:44round
15:46we will do
15:48round
15:50we will do
15:52you will do
15:54round
15:56circle
15:57we will do
15:58it
15:59this is not much visible
16:00in presentations
16:02we need to see these things
16:04we need to show you
16:06at the end point
16:08my goal was to explain
16:10the border is full
16:12the next option is the same
16:14shade, glow, soft edges
16:16here is the 3D
16:18we need to do 3D
16:20we need to do 3D
16:22we need to fix the border
16:24we need to do 3D
16:26we need to do 5D
16:28we need to do border
16:30we need to do 3D options
16:32first we need to fill color
16:34we need to do automatic
16:36here we need to change our 3D options
16:38here we need to change our
16:40shade
16:42we need to click
16:44we need to do
16:46here we need to do
16:48width height
16:50bottom
16:52we need to select
16:54top
16:56we need to
16:58we need to change the
17:00bottom
17:01and this material
17:02we need to apply
17:04we need to do this
17:06we need to select this
17:08this we need to do
17:09we need to zoom
17:10this we need to
17:12top level
17:13we need to do this
17:15we need to add
17:16this we need to do
17:17this we need to do
17:183D effects
17:19on each side
17:203D effects
17:21through this
17:23to create a new affiliate with the app.
17:29This should be information about your channel.
17:31I will see how this will come up with a full point of view.
17:35I see what happens with the app.
17:37We have this data set up.
17:40The app is a full point.
17:41The app is very close.
17:43We can see how it 운영時 is.
17:46It looks like the app will change.
17:48The app will show the app.
17:49I will show the app and the app will show the app.
17:52top wallie
17:53go ziyadah highlight
17:53ka raha material
17:54peh a jatay
17:55ya
17:56is ke saab se
17:57is ki
17:57joh setting
17:58lightner
17:58special effect
17:59ya bilkul state
18:00ya bilkul
18:01ya eek
18:01khakha sa bana dhega
18:02ya is kisem
18:03ki moklif options
18:04is peh apply
18:05ka raga
18:05ya
18:06ya
18:07ya
18:07ya
18:07ya
18:07ya
18:07ya
18:08ya
18:08ya
18:08ya
18:09ya
18:09ya
18:11ya
18:11ya
18:13ya
18:13ya
18:14ya
18:14ya
18:15ya
18:15ya
18:16ya
18:17ya
18:18ya
18:19ya
18:20ya
18:21ya
18:22ya
18:22ya
18:22ya
18:22ya
18:22ya
18:22ya
18:22ya
18:23ya
18:23ya
18:23ya
18:24ya
18:24ya
18:24ya
18:25ya
18:25ya
18:25ya
18:26ya
18:26ya
18:26ya
18:27ya
18:27ya
18:27ya
18:27ya
18:28ya
18:28ya
18:29ya
18:29ya
18:29ya
18:30ya
18:30ya
18:31ya
18:31ya
18:32ya
18:33ya
18:33ya
18:34ya
18:35ya
18:35ya
18:36ya
18:37ya
18:38ya
18:39ya
18:39ya
18:40ya
18:41ya
18:42ya
18:43ya
18:44ya
18:45ya
18:46ya
18:47ya
18:48ya
18:49ya
18:50ya
18:51ya
18:52is
18:54we
18:56can
18:58do
19:00we
19:02can
19:04do
19:06do
19:08we
19:10will
19:12access
19:12access
19:14primary horizontal
19:16this
19:17is
19:17vertical
19:20more options
19:23more options
19:24more options
19:26horizontal
19:27glow
19:30fill color
19:32fill color
19:32fill color
19:36fill color
19:36gradient
19:39will come in this kind of option.
19:41You can put this option on automatic.
19:43We will keep this option.
19:45We will keep this option.
19:47On this, we will go to elements.
19:49There is a access title.
19:51Now, we will check the sale.
19:53We will check the access title.
19:55We will check the word.
19:57We will put something to edit.
19:59We will put a month here.
20:01Months.
20:03Months.
20:05We will put sales here.
20:07Sales will be written.
20:09We will check them.
20:11Uncheck them.
20:13Chart title.
20:15Chart title.
20:17Chart title.
20:19Access title.
20:21This is done.
20:23Data labels.
20:25Data labels.
20:27Data labels.
20:29Data table.
20:31Data table.
20:33Data table.
20:35Law,
20:38Thumbna.
20:39Sudscreen.
20:41Data label.
20:45Data label.
20:47isняя темa.
20:49We will go and see.
20:51Data label.
20:53Data label.
20:55Data label.
20:57Data label.
20:59Data label.
21:01Data label.
21:03so now this is small lines
21:05now this is 5000 and 6000
21:07between 200, 400, 600
21:09200,000
21:11200 lines
21:13so this is small lines
21:15we have more clarity
21:21we have to start
21:23legends
21:25if we want to mention
21:27here
21:29months
21:31we can add
21:33legends
21:35we can set up
21:37top
21:39bottom
21:41more options
21:43we can set up
21:45data table
21:47data label
21:49legends
21:51left
21:53bottom
21:55bottom
21:57more options
21:59we can set up
22:01trending lines
22:03we can set up
22:05this
22:07we can set up
22:09this
22:11element
22:13we can set up
22:15here
22:17we can set up
22:19here
22:21we can set up
22:23this
22:25we can set up
22:27this
22:29color
22:31we can set up
22:33this
22:35we can set up
22:37this
22:39colors
22:41we can set up
22:43right
22:45now
22:47we can set up
22:49this
22:51we can set up
22:53this
22:55we can set up
22:57here
22:59we can set up
23:13we can set up
23:15we can set up
23:17If we want to keep our data, we can show it.
23:19We can show it.
23:21In January and March, we apply it.
23:25We show it.
23:27We want to keep our data showing.
23:29We want to keep our data showing.
23:31Select all.
23:33Select all.
23:35Apply it.
23:37We apply it.
23:39Apply it.
23:41We apply it.
23:43We apply it.
23:45We apply it.
23:47We click right.
23:49In the option of the table to right.
23:53We apply it.
23:55We apply it.
23:57We apply it.
23:59We apply it.
24:01Cost of goods sold.
24:05We apply it.
24:07Cost of goods sold.
24:09We apply it.
24:11One thousand.
24:131200.
24:151500.
24:17Here we go.
24:19Cost of goods sold.
24:21We apply it.
24:23If we apply it.
24:25We apply it.
24:27We apply it.
24:29We apply it.
24:31We apply it.
24:33We apply it.
24:35We apply it.
24:37We apply it.
24:39Make it 6.
24:41We do a full year.
24:43You show it.
24:45In the murals.
24:47We add that a little thing.
24:49If we apply it.
24:51In ...
24:53We apply it.
24:55We referral it.
24:57We apply it.
24:59We apply it.
25:01We apply it.
25:03place, which we have seen in number formating, we can do that, we can do that, labels, label
25:12position, access position, tick mark, access options, access option, minimum 0, maximum
25:201600, if we put this minimum 100, and maximum 1600, our 1500 figure, we put 1800, so
25:33we have 1718, so this figure, we can change it, we can change it, we can change it, we can
25:39double click, it has more options, access options, automatically select based on data,
25:46automatically, vertical axis cross, access positions, categorize in reserve order,
25:55this is a reverse order, this is a reverse order, this is a reverse order, which you
26:01can do that, which you can use, setting up, short, this is what you need to use, you need to
26:06move through the settings, if you want to click on the下, that you want to select by
26:08double click, direct type, then the menu will come here, also available the
26:12chart, the chart design, the chart style, there is also many different angles, we can
26:20change ites, here, chart style is also included in the loader, here, chart style, the
26:23option is also included, chart colors, you can select colors, you can have something
26:27We can change the colors.
26:29We can change the colors.
26:31We can change the style.
26:33Quick layout.
26:35Quick layout.
26:37Quick layout.
26:39Chart element.
26:41The same thing here.
26:43Here you can access them.
26:45Chart type.
26:47We want to change the line chart.
26:51Line chart.
26:53Line chart.
26:55Chart type.
26:57High here, we can take the line chart.
26:59It comes to the pie chart.
27:01These are the pie chart.
27:03These are the pie chart.
27:05There are the fill options.
27:07Put the color here.
27:09These are the legends.
27:11These settings are the same.
27:13This is the whole setting.
27:15One should be set on the pie chart.
27:18Here will you go.
27:20View option.
27:23in the selection series option. Plot series on primary axis, secondary axis, angle of first scale.
27:30If you change this, you will see how effect will be. I will add this to this angle.
27:34This angle change will change.
27:42This position will be possible. This is the point explosion.
27:48it's no point
27:51we're going to click on this point
27:53we're going to select this point
27:55here in the file chart
27:56here in the file chart
27:58this will be
28:01we're going to select this point
28:02we're going to ensure this
28:04just as you can click on this point
28:06before you select all of them
28:07then click on this button
28:09so this specific series
28:12select this
28:12now we're going to add this
28:15this will be a little bit
28:15simple click
28:18that we click on the menu.
28:20We click the title for the option.
28:24We click on the title.
28:26The title will be height.
28:28So this way you can compare the presentation
28:30that you can make a good
28:32and good way.
28:34Chart style
28:36is the main
28:38which use these.
28:40Bar charts by the way
28:42is the bar chart.
28:44As you can show data
28:46we have to put the data on the filter and put the data on the cost of goods sold
28:54we have to apply it so that it will show it to complete the year.
28:58In the chart type, there are options, you can explore the style,
29:03you can see the area chart, you can see the area chart, you can change it.
29:10There are here, you can see the view here, just points,
29:14in front of this.
29:16we have to change that.
29:18We can show the lines or the lines,
29:20we can show how much points we can show.
29:22So, this will show the lines,
29:24the points we can show.
29:26We can change this.
29:28We can change it,
29:30we can change it.
29:32We can change data,
29:34or select data,
29:36or we can change it.
29:38We can change it,
29:40we can change it.
29:42also
29:58foreign
30:05foreign
30:10apply it will be done with fill.
30:12which we will do
30:14apply it will be done with all the things we will apply.
30:18in formatting, all the things we will do
30:20share fill color, picture, gradient, texture,
30:24which we will apply.
30:26all the options will be done with each other.
30:30which is separate separately.
30:32This was our lecture.
30:34If there is any confusion,
30:36you must share it.
30:38share it with us.
30:40We will see you in the next lecture.
30:42Allah Hafiz.