# Using pie charts

## Video: Using pie charts

Pie charts, although ideal for certain kinds of data, many times are inappropriate. Nevertheless, when you're using pie charts, you need to make some adjustments to them, and the two pie charts that we see here certainly are lacking in explanatory information. Let's point out a couple of deficiencies, particularly with regard to 3D pie charts. As you look at the chart on left here, which is reflective of the data above it, for the Domestic row, we see the breakout for the first six months.

## Using pie charts

Pie charts, although ideal for certain kinds of data, many times are inappropriate. Nevertheless, when you're using pie charts, you need to make some adjustments to them, and the two pie charts that we see here certainly are lacking in explanatory information. Let's point out a couple of deficiencies, particularly with regard to 3D pie charts. As you look at the chart on left here, which is reflective of the data above it, for the Domestic row, we see the breakout for the first six months.

Now, without looking at the numbers and looking at the wedges, is the green wedge bigger than the blue wedge to the left, in other words, this one here, the one over there? The green wedge is March. The blue one over there is May. You look at the numbers: March is 125, May is 140. Can you see that difference? I pretty much doubt it? Most people can't. And depending upon it the order in which these colors appear here, you might or might not be giving precedence to one wedge over another without necessarily knowing it.

If you've created a pie chart without concern for any order, these will be in a circular order moving from the back in a clockwise order. So the blue that I'm pointing to here is January and then February. But let's talk about how we can change the appearance of this, because there are some tools specifically for 3D charts. And the general rule, as we've been saying throughout this course in terms of Excel 2007, when you want to make a change to an object or a chart element, begin by right-clicking on it if you have not found any choices in the menu.

So if we were to click this chart and then right-click on one of the wedges here, go to Format Data Series, we begin to see some of our choices here. I'm going to focus first on 3D Format and lots of choices in here and also, as we start to adjust some of these, you can change the material. These are things that I think a lot of us never even thought we would ever need, and maybe you still won't, but a lot of different choices here under 3D Format. We can certainly fill these in with different kinds of colors.

We can change the border color, the border styles. We've got shadows. Let's change the entire chart. Now, under 3D Format, we're not seeing any choices here regarding rotation. So let's click back on the chart and simply, without picking one of the wedges here, just right-click in the plot area and choose 3D Rotation, and here we have some choices. Best approach here probably now as I'm clicking these arrows, watch the chart.

We see what's happening. If you want to move January more toward the front, it's the blue that's next to the red, so it's about to move towards-- it's on the right side. Now, it's moving more and more forward. So January is in the front. That might or might not be what you want. What happens here with these buttons? You can begin to see how that tilts the chart in different ways, and we can change the perspective as well too, either with this or with the arrows. And again, for a lot of people, this is very distortive. April in the background there, the purple color, looks a lot smaller than January here, and it's actually a lot bigger.

So we've got some problems with this, but again, it is vivid. It's colorful and if you're trying to show the breakout, say, for budget type numbers, sometimes this is the appropriate chart. I know some people who say, "Don't use 3D pie charts at all. You should use 2D pie charts like the one we were seeing here." The approach here is because we are not appearing to be looking at it from an angle, the sizes of the pieces appear to be more accurate. But in either of these cases, I think it's appropriate to say let's add some labels.

One rule of thumb I've heard is don't be using these pie charts in either case if you have more than five or six or seven wedges, and I know this is not quite exact, but it will depend on the number of wedges you're using. Let's make some adjustments here. Once again, we might start by right- clicking, and where do we need to go this time if we want to add labels? Add Data Labels. And some people like the approach of just using these here. Now we've got some other choices here too. If you go to the Layout tab and choose Data Labels, you can see some choices here related as to where those labels up here.

Some people like them toward the outer edge. Now we got a problem with that black wedge, don't we? Yes, we do. Inside, Outside, Outside the End, Best Fit. Try it that way too. So we've got quite a few choices here related to where these labels are going to go. Some people want them this way as well too. So you do have some different choices here. You can also, on a one-by-one basis, take these labels and drag them off the chart, like this. And you will see, without even trying or setting anything, what are called leader lines.

Now trying to do this on black might be a little tricky. I did happen to catch it there, but you don't always do that so easily too. So we can do this here too. This can get a little old too, can't it? Notice how, depending on where you might drag this, you don't always see the leader lines. So that might cause you to right-click here and say, "What's going on?" or, "What can we do with these labels?" Do a right-click here and talk about the Data Labels, and we can see positions here. Include legend key in labels, that's another option. Show Leader Lines is always on, but you will not see them necessarily unless the positioning is at a certain place.

And so here and there, sometimes try as you might, you can't get them disappear, but sometimes they won't be there, and if you drag it onto the wedge, you see what's happening there. So this is just something you have to experiment with and come up with your own conclusions as to what works best for you. But I think you can readily see, on pie charts, you will need to add labels most of the time. And the labels here are the values. You might not always want to use values. So once again in the dialog box there, you do see Value, but how about Percentage? You might want both. I think a lot of people who would want only one or the other, but you can certainly do that if you wish, choose both.

I'm going to uncheck Value, and now we see percentages. So there are quite a few choices there. And similarly, we could do the same thing with a 3D pie chart. So even though there is limited use here, I think you can see you do need to make some adjustments. And one more point about this too: if you select data here and create a pie chart, if you haven't worked with pie charts at all, you're going to be a little bit surprised. For example, if I go to the Insert tab and choose Pie and whether it's 2D or 3D, it doesn't make any difference, you might be scratching ahead a little bit saying, "Why does it say Domestic?" A pie chart, unlike most other chart types, can't handle more than one range.

So we're looking at this data automatically. Now if you were dead set on showing a pie chart with Asia only, you would be selecting this range and then with the Ctrl key, select this range. And then in the Ribbon, Insert > Pie, pick either one, you want, maybe 2D pie this time, and you see what we're choosing here. So regardless of how much data you're highlighting, Excel can only handle a single portion of a row or column, not multiple rows and columns, in a pie chart.

One more aspect of this too. I'm going to change this data and make it negative. Now, not just for fun, but just based on the idea, what if the sales adjustment number here for February, because of returns or whatever, was -10? I'm going to change this number to -10. That's in cell C2 there. As I press Enter, watch all these charts. Now what will happen in all of them is that the February wedge will become much smaller, but is there any indication whatsoever on any of these charts-- the Asia chart doesn't include this we don't see it there-- but on the other charts here, the February wedge is certainly smaller, but is there any indication whatsoever that it's negative? Now over here, we take a look on this chart where we actually have titles, and it's a little tricky to move the side.

You can see where it's going on there. That would certainly get our attention, but the concept is totally inappropriate. I guess we could say there is no such thing as a negative piece of pie. And it is just a little bit strange that Excel doesn't really prevent you from creating the pie; it just treats the data as if it were a positive entry. So in wrapping up the whole discussion here about pie charts, certainly valuable for certain kinds of data. They definitely have limitations. I would suggest a 2D probably better than the 3D if you're looking for accuracy and display.

And in either case, I think it makes good sense to put in data labels on pie charts.

Show transcript

#### This video is part of

Excel 2007: Charts in Depth

53 video lessons · 9230 viewers

Author

Expand all | Collapse all
1. ### Introduction

1m 49s
1. Welcome
1m 3s
2. Using the exercise files
46s
2. ### 1. Understanding Excel Chart Concepts

22m 7s
1. Identifying chart elements like plot area, chart area, gridlines, and legends
5m 3s
2. Selecting the right chart type
8m 2s
3. Understanding chart terminology
6m 31s
4. Understanding the Ribbon and the Design, Layout, and Format tabs
2m 31s
3. ### 2. Creating Basic Charts Quickly

16m 24s
1. Selecting data to display as a chart
6m 17s
2. Creating charts instantly with shortcuts
4m 33s
3. Creating charts with standard menu commands
2m 24s
3m 10s
4. ### 3. Fine-Tuning Charts with Design Tab Choices

28m 8s
1. Switching rows and columns for a different view of the data
3m 9s
2. Setting a default chart type and creating a template
3m 47s
3. Dealing with empty and hidden cells
4m 18s
4. Choosing a chart layout
4m 33s
5. Choosing a chart style from 48 colorful variations
3m 34s
6. Changing the location of a chart
3m 33s
7. Moving and resizing a chart
5m 14s
5. ### 4. Layout Tab Options: Inserting Pictures, Shapes, and Text Boxes

11m 25s
1. Using pictures as chart elements
3m 55s
3m 37s
3. Adding floating text and text boxes
3m 53s
6. ### 5. Layout Tab Options: Adding Titles, Labels, and Legends

33m 45s
1. Adding, editing, and removing chart titles
3m 15s
2. Adding horizontal and vertical titles
3m 56s
2m 32s
4. Showing numbers of different scales
4m 38s
5. Specifying the position of tick marks and axis labels
2m 41s
6. Changing the numeric format on labels
5m 34s
7. Adding, editing, and removing legends
3m 19s
8. Adding and editing data labels
4m 40s
9. Showing the source of a chart's data
3m 10s
7. ### 6. Layout Tab Options: Using Axes and Gridlines

8m 13s
1. Modifying axis scaling
3m 50s
2. Working with gridlines
4m 23s
8. ### 7. Layout Tab Options: Using the Analysis Tools

12m 53s
1. Analyzing existing and future data with trendlines
4m 2s
3m 14s
3. Adding high-low lines and up-down bars
1m 39s
3m 58s
9. ### 8. Format Tab Options: Adding Shapes and WordArt Styles

9m 13s
1. Selecting shape fill and outline
3m 3s
3m 19s
3. Applying WordArt styles
2m 51s
10. ### 9. Using Other Formatting Tools

16m 33s
1. Formatting lines and borders
4m 24s
2. Filling an area with a color gradient
2m 7s
3. Specifying line style, color, and weight
2m 46s
4. Working with chart text
3m 40s
5. Changing the rotation of chart text
3m 36s
11. ### 10. Adjusting Specific Chart Types

38m 39s
1. Using column and bar charts
7m 24s
2. Using line charts
5m 46s
3. Using pie charts
8m 37s
4. Using area, stock, and XY charts
9m 3s
5. Using doughnut, bubble, and radar charts
7m 49s
12. ### 11. Changing a Chart's Data Source

10m 55s
1. Pasting new data into a chart
2m 58s
2. Creating charts from multiple data sources
3m 39s
3. Adding new data using a table
4m 18s
13. ### 12. Printing and Sharing Charts

6m 19s
1. Printing charts
6m 19s
14. ### Conclusion

19s
1. Next steps
19s

### Start learning today

Sometimes @lynda teaches me how to use a program and sometimes Lynda.com changes my life forever. @JosefShutter
@lynda lynda.com is an absolute life saver when it comes to learning todays software. Definitely recommend it! #higherlearning @Michael_Caraway
@lynda The best thing online! Your database of courses is great! To the mark and very helpful. Thanks! @ru22more
Got to create something yesterday I never thought I could do. #thanks @lynda @Ngventurella
I really do love @lynda as a learning platform. Never stop learning and developing, it’s probably our greatest gift as a species! @soundslikedavid
@lynda just subscribed to lynda.com all I can say its brilliant join now trust me @ButchSamurai
@lynda is an awesome resource. The membership is priceless if you take advantage of it. @diabetic_techie
One of the best decision I made this year. Buy a 1yr subscription to @lynda @cybercaptive
guys lynda.com (@lynda) is the best. So far I’ve learned Java, principles of OO programming, and now learning about MS project @lucasmitchell
Signed back up to @lynda dot com. I’ve missed it!! Proper geeking out right now! #timetolearn #geek @JayGodbold
Share a link to this course

### What are exercise files?

Exercise files are the same files the author uses in the course. Save time by downloading the author's files instead of setting up your own files, and learn by following along with the instructor.

### Can I take this course without the exercise files?

Yes! If you decide you would like the exercise files later, you can upgrade to a premium account any time.

How to use exercise files.

Learn by watching, listening, and doing, Exercise files are the same files the author uses in the course, so you can download them and follow along Premium memberships include access to all exercise files in the library.

Exercise files

How to use exercise files.

This course includes free exercise files, so you can practice while you watch the course. To access all the exercise files in our library, become a Premium Member.

Are you sure you want to mark all the videos in this course as unwatched?

This will not affect your course history, your reports, or your certificates of completion for this course.

Congratulations

You have completed Excel 2007: Charts in Depth.

Become a member to add this course to a playlist

Join today and get unlimited access to the entire library of video courses—and create as many playlists as you like.

Become a member to like this course.

Join today and get unlimited access to the entire library of video courses.

Exercise files

Learn by watching, listening, and doing! Exercise files are the same files the author uses in the course, so you can download them and follow along. Exercise files are available with all Premium memberships. Learn more

How to use exercise files.

Thanks for contacting us.
You’ll hear from our Customer Service team within 24 hours.

Please enter the text shown below:

The classic layout automatically defaults to the latest Flash Player.

To choose a different player, hold the cursor over your name at the top right of any lynda.com page and choose Site preferencesfrom the dropdown menu.

• Mark video as unwatched
• Mark ALL videos as unwatched
Exercise files

Access exercise files from a button right under the course name.

Mark videos as unwatched

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.

Interactive transcripts

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.

## Are you sure you want to delete this note?

Thanks for signing up.

We’ll send you a confirmation email shortly.

• new course releases
• general communications
• special notices

Keep up with news, tips, and latest courses with emails from lynda.com.

• new course releases