Join Richard Harrington for an in-depth discussion in this video Using a doughnut chart, part of Excel 2013: Working with Charts and Graphs.
- A doughnut chart is similar…to looking at a column chart or a bar chart,…but it adds the ability to represent the data…much like a pie chart.…You're going to take the overall values…and curve them around,…so think of it this way,…it's like a column chart that you wrapped into a pie.…In this particular case, I've got sales data…for four quarters, for two years.…Let's highlight that, and we'll press Ctrl+T…to turn this into a table,…and tell it to use the tables as headers.…
There we go.…We have the quarters, and then the values for each quarter.…Now what I want to do is I'll select that data.…Ctrl+A selects everything in the table,…and I could choose to Insert the doughnut chart.…Now you won't necessarily see that here,…so you can always pop this out…and that will bring up the Insert Chart dialog.…You'll find the doughnut chart…under the All Charts view,…and it's located under Pie.…So just click it at the end there,…and what you're seeing is the change in value.…
Alright, this is pretty clear.…I want to see these broken down by quarters,…
Author
Released
3/7/2015- Creating a chart
- Picking a chart type
- Displaying data with tables
- Editing data in a chart
- Adding SmartArt graphics
Skill Level Appropriate for all
Duration
Views
Related Courses
-
Excel 2013: Shortcuts
with Curt Frye3h 16m Intermediate -
Excel 2013: Macros
with Dennis Taylor2h 43m Intermediate -
Excel 2013: Charts in Depth
with Dennis Taylor3h 46m Advanced -
Excel 2013 Tips and Tricks
with Dennis Taylor4h 34m Appropriate for all
-
Introduction
-
Welcome1m 48s
-
Exercise files39s
-
-
1. Chart Essentials
-
Creating a chart1m 37s
-
Editing data in a chart2m 44s
-
Viewing chart animations3m 46s
-
-
2. An Overview of Chart and Graph Types
-
Using a column chart6m 23s
-
Using a line chart3m 1s
-
Using a pie chart5m 59s
-
Using a bar chart4m 47s
-
Using an area chart4m 51s
-
Using a stock chart4m 9s
-
Using a doughnut chart3m 14s
-
Using a radar chart2m 55s
-
-
3. Displaying Data with Tables
-
Creating a table2m 52s
-
Working with headers2m 15s
-
Applying styles to a table4m 11s
-
-
4. Working with SmartArt
-
Adding a SmartArt graphic3m 50s
-
-
Conclusion
-
Goodbye50s
-
- Mark as unwatched
- Mark all as unwatched
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.
CancelTake notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press 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 a doughnut chart