How to Make Pivot Chart in Excel

Pivot charts are a powerful way to visualize and analyze data in Excel. They allow you to summarize and compare large amounts of data in different ways, such as by categories, regions, or time periods. In this video, you will learn how to create and customize pivot charts in Excel, from formatting the data to changing the chart type.

You will learn how to:
- Format the data in columns so that it can be used for pivot charts
- Insert a pivot chart using the Insert tab
- Understand what fields are and how to drag them into the areas to start constructing a pivot chart
- Change the chart type
- Apply filters to the pivot chart to refine the data

By the end of this video, you will have a strong grasp of how pivot charts work and how to use them to create dynamic and interactive charts in Excel. You will also be able to apply the same skills to create pivot tables, which are another way to summarize and analyze data in Excel.

📚 RESOURCES

⌚ TIMESTAMPS
00:00 Introduction
00:21 Prepare data
00:53 Insert pivot chart
01:29 PivotChart fields
02:03 Drag fields between areas
04:40 Change chart type
05:52 Design and format
06:41 Filter field
07:23 Insert new pivot chart
08:13 Switch row and column
09:29 Filters area
10:50 Wrap up

📺 RELATED VIDEOS

📩 NEWSLETTER

🔽 CONNECT WITH ME

🎒 MY COURSES

🙏 REQUEST VIDEOS

🔔 SUBSCRIBE ON YOUTUBE

🙌 SUPPORT THE CHANNEL
- Hit the THANKS button in any video!

#stratvert #excel #pivotcharts

[j.r.]

I am working toward my PhD, and this is extremely helpful for presenting data from research.
THANK YOU!!!

[toolplaza]

These tools are undoubtedly useful, the tools I have developed on my website are more basic and generic, but still important!

[remeshsathyadevan]

The presentation was not only pleasant but also enriched with valuable insights. Thank you

[tekmepikcha]

Kevin, what we also need is an Ai to automatically clean our data. If not, then the ability to set parameters or rules for each column, that will prevent or highlight deviation in the input data. Also PLEASE give examples other than accounting/sales/marketing data; eg, pivot tables for social or science based research 😊

[samuelovic]

Very detailed step by step explaination
The best tutorials on MS excel, word etc can only be found in this channels
Mr Kevin you're really the🐐

[HeyaTeya]

I’m about to take somebody’s job with this. Thank you so much!

[shleeahuff]

Wow!! This is amazing! I have to familiarize myself with pivot tables/charts over the wknd and this is an excellent tutorial! Thank you!

[othmanaljbory]

❤❤❤ thank you ❤I am following you from Iraq ❤❤

[coolceelah]

I used Pivot tables in my job and needed this video. Your videos are always so informative and helpful. Thanks.

[thisiskris]

Thank you very much. Your VDO is so helpful to me.

[johngato]

Continue to use and value your videos to help me at work. Thank you for what you do.

I am an educator, can you share what annotation software you use to screen share and manipulate what you show us?

[billblanchette]

Wow, what an awesome way to visualize data. Wish I knew about this sooner. Great video 👍🏼

[siraj]

after creating a chart or a pivot chart, i'm not able to change the data from select data button after right clicking likewise after creating charts i can't format the charts if its from a pivot table (paste special isn't working),

please help

[johannaleiziaga]

Which chart do you recomend for a table that contains 2.000 rows?

[carlosbastos]

Hi Kevin, any thoughts how to fix a pivot chart that does not update values? There is a table that feeds a pivot chart and a pivot table. When I update date in this table the pivot table gets updated but the pivot chart keeps the old values.

[RAVINDERSINGH-htpl]

Hi, can you tell me if I record laptop screen whose aspect ratio is 16:10 and play it on laptop/platform whose aspect ratio is 16:9 then how will be the playback will there be any loss of information. I own a laptop with 16:9 aspect ratio and planning to buy new laptop and most of the laptop are available in the market are with 16:10 aspect ratio.

[kidsvideos]

i want you make a video, how to make a chart to display data different type and add target line too.(number and percentage, target line)

[cherryberry]

While entering data in excel, how do u make tat label? Or idk whats it called. The one at the very top.

[iviaggidiAntony]

Better to use power BI or pivot tables?

[JanaWorldsArt]

I think because I use excel in one drive online this looks a bit different for me just have recoomended charts and already shows pivot charts options but doesnt opent hat screen to change things