Excel - Master Pivot Tables and Create XY Charts with Ease - Excel Tutorial - Episode 1038
1,435 views · Published 17 June 2009 · 1:55 · Indexed 8 November 2026
Channel: MrExcel.com · 2009 · Education
Microsoft Excel Tutorial: Master Pivot Tables and Create XY Charts with Ease - Excel Tutorial. Welcome back to the MrExcel netcast! In this episode, we're going to tackle a common problem faced by many Excel users - how to analyze massive amounts of data. But don't worry, we've got a solution for you - pivot tables! By using pivot tables, we can easily organize and analyze large datasets, making our lives a lot easier. So let's dive in and see how we can use pivot tables to solve this problem. But before we get into that, I have to admit, I made a mistake in our previous episodes (1031 and 1032) where I showed you how to create an xy chart with multiple series. Turns out, there's a much simpler way to do it! Thanks to the helpful suggestions from our viewers, we now know that we can set up our data in a specific way to get all the xy points correctly in the chart. Simply put, we just need to have the X and Y values for each series listed in separate columns, and then create the chart from the entire dataset. It's that easy! I want to take a moment to thank all the viewers who wrote in with this solution. Your contributions are what make this community so great. And as a token of my appreciation, I'll be sending out Excel master pins to those who shared this tip with us. Keep an eye on your mailbox for your pin! This is what I love about Excel - there's always something new to learn, and we can all learn from each other. So keep those tips and tricks coming, and let's continue to grow and improve together. That's all for this episode of the MrExcel netcast. I hope you found this tip helpful and will use it to make your Excel experience even better. Don't forget to like, comment, and subscribe to our channel for more Excel tips and tricks. And as always, if you have any questions or suggestions for future episodes, please leave them in the comments below. Thanks for watching, and I'll see you in the next netcast from MrExcel! Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/ You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/ In Episode 1038 - a better way to create the multiple scatter charts from Episode 1031 and 1032. Thanks to everyone who wrote in with this better way to set up the data. Table of Contents: (00:00) Introduction (00:21) Solution to Creating XY Chart with Multiple Series (00:34) Setting Up Data for XY Chart (00:57) Formatting XY Chart (01:34) Clicking Like really helps the algorithm #excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial This video answers these common search terms: Excel master pins format xy chart multiple series pivot table solving problems in Excel X1 and Y1 values X2 and Y2 values X3 and Y3 values xy chart Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1152465/
More from this channel
-
2:13
Excel Calculate Decimal Hours from two Time Cells - Episode 902
-
3:57
Excel 2007 - Color of Selected Sheets is too much like unselected sheets - Episode 907
-
2:48
Excel - Adding Equals Icon to Excel QAT - Build Formula with Mouse - Episode 911
-
3:30
Excel Grouping Percentages into Buckets for a Pivot Table - Method 2 - Episode 913
-
2:04
Excel Change Color of Selected Cells - Episode 914
-
4:38
Excel - Auto Numbering a List with Frequent Inserts & Deletes - Episode 916
-
2:37
Excel - Enhance Your Excel Charts: Add a Picture as a Background in Excel - Episode 917
-
2:00
Excel Hiding Data in Plain Site - Episode 919