9  Graphing in Excel

Excel builds a chart from a selection: highlight the numbers, choose a chart type, and it draws one. Getting a chart that is worth showing anyone takes a few more steps, and this chapter walks through them.

Learning Objectives

By the end of this chapter, you will be able to:

• Build a bar, line and scatter chart from a range of cells
• Add and edit titles, axis labels and legends
• Adjust an axis, and know when changing its range misleads
• Save or copy a chart into a document

9.1 Building a Chart

(to write – this chapter needs screenshots of the Insert Chart menu and the chart elements panel, and a worksheet with a few charts already built.)