Start learning with our library of video tutorials taught by experts. Get started
Viewers: in countries Watching now:
In Excel for Mac 2011 Essential Training, author Curt Frye gives a comprehensive overview of Excel, the full-featured spreadsheet software from Microsoft. The course covers key skills such as manipulating workbook and cell data, using functions, automating actions, printing worksheets, and collaborating with others. Exercise files accompany the course.
The pie chart, a circle where each differently colored wedge represents a value that contributes to a whole, is one of the most common types of charts seen in business documents. In this movie, I will show you how to create and manipulate pie charts to make your data and its presentation more interesting. As I said, pie charts show how much a given value contributes to a whole, and each slice represents an individual contribution. To create a pie chart, you click any cell in the data list that you want to summarize, and then on the Charts tab, click Pie and select that type of pie chart that you want to create.
In this case, I will just do the simple two-dimensional pie, which is here, and Excel adds the pie chart to your worksheet. You can see we have a chart title, which represents the header for the data column, and then you will see that we have Lemon, Mandarin, Rosemary, and Jalapeno, and those are represented here on the side. So the blue color for the Lemon appears on the chart, Mandarin is this reddish-orange, and so on. If you want to highlight an individual wedge of a pie chart, you can do that by dragging the pie chart out of the main body of the chart.
So let's say, for example, I wanted to highlight the green, which represents Rosemary. If I click the circle, the actual chart, then you will see that Excel highlights all of the wedges of the chart. So they are all highlighted right now, as opposed to say clicking the title, which highlights the title. So if I click the body of the circle, I can then click an individual wedge to highlight it. So I will move down to the green, click it and you will see that now the green is the only wedge that is highlighted. I don't have any highlight marks around any of the other wedges.
So now I can hold down the left mouse button and drag this wedge away from the center of the chart, and that's just one way of highlighting a wedge or an individual element of a pie chart. You can also create other types of pie charts, so for example, if I wanted to, I could delete this entire chart, just by clicking the edge and then pressing Delete key, and then still having a data cell selected here, click Pie, and I can click a three dimensional chart. So I will click the 3D-Pie.
Click it and you will see that I have a pie chart. It doesn't convey any more information than the two dimensional chart, but it's a little more visually interesting. Pie charts are visually appealing, and even though they only convey a limited bit of information, they do brighten up a presentation and show how much various elements contribute to a whole, very effectively.
Find answers to the most frequently asked questions about Excel for Mac 2011 Essential Training.
Here are the FAQs that matched your search "":
Sorry, there are no matches for your search ""—to search again, type in another word or phrase and click search.
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.