O'Reilly logo

Creating Spreadsheets and Charts in Microsoft Office Excel 2007 for Windows: Visual QuickProject Guide by Maria Langer

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

7. add a chart

Excel includes a powerful and flexible charting feature that enables you to create charts based on worksheet information. Its chart formatting commands and options make 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.

hide a row

Our chart will ...

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