New Feature: Playlist Center! Pick a topic and let our playlists guide the way.

Start learning with our library of video tutorials taught by experts. Get started

Excel 2007: Charts in Depth
Illustration by

Using pie charts


From:

Excel 2007: Charts in Depth

with Dennis Taylor

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.
Expand all | Collapse all
  1. 1m 49s
    1. Welcome
      1m 3s
    2. Using the exercise files
      46s
  2. 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. 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
    4. Creating presentation-ready charts with just a few adjustments
      3m 10s
  4. 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. 11m 25s
    1. Using pictures as chart elements
      3m 55s
    2. Adding shapes and arrows
      3m 37s
    3. Adding floating text and text boxes
      3m 53s
  6. 33m 45s
    1. Adding, editing, and removing chart titles
      3m 15s
    2. Adding horizontal and vertical titles
      3m 56s
    3. Linking titles to content
      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. 8m 13s
    1. Modifying axis scaling
      3m 50s
    2. Working with gridlines
      4m 23s
  8. 12m 53s
    1. Analyzing existing and future data with trendlines
      4m 2s
    2. Adding drop lines
      3m 14s
    3. Adding high-low lines and up-down bars
      1m 39s
    4. Adding error bars
      3m 58s
  9. 9m 13s
    1. Selecting shape fill and outline
      3m 3s
    2. Adding shape effects
      3m 19s
    3. Applying WordArt styles
      2m 51s
  10. 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. 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. 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. 6m 19s
    1. Printing charts
      6m 19s
  14. 19s
    1. Next steps
      19s

Watch this entire course now—plus get access to every course in the library. Each course includes high-quality videos taught by expert instructors.

Become a member
please wait ...
Excel 2007: Charts in Depth
3h 36m Intermediate Jun 15, 2011

Viewers: in countries Watching now:

In this course, Dennis Taylor shows how to analyze and communicate the value of data with charts in Excel. The course starts with the foundations: what the parts of a chart are, what the different types of charts are, and which charts work best for your data. The course then shows how to create a presentation-ready chart in minutes and offers dozens of in-depth tutorials on formatting and fine-tuning charts so they represent data clearly and accurately.

Topics include:
  • Identifying the plot area, chart area, gridlines, legends, and more
  • Selecting the right chart type
  • Creating charts instantly with shortcuts
  • Choosing a layout
  • Dealing with empty and hidden cells
  • Switching rows and columns for a different view of the data
  • Moving and resizing a chart
  • Inserting pictures and shapes
  • Adding labels to a chart
  • Analyzing existing and future data with trendlines
  • Changing a chart's data source
  • Printing charts
Subjects:
Business Charts + Graphs
Software:
Excel Office
Author:
Dennis Taylor

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.

There are currently no FAQs about Excel 2007: Charts in Depth.

 
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.

Become a member Download sample files See plans and pricing

Please wait... please wait ...
Upgrade to get access to exercise files.

Exercise files video

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.
Upgrade now


Exercise files

Exercise files video

How to use exercise files.

For additional information on downloading and using exercise files, watch our instructional video or read the instructions in the FAQ.

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.

join now Upgrade now

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.


Mark all as unwatched Cancel

Congratulations

You have completed Excel 2007: Charts in Depth.

Return to your organization's learning portal to continue training, or close this page.


OK
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.

Get started

Already a member?

Become a member to like this course.

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

Get started

Already a member?

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

Get started

Already a Premium member?

Exercise files video

How to use exercise files.

Ask a question

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.

Continue to classic layout Stay on new layout
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.

Control your viewing experience

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?

No

Notes cannot be added for locked videos.

Thanks for signing up.

We’ll send you a confirmation email shortly.


Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

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

Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

   
submit Lightbox submit clicked
Terms and conditions of use

We've updated our terms and conditions (now called terms of service).Go
Review and accept our updated terms of service.