Access 2016 Advanced

Lesson 5 – Using Charts

Access 2016

It is important to note that a chart appears in a control. Microsoft Graph is used to edit the chart and chart data in the control. Formatting changes, such as moving or resizing the, are accomplished by manipulating the control in Design view.

The datasheet window consists of rows and columns where you can enter labels and numbers. The rows are identified with numbers and the columns are identified with letters. The intersection of a row and column identifies the cell with a cell address, such as A1, CA10, DE100 and so on. When you make a change in the datasheet, the changes are reflected in the chart.

The major parts of the datasheet window are listed in the following table:

Part

Description

Identifiers to the left of the first column in the datasheet.

Row headings

Column headings

Identifiers above the top row of the datasheet.

Cell

Intersection of a column and row.

Data point

Single cell value.

Data series

Row or column of data.

Series names

Names used to identify each data row or column that appears in the Chart window legend.

The major parts of the chart window are listed in the following table:

Part

Description

Chart

Area inside the Chart window.

Data marker

Item in a chart marking a single data point or value, such as a bar, shape, or symbol. Group of data points. A chart can have one or more data series. Describes the data or items in a chart and is linked to a chart item, such as a data marker. Attached text moves with the item it is linked to, and cannot be moved independently. Describes the data or items in a chart. Because it is not linked, you can move unattached text anywhere on a chart.

Data series

Attached text

Unattached text

Page 54

OFFICEPRO, Inc.