Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.

Normal Size Small Size show me how

Excel

CH 3: Charts

Term	Definition
100% stacked column chart	A chart type that places (stacks) data in one column per category, with each column the same height of 100%.
Area chart	A chart type that emphasizes magnitude of changes over time by filling in the space between lines with a color.
Axis	Category or incremental value labels to identify the measurements along the horizontal and vertical axes of a chart.
Axis title	A label that describes either the category axis or the value axis. Provides clarity, particularly in describing the value axis.
Bar chart	A chart type that compares values across categories using horizontal bars. In a bar chart, the horizontal axis displays values and the vertical axis displays categories.
Bubble chart	A chart type that shows relationships among three values by using bubbles to show a third dimension. The third dimension is indicated by the size of the bubble; the larger the bubble, the larger the value.
Category axis	The chart element that displays descriptive group names or labels, such as city names or departments, to identify data.
Category label	Text that describes a collection of data points in a chart.
Chart	A visual representation of numerical data and helps reveal trends or patterns to help people make informed decisions.
Chart area	A boundary that contains the entire chart and all of its elements, including the plot area, titles, legends, and labels.
Chart element	A component of a chart that helps complete or clarify the chart.
Chart filter	A setting that controls what data series are displayed or hidden in a chart.
Chart sheet	A sheet within a workbook that contains a single chart and no spreadsheet data.
Chart style	A collection of formatting that controls the color of the chart area, plot area, and data series.
Chart title	The label that describes the entire chart. The title is usually placed at the top of the chart area.
Clustered column chart	A type of chart that groups, or clusters, similar data into columns to compare values across columns.
Column chart	A type of chart that displays data vertically in columns to compare values across different categories.
Combo chart	A type of chart that displays data vertically in columns to compare values across different categories.
Combo chart	A chart that combines two chart types, such as column and line, to plot different types of data, such as quantities and percentages.
Data label	An identifier that shows the exact value of a data point on the value axis in a chart. Appears above or on a data point in a chart. May indicate percentage of a value to the whole in a pie chart.
Data point	A numeric value that describes a single value in a chart or worksheet.
Data series	A group of related data points that display in row(s) or column(s) in a worksheet.
Data table	A grid that contains the data source values and labels to plot data in a chart. A data table may be placed below a chart or hidden from view.
Doughnut chart	A chart type that displays values values as percentages of the whole but may contain more than one data series.
Error bar	Visual that indicates the standard error amount, a percentage, or a standard deviation for a data point or maker.
Exploded pie chart	A chart type in which one or more pie slices are separated from the rest of the pie chart for emphasis.
Gridline	A horizontal or vertical line that extends from the horizontal or vertical axis through the plot area to guide the reader's eyes across the chart to identify values.
Legend	A key that identifies the color, gradient, picture, texture, or pattern assigned to each data series in a chart.
Line chart	A chart type that displays lines connecting data points to show trends over equal time periods, such as months, quarters, years, or decades.
Pie chart	A chart type that shows each data point in proportion to the whole data series as a slice in a circle. A pie chart depicts only one data series.
Plot area	The region of a chart containing the graphical representation of the values in the data series.
Radar chart	A chart type that compares aggregate values of three or more variables represented on axes starting from the same point.
Sizing handles	A series of faint dots on the outside border of a selected chart or object; enables the user to adjust the height and width of the chart or object.
Sparkline	A small line, column, or win/loss chart contained in a single cell to provide a simple visual illustrating one data series.
Stacked column chart	A chart type that places stacks of data in segments on top of each other in one column, with each category in the data series represented by a different color.
Stock chart	A chart type that shows fluctuations in stock changes, such as the high, low, and closing stock prices for a given company on a given day.
Surface chart	A chart type that displays trends using two dimensions on a continuous curve.
Trendline	A line that depicts trends or helps forecast future data in a chart. For example, if the plotted data includes 2005, 2010, and 2015, a trendline can help forecast values for 2020 and beyond.
Value axis	The chart element that displays incremental numbers to identify approximate values, such as dollars or units, of data points in a chart.
X Y (scatter) chart	A chart type that shows a relationship between two variables using their X and Y coordinates. Excel plots one coordinate on the horizontal X-axis and the other variable on the vertical Y-axis. Used in educational, scientific, and medical experiments.
X-axis	A horizontal border that provides a frame of reference for measuring data horizontally on a chart.
Y-axis	A vertical border that provides a frame of reference for measuring data vertically on a chart.
Which type of chart is the least appropriate for depicting yearly rainfall totals fro five cities for four years?	Pie chart
What is the typical sequence fro creating a chart?	Select the data source, select the chart type, and then size and position the chart.
Which of the following applies to a sparkline?	Single-cell chart
If you want to show exact values for a data series in a bar chart, which chart element should you display?	Data lables
The value axis currently shows increments such as 50,000 and 100,000. What do you select to display increments of 50 and 100?	Show Axis in Thousands.
You want to create a single chart that shows each of five divisions' proportion of yearly sales for each year for five years. Which type of chart can accommodate your needs?	100% stacked column chart.
Currently, a column chart shows values on the value axis, years on the category axis, and state names in the legend. What should you do if you want to organize data with the states on the category axis and the years shown in the legend?	Click Switch Row/Column in the Data group on the Design tab.
Which tab contains commands to apply a predefined chart layout that controls which elements are included, where, and their color scheme?	Design
Which icon does not display to the right of a selected chart?	Chart Quick Analysis.
What indicates that the closing price was higher than the opening price in a stock chart?	A rectangle with a white fill color.
Chart type to compare multiple categories of data vertically.	Clustered column chart
Miniature chart contained in a single cell.	Sparkline
Chart type that shows trends over time in which the value axis indicates quantities and the horizontal axis indicates time.	Line chart
Label that describes the chart.	Chart title
Label that describes either the category axis or the value axis.	Axis title
Key that identifies the color, gradient, picture, texture, or pattern fill assigned to each data series in a chart.	Legend
Chart type that compares categories of data horizontally.	Bar chart
Chart that shows each data point in proportion to the whole data series.	Pie chart
Numeric value that describes a single value on a chart.	Data point
Chart that shows the high, low, and close prices for individual stocks over time.	Stock chart
Indicators that enable you to adjust the height and width of a selected chart.	Sizing handle
Horizontal or vertical line that extends from the horizontal or vertical axis through the plot area.	Gridline
Chart type that shows the relationship between two variables.	X Y (scatter) chart
Group of related data points that display in row(s) or column(s) in a worksheet.	Data series
Window of options to format and customize chart elements.	Task pane
Provides descriptive group names for subdividing a data series.	Category axis
Section of a chart that contains graphical representation of the values in a data series.	Plot area
Boundary that contains the entire chart and all of its elements, including the plot area, titles, legends, and labels.	Chart area
Descriptive label that shows the exact value of the data points on the value axis.	Data label
Displays incremental numbers to identify approximate values, such as dollars or units, of data points in a chart.	Value axis
Single data series	compares values for one set of data.
Multiple data series	compares two or more sets of data in one chart
3-D chart	___________ adds a third dimension to each data series, creating a distorted perspective of the data.
Trendline	a line used to depict trends and forecast future data.

Created by: TroyIS2241

Popular Computers sets

Definitions for Word Processing and the main parts of the MS Word 2010 window

WP Page Formatting

WP Paragraph Formatting terms

Review business letter parts

Review the three paragraph formats (block, indented, hanging indent)

WP font formatting features in Word 2010

Arkansas CBA unit 1 Hardware

"Know" box contains:
Time elapsed:
Retries: