CIS111E Chapter 3 Charts
Home > Preview
The flashcards below were created by user
on FreezingBlue Flashcards.
Is a visual representation of numerical data that compares data and helps reveal trends or patterns to help people make informed decisions.
Contains the entire chart and all of its elements, including the plot area, titles, legend, and labels.
Is the region containing the graphic representation of the values in the data series. Two axes form a border around the plot area.
Is a horizontal border that provides a frame of reference for measuring data horizontally.
Is the vertical border that provides a frame of reference for measuring data vertically.
A key that identifies the color, gradient, picture, texture, or pattern assigned to each data series in a chart.
Each cell containing a value
A group of related data points that display in row(s) or column(s) in the worksheet.
Row and column labels (such as job titles, years, growth, etc.)
Display data vertically in columns.
Create a column charity compare values across difference categories.
Clustered column chart
Compares groups-or clusters-of columns set side by side for easy comparison.
Stacked column chart
Show the relationship of individual data points to the whole category. (Use the stacked column chart when you want to compare total values across categories, as well as to display the individual category values).
100% stacked column chart
Converts individual data points into percentages of the total value.
Compares values across categories using horizontal bars.
The horizontal axis display values, and the vertical axis display categories.
Displays lines connecting data points to show trends over equal time periods.
Shows each data point as a proportion to the whole data series.
Use a pie chart when you want to convey percentage or market share.
X Y (scatter) chart
Shows a relationship between two numerical variables using their X and Y coordinates.
Shows fluctuations in stock changes.
Black fill: opening price was higher than the closing price
White fill: closing price was higher than the opening price
A line blow the rectangle indicates that the lowest trading price is lower than the opening and closing prices.
A line above the rectangle indicates the highest trading price was higher than the opening and closing prices.
A chart in a separate worksheet
Is a component that completes or helps clarify the chart.
A collection of formatting that controls the color of the chart area, plot area, and data series.
Controls which data series and categories are visible in a chart.
Is a small line, column, or win/loss chart contained in a single cell.
What would you like to do?
Home > Flashcards > Print Preview