Microsoft Excel 45 Building Charts

SimpleTutorials

Microsoft Excel is a powerful spreadsheet application used for organizing, analyzing, and visualizing data. In this course, you will learn the essential skills you need to get started and become confident in using Excel.  In this video lesson, we will learn about Building Charts in Microsoft Excel  You can access the entire Microsoft Excel Course in the following playlist: https://www.dailymotion.com/playlist/xa9hyw

Transcript

00:00If you want to go ahead and create out charts using Excel, you can go ahead and select out

00:10the data right here just like this that you have, and then you can go ahead on to the insert tab,

00:15and here you can see that there's different charts that you can select from. For example,

00:19you can go around over here and select out, let's say for example, this 3D column chart,

00:23and then you have this chart right here. Apart from that, you can also go ahead and choose

00:28different charts right here just like this as well. So apart from that, you can also go ahead

00:33and select, and then you can go around over here onto insert, and insert different chart. Like for

00:39example, this pie chart right here just like this. You can go ahead and scroll out, and then you can

00:44go ahead, let me just press ctrl z, you can go ahead and drag it down right here just like this. So this

00:51is what you have. So now you can go around over here, and let's say for example, go around over

00:56here onto insert, and then you can see that there are different things. Like for example, there's the

01:03combo of charts right here, and so forth. Apart from that, you can also go for recommended chart. So

01:08you can go ahead and select the chart as you wish right here just like this. Select the one you want,

01:13and you get to insert that out. Let me just press ctrl z right here, and this is what you have. So now,

01:19if I were to go around over here, you can go to chart filter, and just go ahead and disable and enable

01:26out the charts as you like. By categories, as you can see, and by sales expenses, you can go ahead

01:32and disable it, and press apply in order to go ahead right here, and show the chart out just like that.

01:38So that is how you can simply go ahead and build out the charts as you like in Excel, and generate it

01:44out as you like. So hope you guys learned something right here. I hope you guys found this video useful.

01:53Be sure to hit the like button, don't forget to share this out with your friends and families,

01:58and for more contents like these, do follow simple tutorials.

Category

Transcript

Be the first to comment

Recommended