Exam 3: Determining Effective Data Display with Charts

Use the Trendline options on the Chart Elements menu to specify whether the x- and y-axes are displayed.

Bubble charts allow three-dimensional data to be plotted in three dimensions on two axes. _________________________

Ross discovers a second way to change the rows and columns without opening a dialog box: He simply clicks the Switch Row/Column button in the Data group on the ____ tab.

A(n) ____________________ combines the features of a line chart with a bar or column chart by filling in the area below the line, and displaying the trend of values over time or categories.

In the Format Data Labels task pane, use the options in the ____ category to specify the alignment (horizontal or vertical), orientation, position, and direction of the data labels.

To create a chart in Excel, you first select the data you want to display in the chart, and then click the ____ tab on the ribbon.

When a chart is selected, two contextual chart tools appear on the ribbon, and they do NOT include ____.

Although doughnut charts are not a chart sub-type, they are related to ____ because of the type of data displayed.

In a(n) ____ chart, values are indicated by the height of the columns.

Stacked charts do a good job of illustrating the ____ effects of data in categories.

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

Doughnut charts are a way to show the information contained in a pie chart for ____.

In the Format Data Labels task pane, use the ____________________ option to change the appearance of a data label's 3-D format.

What is one of the weaknesses of the column chart shown above?

In the ____ chart type, values are indicated by areas with colors or patterns on the surface of the chart.

Briefly describe the eight common areas of a chart: chart title, y-axis, y-axis labels, x-axis, x-axis labels, data series, data points, and legend.

The ____________________ dialog box, which is available from the shortcut menu for a selected chart, provides options for modifying the values used to generate a chart.

An area chart combines the features of a ____ by filling in the area below the line, and displaying the trend of values over time or categories.

Using the ____ in a chart is a common way to include widely differing sets of data from the same time period.

Looking at the column chart, which category/categories is/are decreasing in sales each year?