Excel Unit D Flashcards
Charts
(graphs) present information in a pictorial format, making it easier to see patterns, trends, and relationships
Guidlines for planing chart
Determine purposed, Determine results you want to see, Identify worksheet data you want to illustrate, Understands elements of a chart
Pie chart
compares parts to the whole
Line cart
shows trends over time
Column
Compares distinct object levels using a vertical format
Bar chart
Compared distinct object levels using a horizontal format
Area
shows how individual volume changes over time in relation to total volume
Scatter
compares trends over uneven time or measurements intervals
X-axis
horizontal axis
Y-axis
vertical axis
Category axis
(horizontal) contains names of data groups such as locations dates and years
Value axis
(vertical) contains numerical values that help interpret size of chart elements
Z-axis
contained in 3-D charts for comparing data across both categories and values
Plot area
inside of the axis
Tick marks
left edge of the vertical axis
Gridlines
extend across the plot area
Data point
each value selected in a cell
Data marker
visually represents each data point
Data series
collection of related data points
LEGEND
identifies the data series
to create a chart in excel
you must first make a spreadsheet - then click insert, chart
Embedded
means it is inserted directly in a current worksheet
Sizing handles
small series of dots at the corners and sides of the chart’s border -
Chart sheet
sheet in a workbook that contains only a chart - wich is linked to the workbook
Object
independent element on a worksheet
Minor gridlines
show the values between the tick marks
Text annotations
labels tat further describe your data
Exploding
pulling a slice if pie away for emphasis
