Skip to playerSkip to main content
  • 9 months ago
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 Creating PivotCharts in Microsoft Excel

You can access the entire Microsoft Excel Course in the following playlist:
https://www.dailymotion.com/playlist/xa9hywmicrosoft

Category

📚
Learning
Transcript
00:00so over here you can see that I have this particular data and let's say what I want to do
00:09now is I want to go ahead and create a pivot chart out of it so to do that first of all I need to
00:15make a pivot table and for that I'm going to select out this particular data right here and
00:21then I'm going to go around over here onto insert and then click on pivot table and then I'm going
00:27to choose a new worksheet and press ok so now you can see that I can go ahead and bring in the data
00:33as I like I can go ahead and rearrange the value as I like as well so to insert a chart related to
00:39this pivot table you can click on the pivot chart that appears under the pivot table analysis
00:45tab that appears after you create the pivot table so if I were to go ahead and click on pivot chart
00:52you can choose the chart type as you like let's say for example I'm simply going to go for a
00:56column chart and press ok and this is what you have as you can see so now you can go ahead and
01:02change this out and as per the pivot table that you have right here you can see that the chart
01:09automatically updates right here just like this as well so you can see that you also have all of the
01:14filters right here and if I were to go ahead and change this out right here you can see that the
01:19pivot chart updates out just like that as well so that is how you can go ahead and create out a pivot
01:25chart inside of Microsoft Excel so I hope you found this video useful be sure to hit the like button
01:32don't forget to share this out with your friends and family and for more contents like these do follow
01:39follow simple tutorials
01:40follow simple tutorials

Recommended