unit d excel Flashcards
charts
present information in a pictorial format, making it easier to see patterns, trends, and relationships
guidelines for planning a chart
determine purpose, determine results you want to see, identify worksheet data you want to illustrate, understand elements of a chart
pie chart
compares a part to a whole
line chart
shows trends over time
column chart
compares distinct objects levels using vertical format
bar
compares distinct object levels using horizontal format
area
shows how individual volume changes overtime in relation to total volume
scatter
compares trends over uneven time or measurement intervals
x axis
horizontal axis
y axis
vertical axis
category axis
contains names of data groups such as locations, months or years
value axis
contains numerical values that help interpret size or chart elements
z axis
contained in 3d charts for comparing data
tick marks
on the left edge of vertical axis
plot area
area inside horizontal and vertical axis
gridlines
will extend across the plot area
data point
each value point selected in a cell
data marker
visually represents each data point
data series
collection of related data point
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 charts border
chart sheet
sheet in a workbook that contains only a chart, which is linked to the workbook data
object
an independent element on a worksheet
minor gridlines
shows values in-between the tick marks
text annotations
labels that further describe your data
