Unit D Flashcards
present information in a pictorial format making it easier to see patterns trends and relationships
Charts
determine purpose determine results you want to see identify worksheet data you want to illustrate understand elements of a chart
Guidelines for planning a chart
compares part to a whole
Pie Chart
shows trends over time
Line Chart
compares distinct object levels using vertical format
Column
compares distinct object levels using a horizontal format
Bar
shows how individual volume changes over time in relation to total volume
Area
compares trends over uneven time or measurement intervals
Scatter
horizontal axis
X- Axis
vertical axis
Y-Axis
(horizontal) contains names of data groups such as locations, months, or years
Category Axis
(vertical) contains numerical values that help intemperate size of chart elements
Value Axis
contained in 3-D charts for comparing data across both categories and values
Z-Axis
area inside the horizontal and vertical axis
Plot Area
left edge of the vertical axis
Tick Marks
extend across the plot area
Gridlines
each value selected in a cell
Data Point
visually represents each data point
Data Marker
collection of related Data points
Data Series
identifies the data series
Legend
you must first make a spreadsheet-then click insert, chart
To create a chart in excel
means it is inserted directly into a current worksheet
Embedded
small series of dots at the corners and sides of the charts border
Sizing Handles
sheet in a workbook that contains only a chart which is linked to the workbook data
Chart Sheet
