Unit D Flashcards
present information in a pictorial format, making it easier to see patterns
Charts
determine purpose
determine results you want to see
identify worksheet data you want to illustrate
understand elements of a chart.
Guidlines for planning a chart
comparing a part to a whole
pie chart
shows trends overtime
line chart
compares distinct object levels using a vertical format
column
compares distinct object levels using horizontal format
bar
shows how individual volume changes
area
compares trends over uneven time
Scatter
horizontal axis
X-axis
vertical axis
y-axis
contains names of data in groups
category axis
contains numerical values that help interpret size of chart
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 represented in each data point
data marker
collection of related data points
data series
identifies the data series
legend
you must first make a spread sheet – then click insert, chart
to create a chart in excel
means it is inserted directly in 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
chart sheet
