Exam 3: Determining Effective Data Display with Charts

As a general rule, you should place charts that are developed for presentation and printing on a chart sheet.

To emphasize categories of data and each category's contribution to the total, create a(n) ____________________ pie chart by dragging a pie slice away from the other slices in the pie.

In business, charts are typically used to summarize information so that it can be used by one person making a decision.

The ____________________ chart type compares sets of three values. Values are indicated by the size of the filled circles.

Data series are points in a data set at which the x-axis and y-axis values intersect.

Bubble charts can be problematic to work with since the source data must be selected without including ____.

The ____ is the descriptive text that identifies the chart's contents.

____ is a part of the chart that decorates more than informs.

An Excel chart requires ____ numeric data series in one chart.

Microsoft Excel ____ provide a visual representation of quantitative information, giving the viewer an overall picture of a set of data.

A ____ is a box that identifies the patterns or colors assigned to the data series in a chart.

Layered charts are known for doing a good job of illustrating the cumulative effects of data in categories. _________________________

Tufte's first principle, "Above all else show the data," is a reminder to show as large a range of data as possible.

Each segment in a radar chart is _____.

____ identify the categories plotted on the x-axis.

____ charts are named for their resemblance to the plots on radar screens as they scan a 360-degree circle.

A(n) ____ chart combines the features of a line chart with a bar or column chart by filling in the area below the line.

One available chart option is to create a 100% ____________________ chart, in which the plotted values are converted into percentages of the total amount within each category.

The Switch Row/Column button provides settings for swapping a data series between rows or columns.

Use a pie chart when it's most important to show relative percentages rather than values.