Chapter 23

Graphing data using Excel charts

Choosing from recommended charts

Easy combo charts

Creating a frequency distribution with a histogram chart

Showing financial data with a waterfall chart

Mapping geographic data with a filled map chart

Saving time with charting tricks

Between Excel 2016 and Excel 2019, two new charts were added to Excel: the funnel chart and the filled map chart.

Before getting to the new charts, the chapter covers general techniques for creating graphs.

After you have the chart, a paintbrush icon offers 10 to 15 ways to style the chart. Styles range from minimalist to intense. If you are a disciple of Professor Edward R. Tufte and you believe every bit of ink on the chart must have a meaning, you will prefer minimalist ...

Get Microsoft Excel Inside Out (Office 2021 and Microsoft 365) 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.