Creating and modifying a pie chart

When you want to show how individual numbers combine to make up a total, nothing…beats a pie chart and Excel does them pretty well.…So let's take a look.…Let's select cells down the State column, and hold the Ctrl key down on your…keyboard and let's drag on these cells down Column E.…So we want to have the State header and the data underneath it and the Total…header and the data underneath it selected.…The only way to select cells that are not adjacent is by holding down the Ctrl key.…Now in another movie I said that you should never select the total to go into a chart.…

Well, let me make that a little bit more accurate.…You don't want to have the total selected and the data that combines the total.…So in this instance, it's okay to select the total because we don't have…the quarterly data.…If we have the quarterly data, you wouldn't select the total.…Pie charts are showing components of the whole, so that's why we really do want…the Total column selected.…So we are going to insert a pie chart.…