- [Instructor] The next worksheet over, … Sunburst, has the same data, … but we can view the data differently. … This is somewhat like a doughnut chart. … I'll click over in columns A, B, and C > Insert tab. … Let's go to that same icon, Sunburst. … There it is, and here, too. … Making this a lot larger. … Move it to the upper-left corner. … We can see what's happening. … At a glance, we can make the assertion, … looks like a quarter of our people here … are in manufacturing. … We've got two rings. … The inner ring represents the data from column A. … Quality Control has a big chunk of people. … So does Project and Contract Services. … We're not seeing numbers or percentages, … but we get some sense of the percentage idea … based on the size of these, … just as we do in treemap but in a different way, of course. … Here, too, with data labels off to the right, … we want to add more data labels and put in the value. … And there we see it, and that makes a lot of sense. … And similar, as we did with treemap, …
Author
Released
9/26/2019- Chart essentials
- Fine-tuning charts with design tab choices
- Inserting pictures, shapes, and text boxes
- Adding shape effects
- Applying WordArt styles
- Working with chart text
- Changing the rotation of chart text
- Changing a chart's data source
- Printing and sharing charts
- In-cell chart alternatives
Skill Level Intermediate
Duration
Views
Related Courses
-
Excel: Advanced Formulas and Functions
with Dennis Taylor4h 35m Intermediate
-
Introduction
-
1. Chart Essentials
-
Overview of chart types3m 11s
-
Choose styles and layouts3m 42s
-
Change chart orientation3m 26s
-
2. Fine-Tune Your Charts
-
Add a chart element2m 31s
-
-
3. Adjust Chart Elements
-
Modify axes3m 22s
-
Link titles to content2m 59s
-
Add and edit data labels3m 28s
-
Add a data table3m 9s
-
Work with gridlines3m 19s
-
Use legends3m 22s
-
-
4. Format Tab Options
-
Work with shapes and arrows2m 56s
-
Add shape styles and effects3m 31s
-
Work with chart text2m 53s
-
Apply WordArt styles2m 5s
-
5. Work with Popular Chart Types
-
Column and bar charts3m 16s
-
Line and area charts3m 25s
-
-
6. Other Specialized Excel Charts
-
Combination charts3m 23s
-
Stock charts3m 30s
-
Scatter charts3m 30s
-
Bubble charts3m 27s
-
Radar charts3m 26s
-
Gantt charts3m 31s
-
-
7. New Excel Chart Types
-
Overview of new chart types2m 23s
-
TreeMap charts3m 24s
-
Sunburst charts1m 51s
-
Histogram chart3m 18s
-
Box and whisker chart3m 30s
-
Pareto chart2m 21s
-
Waterfall and funnel charts4m 19s
-
-
8. Change a Chart's Data Source
-
9. Print and Share Charts
-
Print charts3m 48s
-
-
10. In-Cell Chart Alternatives
-
Conclusion
-
Next steps25s
-
- 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: Sunburst charts