Microsoft Office Tutorials and References
In Depth Information
Topic A: Inserting content from other
Inserting charts
Explanation
Another type of object you can insert into a Word document is an Excel chart. Charts
are useful for displaying numeric data in a graphic form. When you insert a chart, it is
created based on data in an Excel worksheet, as shown in Exhibit 2-3. If you update the
Excel worksheet data, the chart in Word will automatically be updated as well.
Exhibit 2-3: An Excel chart object in Word
To insert a chart based on new Excel data:
1 In Word, click the Insert tab.
2 In the Illustrations group, click Chart to open the Create Chart dialog box.
3 Select a chart type and click OK. Excel opens, displaying a worksheet with
sample data. A chart appears in Word, based on the sample Excel worksheet.
4 In the worksheet, replace the sample data with your own data. The chart will be
automatically updated based on the new data.
To insert a chart based on existing Excel data:
1 In Word, click the Insert tab. Click Chart to open the Create Chart dialog box.
2 Select a chart type and click OK. Excel opens, displaying a worksheet with
sample data. A chart appears in Word, based on the sample Excel worksheet.
3 In Excel, open the worksheet on which you want to base the chart.
4 In Word, click the Chart Tools | Design tab, if necessary. Then, in the Data
group, click Select Data to open the Select Data Source dialog box.
5 In the Excel worksheet that you want to use for the chart, drag to select the range
of cells you want to use.
6 Click OK.
In the future, each time you want to further edit the Excel worksheet values, you can
open the worksheet by clicking Edit Data Source in Word.
To adjust the layout of the chart in Word, click the Layout tab and specify options such
as legend position and data labels.
Search JabSto ::




Custom Search