Use Word to create a chart from existing Excel data
You don't need Microsoft Excel to chart data in an existing Excel file; you can simply import that data and chart it entirely in Microsoft Word. Follow these steps:
- Put your cursor where you want your chart to appear in your Word document.
- Go to Insert | Picture | Chart.
- In the Graph's Standard Toolbar, click the Import File button.
- Navigate to the folder that contains the Excel file you want to import, and double-click the file's icon.
- Click the worksheet you want to import in the Select Sheet From Workbook list box.
- Click the range option and enter the cell range of the data you want to chart.(For example, if the data you want to chart is located in cells A3 through D7 of the Excel worksheet, enter A3:D7.)
- Click OK.
The specified data will be plotted in the chart. You can now make any format changes to the chart using Word's Graph Standard toolbar.
Add an Excel chart to a comment
There may be times when you want to display a Microsoft Excel chart with your data, but you don't want it to take up the space on the worksheet. One solution is to place the chart in a comment.
First, create your chart and cut and paste it to a drawing program such as Paint. Save the chart as a picture file and then go back and insert a comment in the worksheet.
To add the chart to the comment, follow these steps:
- Double-click the comment.
- Select the Colors And Lines tab.
- In the Fill section, select Fill Effects From The Color drop-down list.
- Select the Picture tab and then click the Select Picture button.
- Navigate to the file that contains the chart and click the Insert button.
- Click OK twice.
Now you can simply point to the cell that contains the comment and the chart is displayed.
Add a title page to your Access report
Microsoft Access reports automatically come with page headers and footers, but what if you want a title page at the beginning of your report? A title page for a report consists of the report header minus any page headers and footers.
For instance, let's say you want to add a title page to your Employees Report that consists of your company name and the name and date of the report. Here's how to add the title page:
- Open the Employees Report in design view and add a report header by selecting View | Report Header/Footer from the Menu bar.
- Design your title page by adding the appropriate controls for the information (or images) you want on the page to the Report Header section. Resize the Report Header section to the length of the page.
- If the Report Properties Box is not visible, click the Properties button in the Report Design toolbar to activate it.
- Select Report in the Report Properties drop-down list box.
- Under the Format tab, click the Page Header property drop-down list and select Not With Rpt Hdr.
- Click the Page Footer property drop-down list and select Not With Rpt Hdr.
- Select Report Header in the Report Properties drop-down list.
- Under the Format tab, select Force New Page from the drop-down list and select After Section.
You'll notice that adding a title page makes your report look a bit more polished.