Chapter 9. Charting Spreadsheet Data

10-Second Summary

  • Recognize chart elements

  • Create a chart

  • Learn chart editing techniques

  • Use ink to annotate a chart

People get tired of looking at numbers. They want to see color, diagrams, and pictures that illustrate what you’re trying to say. Charts enable you to show at a glance what your numbers are leading up to. Readers will know instantly which region sold the most, which subsidiary is most profitable, or who has the highest turnover. And depending on the type of chart you choose, you can show complex relationships among various data items or a simple, easy-to-read bar chart.


A chart is a graphical representation of your data that’s designed to show readers at a glance the trends that your data suggests. ...

Get Faster Smarter Microsoft® Office System -- 2003 Edition now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.