From the course: Excel 2010 Essential Training
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Creating and modifying a pie chart - Microsoft Excel Tutorial
From the course: Excel 2010 Essential Training
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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.