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.
Made with FlippingBook - Online magazine maker