ISDS 361B Ch. 3
PivotCharts
A graphical presentation created in Excel that functions similarly to a PivotTable.
Scatter Chart
A graphical presentation of the relationship between two quantitative variables. One variable is shown on the horizontal axis and the other on the vertical axis.
Line Chart
A graphical presentation of time series data in which the data points are connected by a line.
Bar Charts
A graphical presentation that uses horizontal bars to display the magnitude of quantitative data. Each bar typically represents a class of a categorical variable.
Scatter chart matrix
A graphical presentation that uses multiple scatter charts arranged as a matrix to illustrate the relationships among multiple variables.
Column Charts
A graphical presentation that uses vertical bars to display the magnitude of quantitative data. Each bar typically represents a class of a categorical variable.
Pie Charts
A graphical presentation used to compare categorical data. Because of difficulties in comparing relative areas on a pie chart, these charts are not recommended. Bar or column charts are generally superior to pie charts for comparing categorical data.
Bubble Chart
A graphical presentation used to visualize three variables in a two-dimensional graph. The two axes represent two variables, and the magnitude of the third variable is given by the size of the bubble.
Trendline
A line that provides an approximation of the relationship between variables in a chart.
Clustered Column Chart
A special type of column (bar) chart in which multiple bars are clustered in the same class to compare multiple variables; also known as a side-by-side-column (bar) chart.
Stacked-Column Chart
A special type of column (bar) chart in which multiple variables appear on the same bar.
Sparkline
A special type of line chart that indicates the trend of data but not magnitude. A sparkline does not include axes or labels.
Crosstabulation
A tabular summary of data for two variables. The classes of one variable are represented by the rows; the classes for the other variable are represented by the columns.
Heat Map
A two-dimensional graphical presentation of data in which color shadings indicate magnitudes.
Charts
A visual method for displaying data; also called a graph or a figure.
Pivot Table
An interactive crosstabulation created in Excel.