Chapter 8. Charting (Graphing) the Worksheet Data

In this chapter

• Charting terminology you need to understand before you start.

• Charting data quickly and easily with the Chart Wizard and Chart toolbar.

• Opening a chart in its own window, so you can tweak its design.

• Formatting a chart's text, axes, and frame.

• Tilting and rotating 3-D charts for dramatic effects.

Graphs or charts , as Excel likes to call them, present data in a more meaningful, visual format. Instead of displaying a block of meaningless values, charts can help you compare annual sales figures, see which portions of a budget are devoted to various programs, analyze the growth of a portfolio, and much more. In this chapter, you learn how to create various types of charts in Excel and enhance those charts to achieve the desired effect.