Access 2016 Advanced

Access 2016

Lesson 5 - Using Charts

NOTE If the fields you need to create a chart are in different tables, create a query to combine the fields and then base the chart on the query results.



Procedures

1. Display All Access Objects in the Navigation Pane, if necessary.

2. On the Create tab in the Forms group select the Form Design button .

3. On the Design tab in the Controls group select the Insert Chart button . 4. Click the blank form. 5. Select the desired object from the Which table or query would you like to use to create your chart? list. . 7. Add the field containing the data you want to display in the chart from the Available Fields list box. 8. Add additional fields from the Available Fields list box as desired. 6. Select

9. Select . 10. Select the desired chart type.

11. Select . 12. Arrange the contents of the chart as desired.

13. Select . 14. Type a title for the chart. 15. Select whether to display a legend on the chart.

16. Select

.



Step-by-Step

From the Student Data directory, open CHART1.ACCDB . Create a chart using the Chart Wizard.

OFFICEPRO, Inc.

Page 49