Access 2016 Advanced

Access 2016

Lesson 5 - Using Charts

Steps

Practice Data

3. Select Copy .

Click Copy

The chart object is copied to the Office Clipboard.

4. Close the form or report. The form or report closes.

Click

5. Open the desired form or report from the Navigation Pane in Design view. The form or report is selected. 6. Click in the desired section of the form or report. The desired section is selected. 7. On the Home tab in the Clipboard group click the Paste button. The chart object appears in the form or report.

Open the Sales Data report in Design view

Click in the Report Header section

Click

Drag the chart down to the 1cm mark on the vertical ruler to display the Sales Data chart title.

U SING M ICROSOFT G RAPH TO E DIT



Discussion

You may want to make changes to a chart to improve its appearance or emphasize aspects of the chart. You can change the chart type; the text of the chart, such as the title and the data labels; the colors used in the chart; and the actual data the chart displays. When editing a chart, Access displays an editing toolbar to allow you to quickly make changes. Use Microsoft Graph to modify charts in Access. The Microsoft Graph window consists of two elements. The first element is the datasheet window. The datasheet is a worksheet of the data used to create the chart. Changes to the data comprising the chart are made in the datasheet. The second element is the Chart window which displays a graphical representation of the data. Make a chart easier to read by revising its appearance, such as modifying the layout or formatting the title.

OFFICEPRO, Inc.

Page 53