Excel - Ch 3 Flashcards
Visual representation of numerical data that compares data and reveals trends/patterns to help make informed decisions
Chart
Cell containing a value
Data Point
Group of related data points that display in rows/columns in the worksheet
Data Series
Container for the entire chart and its elements
Chart Area
Region containing the graphical representation of the values in the data series; two axes form a border around it
Plot Area
Horizontal border for measuring data left to right
X-Axis
Vertical border that provides reference for data up and down
Y-Axis
Key that identifies colour/gradient/picture/texture/pattern designated to each data series in a chart
Legend
Displays descriptive labels for data points
Category Axis
Displays incremental numbers to identify approximate values
Value Axis
Displays values in vertical columns where height represents value
Column Chart
Displays values horizontally where length represents value
Bar Chart
Displays data on horizontal axis and value on vertical axis
Line Chart
Shows proportion of individual data points to the whole/total of all data points
Pie Chart
Combines two chart types to plot different types of data
Combo Chart
Contains commands for creating a variety of charts
Insert Tab
Compares groups side by side (Column)
Clustered Column Chart
Shows relationship of individual data points to the whole category; each is colour coded; comparing totals (Column)
Stacked Column Chart
Shows relationship between 2 numerical variables using their X & Y coordinates; used for scientific experiments
XY Scatter Chart
Created from moving a chart to a new sheet
Chart Sheet
Component that completes / helps clarify the chart
Chart Element
Describes the category / value axis (not displayed by default)
Axis Title
Describes entire chart ; should reflect purpose of the chart
Chart Title
Shows exact value or name of data point (not displayed by default)
Data Label
Grid that contains data source values & labels (only add on a chart sheet)
Data Table
Indicate standard error amount %, or standard deviation for data point or marker
Error Bars
Horizontal or Vertical lines that display in the plot area to help identify values
Gridlines
Depicts trends or helps forecast future data (estimation)
Trendline
Window options to format & customize chart elements
Task Pane
Slice of a Pie Chart that is moved away to stand out
Exploded Pie Chart
Collection of formatting that controls colour of the chart area, plot area, data series
Chart Style
Controls which data series & categories are visible in the chart
Chart Filter
Small Line / Column / Win/Loss contained in a single cell; purpose is to present condensed, simple, succinct visual illustration of data; helps to understand data quickly without a full chart
Sparkline
Types of Sparklines
Line
Column
Win/Loss