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.