Chapter 54 Charting tricks

Questions answered in this chapter:

  • How do I create combination charts?

  • How do I create a secondary axis?

  • How can I handle missing data?

  • How can I handle the appearance of hidden data?

  • How can I use pictures to add bling to my column graphs?

  • 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 place data labels on a chart based on the contents of cells?

  • How can I track sales-force performance over time?

  • How can I create a band chart to check whether inventory is within acceptable levels?

  • How can I store a chart as a template?

  • How can I use a thermometer chart to portray progress against ...

Get Microsoft Excel 2019 Data Analysis and Business Modeling, 6th 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.