Excel 2019 Bible

(singke) #1

Chapter 20: Getting Started with Excel Charts


20


FIGURE 20.38


A box & whisker chart that summarizes data for four groups


The Series Options section of the Format Data Series task pane contains some options for
this chart type.


Sunburst charts


Sunburst charts were introduced with Excel 2016. A sunburst chart is like a pie chart with
multiple concentric layers. This chart type is most useful for data that’s organized hier-
archically. Figure 20.39 shows an example of a sunburst chart that depicts a music collec-
tion. It shows the number of tracks by genre and subgenre. Note that some genres have no
subgenres.

Free download pdf