8

Getting Comfortable with the 19 Excel Charts

Excel 365 has 19 chart types, and some of these charts were added as recently as six years ago. Charts are very important and form the core of most of the data visualization that happens within Excel. Building dashboards in Excel requires ample use of visualization tools, from charts to slicers and conditional formatting.

For over 20 years, Excel had no more than 11 chart types, but the number of charts has almost doubled in the last seven years. This is a reflection of the very important role charts now play in modern reports and dashboards. A lot of charts that used to be very difficult to create in Excel are now possible.

The goal of this chapter is to give you the requisite knowledge of the ...

Get Building Interactive Dashboards in Microsoft 365 Excel now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.