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

Watch on YouTube

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