If the data you want to plot as a chart already exists in a Microsoft Office Access database, an Excel worksheet, or a Word table, you don’t have to retype it in the chart’s worksheet. You can copy the data from its source program and paste it into the worksheet.
In this exercise, you will copy data stored in a range of cells in an Excel worksheet into a chart’s worksheet and then expand the plotted data range so that the new data appears in the chart.
USE the 05_ExistingData document and the 05_Sales workbook. These practice files are located in the Chapter07 subfolder under SBS_Word2007.
OPEN the 05_ExistingData document.
Press to move to the end of the document, right-click the chart, and then click Edit Data ...