Chapter 43

Basic charting

Questions answered in this chapter:

  • How do I create column charts in Excel?

  • How can I add bling to my column charts?

  • How do I create bar charts in Excel?

  • How do I create combination charts?

  • How do I create a secondary axis?

  • How do I handle missing data?

  • How do I handle the appearance of hidden data?

  • I charted annual sales data in a column graph, but the years do not show up as column labels. What did I do wrong?

  • How can I include data labels and data tables in my charts?

  • How can I make cool-looking pie charts?

  • How can I summarize time series data with line charts and stacked area charts?

  • How can I summarize relationships between two variables with a scatter chart?

  • How can I use a radar chart to summarize athletic performance ...

Get Microsoft Excel Data Analysis and Business Modeling (Office 2021 and Microsoft 365), 7th Edition 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.