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.
This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!
This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!
Transcript of the video:
Hey, welcome back to the MrExcel netcast.
I'm Bill Jelen.
Basically, we start out with massive amounts of data.
How we're going to analyze this. Well, let's fire up a pivot table.
Let's see if you can solve this problem.
Hey, welcome back to the MrExcel netcast.
I'm Bill Jelen.
Wow! I really screwed up back in episode 1031 and 1032 talking about, how to create that xy chart with multiple series.
I created it with a single series and then kept adding new data, it turns out that you don't have to do that at all and several people wrote in with the solution to this.
Basically, you set up your data like this with X1 and Y1 here like I had done, but then below that put the X2 values and the Y2 values.
Over in column C, X3 values back in Column A and then the Y3 values over in Column D And so, on down the, down the way and then when we create a xy chart from that whole big set.
We get all of the xy points correctly in the right spots, and you just have to go through and format them as I did back in episode 1032.
So, thanks to everyone for sending those in.
I'll be spending a lot of money on postage for sending Excel master pins out there.
That's the great thing about Excel.
You can think that you know almost everything and you can always be surprised, and I'm constantly surprised for this podcast.
Thanks for that great tip.
Great way to solve that problem.
I appreciate all the folks who wrote in.
Watch your mailbox for your excel master pins for that one.
But, everyone else We'll see you next time for another netcast from MrExcel.
Thanks for stopping by.
We'll see you next time for another netcast form MrExcel.
I'm Bill Jelen.
Basically, we start out with massive amounts of data.
How we're going to analyze this. Well, let's fire up a pivot table.
Let's see if you can solve this problem.
Hey, welcome back to the MrExcel netcast.
I'm Bill Jelen.
Wow! I really screwed up back in episode 1031 and 1032 talking about, how to create that xy chart with multiple series.
I created it with a single series and then kept adding new data, it turns out that you don't have to do that at all and several people wrote in with the solution to this.
Basically, you set up your data like this with X1 and Y1 here like I had done, but then below that put the X2 values and the Y2 values.
Over in column C, X3 values back in Column A and then the Y3 values over in Column D And so, on down the, down the way and then when we create a xy chart from that whole big set.
We get all of the xy points correctly in the right spots, and you just have to go through and format them as I did back in episode 1032.
So, thanks to everyone for sending those in.
I'll be spending a lot of money on postage for sending Excel master pins out there.
That's the great thing about Excel.
You can think that you know almost everything and you can always be surprised, and I'm constantly surprised for this podcast.
Thanks for that great tip.
Great way to solve that problem.
I appreciate all the folks who wrote in.
Watch your mailbox for your excel master pins for that one.
But, everyone else We'll see you next time for another netcast from MrExcel.
Thanks for stopping by.
We'll see you next time for another netcast form MrExcel.
