How to Make Pivot Chart in Excel

Ғылым және технология

🔥 Learn Excel in just 2 hours: kevinstratvert.thinkific.com
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
- Sample workbook to follow along: 1drv.ms/x/s!AmxrofZZlZ-wha0Fb...
- Pivot Tables tutorial: • How to Create Pivot Ta...
- In-depth Excel Charts tutorial: • Excel Charts and Graph...
⌚ 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
- Playlist with all my videos on Excel: • Excel for Beginners
📩 NEWSLETTER
- Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: kevinstratvert.com/newsletter/
🔽 CONNECT WITH ME
- Official website: www.kevinstratvert.com
- LinkedIn: / kevinstratvert
- Discord: bit.ly/KevinStratvertDiscord
- Twitter: / kevstrat
- Facebook: / kevin-stratvert-101912...
- TikTok: / kevinstratvert
- Instagram: / kevinstratvert
🎒 MY COURSES
- Go from Excel novice to data analysis ninja in just 2 hours: kevinstratvert.thinkific.com/
🙏 REQUEST VIDEOS
forms.gle/BDrTNUoxheEoMLGt5
🔔 SUBSCRIBE ON KZread
kzread.info?...
🙌 SUPPORT THE CHANNEL
- Hit the THANKS button in any video!
- Amazon affiliate link: amzn.to/3kCP2yz (Purchasing through this link gives me a small commission to support videos on this channel -- the price to you is the same)
#stratvert #excel #pivotcharts

Пікірлер: 40

  • @KevinStratvert
    @KevinStratvert9 ай бұрын

    🥷 Go from Excel novice to data analysis ninja in just 2 hours with my Excel for Beginners course: kevinstratvert.thinkific.com ⏭ Watch more free Excel tutorial videos: kzread.info/head/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY 📊 In-depth Pivot Table tutorial: kzread.info/dash/bejne/gph-3NtyZZndn5c.html

  • @toolplaza
    @toolplaza9 ай бұрын

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

  • @j.r.61
    @j.r.619 ай бұрын

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

  • @remeshsathyadevan
    @remeshsathyadevan4 ай бұрын

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

  • @samuelovic8682
    @samuelovic86829 ай бұрын

    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🐐

  • @thisiskris99
    @thisiskris996 күн бұрын

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

  • @tekmepikcha6830
    @tekmepikcha68309 ай бұрын

    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 😊

  • @billblanchette3604
    @billblanchette36049 ай бұрын

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

  • @shleeahuff3945
    @shleeahuff39455 ай бұрын

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

  • @user-uz1fn9ne1p
    @user-uz1fn9ne1p9 ай бұрын

    Thank you Kevin. This is insightful!

  • @noreenstxs9605
    @noreenstxs96059 ай бұрын

    Thanks Kevin!

  • @christianbruneau6717
    @christianbruneau67179 ай бұрын

    Amazing videos! Thanks

  • @othmanaljbory3649
    @othmanaljbory36499 ай бұрын

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

  • @CravingCanada
    @CravingCanada9 ай бұрын

    Very helpful. Thank you.

  • @HamdanYouTuber
    @HamdanYouTuber9 ай бұрын

    Clearly explanation. Thanks

  • @KevinStratvert

    @KevinStratvert

    9 ай бұрын

    Glad it was helpful!

  • @andreausa123
    @andreausa1233 ай бұрын

    Thanks !

  • @johngato737
    @johngato7379 ай бұрын

    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?

  • @XLLearner_Courses
    @XLLearner_Courses9 ай бұрын

    Nice explanation

  • @coolceelah
    @coolceelah9 ай бұрын

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

  • @kigwa1126
    @kigwa11264 ай бұрын

    good to learn

  • @TALHAJAVED2244
    @TALHAJAVED22447 ай бұрын

    GOOD ONE broo 😍

  • @johannaleiziaga5730
    @johannaleiziaga57302 ай бұрын

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

  • @joeb253
    @joeb2534 ай бұрын

    Thanks Kevin, I have question what's different between Povit table and Povit chart?

  • @Jana2WorldsArt
    @Jana2WorldsArt9 ай бұрын

    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

  • @stevecloud4soft
    @stevecloud4soft3 ай бұрын

    Hi, do you know how to plot line chart type in pivot chart. scatter is not also supporting in pivot chart

  • @iviaggidiAntony
    @iviaggidiAntony9 ай бұрын

    Better to use power BI or pivot tables?

  • @kidsvideos3742
    @kidsvideos37427 ай бұрын

    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)

  • @sheiksiraj4456
    @sheiksiraj445616 күн бұрын

    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

  • @RAVINDERSINGH-ht6pl
    @RAVINDERSINGH-ht6pl9 ай бұрын

    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.

  • @astuces.tech2.0
    @astuces.tech2.09 ай бұрын

    Hi Kevin, if you don't mind, can you pls tell me where the sounds effets in your videos come from? It's okay if you can't.

  • @Spottifei
    @Spottifei8 күн бұрын

    For those with 365 Microsoft accounts: it only works in the desktop app, the functionality of online software is limited.

  • @callmer0han
    @callmer0han8 ай бұрын

    How we can create 3 pivot charts with the same data in the same sheet? When I do this the data shows overwrite and charts changes

  • @Anunknowncat2593
    @Anunknowncat25939 ай бұрын

    Is there any way I can watch Google maps Street view in my vr box?

  • @Suspectshot_21
    @Suspectshot_213 ай бұрын

    I can't find the pivot chart option?

  • @rishavekumar6326
    @rishavekumar63265 ай бұрын

    If i want to remove the pivot table can i do that ?

  • @mikea8225
    @mikea82259 ай бұрын

    What version of excel is this? I’m using Mac

  • @guilhermeferrari2562
    @guilhermeferrari25624 ай бұрын

    My csv file is too large. 380MB. I don't know what to do to generate charts with this.

  • @victormildrew6101
    @victormildrew61019 ай бұрын

    Please Help. I am really at my wits end over Online recognition, i am desperate to delete it from my pc over the annoying pop ups all the time, I have tried by looking for help on Google and KZread and just find ways to disable it and that does not work on this machine. I just want rid of the software in Windows. I do hope you can help, Thankyou. P.S Windows 10.home.

  • @joer8261
    @joer82618 күн бұрын

    dddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddd

Келесі