Chapter 7. Add a Chart

Excel includes a powerful and flexible charting feature that enables you to create charts based on worksheet information. Its Chart Wizard makes it easy to create charts to your specifications. Best of all, if any of the data in a source worksheet changes, the chart automatically changes accordingly.

In Excel, charts can be inserted into a workbook file in two ways:

  • A chart sheet, as discussed in Chapter 2 and shown below, displays a chart on a separate workbook sheet.

  • An embedded chart is a chart that is added as a graphic object to a worksheet.

In this chapter, we'll create a pie chart of actual expenses for the quarter as a separate sheet within our Budget workbook file.

Get Creating Spreadsheets and Charts in Excel: Visual QuickProject Guide 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.