Hey welcome back to the Mr. Excel netcast I am Bill Jelen. Basic, we start out with massive amounts of data and how are we going to analyze this? Well, let's fire up the activity table and see if we can solve this problem.
Yeah, alright, welcome back to the Mr. Excel netcast, I’m Bill Jelen. Hey, we have a question sent in by Pierre from France. Pierre wants to create this chart. He created this chart in PowerPoint. It’s basically an XY chart but it has several different series. And this is so hard to do in Excel because what we’re going to have to do is create an XY chart from the first series, the red series first. So, we got an insert and then scatter chart, create that series and so there’s series one. And then we’re going to go to select data, choose Add.
And for the second series, we’ll specify where those values are. And make sure we get rid of this value here and specify the second Y series. Click Okay, repeat Add, series three, the green series down here. And then for the green Y, let’s put those in. You have to make sure you get rid of that one. Try it again, there’s the greens, great. Click Okay and then we’ll click Add and we’ll keep doing that so the series X values are all the blue X values. And then the series Y values, we’ll get rid of that or the blue Y values and then Okay. And then one last one, Add series X values, all of our values down here and then the series Y values are back here now.
Back in Excel 2003, under chart data, the second tab there had a similar dialogue box to this. Now, that we have all those in, we’re going to go through one at a time and select each series. So, go to series one, format selection, go to marker options, choose built in, choose the round, and then kick it up to a nice big size maybe 12 or so. Once we have that, this first series is suppose to be red, so I’ll choose a nice red fill and click Close. There we go and hey now let’s do it again, series two, again format selection, marker options, built in, choose the circle, go back to the nice big size, and marker fill on this one, it is supposed to be orange so I’m choosing orange.
Now, hey check this out in Excel 2007, pretty cool. We can keep the formatting series box open and reach back here and choose series three, marker options, built in, choose the circle, choose a nice big size, and marker fill, this is supposed to be green, good. Reach back here, series four, marker options, built in, round circle, 12, and this one’s supposed to be blue, get this blue here.
And then finally, the last series, series five. Marker options built in, change it back to a circle, kick the size up. This is all very tedious, isn’t it? So, our fill on this one is going to be violet, click Close. Alright here, there you go. Hey, there you have it, the five different series all at an XY chart. Now tomorrow, I’ll show you completely different way to do this, not sure if it’s any better, maybe a little bit better. I wanna thank Pierre for sending that question and we’ll see you next time for another netcast from Mr. Excel.
Transcription by:
Scribe4you Transcription Services