When we first started talking about charts, I did mention that there are many different types of charts you can work with. Some charts are better suited for large amounts of data, Like a cluster call them chart. Some charts are better suited for smaller amounts of data perhaps a single column of data or a single row. An example of this would be a pie chart.
Let us look at how you create a pie chart within Microsoft Excel.
I am going to go back to my quarter one sheet back to where all my data is at.
Now remember the first step is to select the data that you want to chart.
I am going to grab the same range that I grabbed earlier I will grab from A3 down to D8. There we go.
Now what that date is selected. I am going to create a pie chart but remember a pie chart is better suited for a single axis of data, a single column like a single month or a single bill a single row.
I have got all that data selected I am going to go up to insert tab.
I am going to go over the charts and this time I am going to grab a pie chart and I will just do the default to the flat chart.
What did you give me? Excel give me all of the months with all the bills, remember a pie chart better suited for smaller amounts of data a single column a single row. So, what I really guy here is a single row worth of data. I got Rent for all three months. So, I got an equal pot pie chart there. Well that is great right.
But maybe it is not rent that I wanted maybe I wanted gas or maybe I did not want to bill maybe I wanted to break this up by a month. I want to see February’s data with all the bills. Why do not I do that.
We talked about changing the data source earlier, Remember that.
I Select my chart. Scroll back up. Never the color-coded areas. Now let us say I only want a specific month. I only want February. So, I am just going to grab the blue bar to shrink that up. It was great this site as well. Let us shrink that up. And now I have just got February data.
But I am only looking at rents. That is weird. February rent is not much of a pie chart. I need to make a change here again with my chart selected. I am going to go to the Design tab, and I have this feature called switch row column.
Right now, I am looking at this by row a single row where the data rent for a single month. I am going to change it from row to column and I will get this button click. And now I have got February with all the bills one button press two change the data source. And then I switch the row column.
A pie chart effective in describing your data. Kind of more percentage wise of this 100 percent pie. But remember it is better suited for a single column or a single row of data. So, you can manipulate the data pick up on the specific month or specific bill but remember on the Design tab you have got the switch row column feature. You can pick up on the appropriate data.
Try this out. Build a pie chart. You decide if you want to do a specific month. Do you want to do a specific bill worked with the switch row column get a feel for working for it with a pie chart and how to present that data? Try it out.