Today, in Episode #1273, Bill begins a series on Charts and Graphs in Excel 2010". Today: Changing the Series Order of a Chart in Excel 2010. This is the video podcast companion to the book, "Charts And Graphs: Microsoft Excel 2010" by Bill Jelen
Transcript of the video:
MrExcel Podcast is sponsored by Easy-XL.
Excel charts chapter 1, The Select Data Dialog.
Hey welcome back to the MrExcel netcast.
We're working through examples in the Excel Charts and Graphs Book.
Just one example from each chapter, so the book covers a lot more than what we're doing here.
But, I figured it'd be interesting to take one topic in each chapter and kind of demonstrate it here in the video.
So, we're talking about creating charts, and we need to change the data that's in the chart.
I'm gonna creat a 2D Column chart here, and the first thing you see is that Excel decides because there's five cities and four months that they're going to put the cities across the bottom and that's not what I want.
I want to have the cities over here in the legend so that's really easy to do with the switch row column.
So this is on the Chart Tools, Design, Choose Switch Row Column and that gets the cities over in the legend and then, the months going across the bottom.
Okay, now as I look at this, I wanna to arrange the data, in order by January temperature, and we're almost there.
It's just a matter of taking Adelaide and moving it after Darwin and then, everything will be in a nice sequence there.
I am not sure how to do that using select data.
All right, with select data, we can take an entry and then use these up and down arrows to move it.
So I'm gonna take Adelaide and move that down, so we have Alice, Springs, Darwin, Adelaide, Melbourne and Sydney.
And so, now you see that I have a nice flow there in January.
You know we can sing along.
It doesn't seem to follow that pattern in the other seasons.
Always good to take one of your data points and put it in order so we can compare it to the others.
All right, now the other thing we have here, this is Australia obviously, and so January is summer and July is winter.
I want to make that very clear to people and so, I'd like to change these headings.
I could change them in the chart, but let's take a look at how to do that in the select Data Dialog.
Here, we have our various categories. I'm going to click edit and you'll see that right now it's coming from a range on the worksheet, but we can change that.
Leave the equal sign there, and then take a left curly brace and then in quotes, so January is summer in Australia, a comma to go to the next value, then fall Autumn or whichever you prefer winter and then finally spring You have to close that with a closing curly brace.
Click OK OK, OK and now we've managed to change the labels that are being used there along the axis.
Now, normally you would change those data here in the underlying data set.
But, sometimes we don't want to change that data.
It might be someone else's data or we're linking to another workbook, and we don't want to change that data set.
So, it's nice to know that using switch row, column and the select data, options we can change that data very easily in the chart.
I want to thank you for stopping by. Will see you next time for another netcast from MrExcel.
Excel charts chapter 1, The Select Data Dialog.
Hey welcome back to the MrExcel netcast.
We're working through examples in the Excel Charts and Graphs Book.
Just one example from each chapter, so the book covers a lot more than what we're doing here.
But, I figured it'd be interesting to take one topic in each chapter and kind of demonstrate it here in the video.
So, we're talking about creating charts, and we need to change the data that's in the chart.
I'm gonna creat a 2D Column chart here, and the first thing you see is that Excel decides because there's five cities and four months that they're going to put the cities across the bottom and that's not what I want.
I want to have the cities over here in the legend so that's really easy to do with the switch row column.
So this is on the Chart Tools, Design, Choose Switch Row Column and that gets the cities over in the legend and then, the months going across the bottom.
Okay, now as I look at this, I wanna to arrange the data, in order by January temperature, and we're almost there.
It's just a matter of taking Adelaide and moving it after Darwin and then, everything will be in a nice sequence there.
I am not sure how to do that using select data.
All right, with select data, we can take an entry and then use these up and down arrows to move it.
So I'm gonna take Adelaide and move that down, so we have Alice, Springs, Darwin, Adelaide, Melbourne and Sydney.
And so, now you see that I have a nice flow there in January.
You know we can sing along.
It doesn't seem to follow that pattern in the other seasons.
Always good to take one of your data points and put it in order so we can compare it to the others.
All right, now the other thing we have here, this is Australia obviously, and so January is summer and July is winter.
I want to make that very clear to people and so, I'd like to change these headings.
I could change them in the chart, but let's take a look at how to do that in the select Data Dialog.
Here, we have our various categories. I'm going to click edit and you'll see that right now it's coming from a range on the worksheet, but we can change that.
Leave the equal sign there, and then take a left curly brace and then in quotes, so January is summer in Australia, a comma to go to the next value, then fall Autumn or whichever you prefer winter and then finally spring You have to close that with a closing curly brace.
Click OK OK, OK and now we've managed to change the labels that are being used there along the axis.
Now, normally you would change those data here in the underlying data set.
But, sometimes we don't want to change that data.
It might be someone else's data or we're linking to another workbook, and we don't want to change that data set.
So, it's nice to know that using switch row, column and the select data, options we can change that data very easily in the chart.
I want to thank you for stopping by. Will see you next time for another netcast from MrExcel.
