O'Reilly logo

Microsoft Excel 2013: Data Analysis and Business Modeling by Wayne L. Winston

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required