Access 2016 Advanced

Lesson 5 – Using Charts

Access 2016

W ORKING WITH C HARTS



Discussion

Access allows you to enhance forms and reports by adding graphs, pictures, and other objects. For example, the Chart Wizard assists you in creating charts quickly. Charts allow you to graphically represent information in a database. Charts can be either two or three dimensional, depending on the type and amount of data you need to represent. Access includes a number of charts from which you can choose. The Chart Wizard provides a description of each chart type to assist you in selecting the appropriate chart type for the data you are using. For example, a bar chart best represents comparisons of like data, such as quarterly profits, and a pie chart best represents parts of a whole, such as each salesperson’s contribution to overall sales. Many of the available charts are similar in the way they represent data but differ visually. For instance, replace the bars in a bar chart with cylinders or cones to provide a more dramatic effect. Depending on the chart selected, you may have a series field, a data field, and an axis field associated with the chart. After selecting the chart type and advancing the wizard, Access automatically inserts fields in the series, data, and axis boxes from those available. Change the contents of any box by dragging the field buttons in and out of the boxes .

A pie chart

Page 48

OFFICEPRO, Inc.