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 ...
Get Creating Spreadsheets and Charts in Microsoft Office Excel 2007 for Windows: 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.
