Join Dennis Taylor for an in-depth discussion in this video Using pie charts, part of Excel 2007: 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.…
Author
Dennis Taylor
Released
6/15/2011- 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
Skill Level Intermediate
Duration
Views
-
Introduction
-
Welcome59s
-
-
1. Understanding Excel Chart Concepts
-
2. Creating Basic Charts Quickly
-
3. Fine-Tuning Charts with Design Tab Choices
-
Choosing a chart layout4m 33s
-
Moving and resizing a chart5m 14s
-
4. Layout Tab Options: Inserting Pictures, Shapes, and Text Boxes
-
Adding shapes and arrows3m 37s
-
5. Layout Tab Options: Adding Titles, Labels, and Legends
-
Linking titles to content2m 32s
-
6. Layout Tab Options: Using Axes and Gridlines
-
Modifying axis scaling3m 50s
-
Working with gridlines4m 23s
-
-
7. Layout Tab Options: Using the Analysis Tools
-
Adding drop lines3m 14s
-
Adding error bars3m 58s
-
8. Format Tab Options: Adding Shapes and WordArt Styles
-
Adding shape effects3m 19s
-
Applying WordArt styles2m 51s
-
9. Using Other Formatting Tools
-
Formatting lines and borders4m 24s
-
Working with chart text3m 40s
-
-
10. Adjusting Specific Chart Types
-
Using column and bar charts7m 24s
-
Using line charts5m 46s
-
Using pie charts8m 37s
-
-
11. Changing a Chart's Data Source
-
12. Printing and Sharing Charts
-
Printing charts6m 19s
-
-
Conclusion
-
Next steps19s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Using pie charts