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.
Our chart will ...