Chapter 52. Charting tricks

Questions answered in this chapter:

  • How can I create combination charts?

  • How can 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, and 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 use Excel 2013 to 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 ...

Get Microsoft Excel 2013: Data Analysis and Business Modeling 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.