Exam 9: Excel 4: Working With Charts

You can change a column chart to a clustered bar chart using the ____ dialog box.

A(n) ____ identifies each data series in a chart, generally with a different color.

Text annotations are ____ that you can add to further describe the data in your chart.

Critical Thinking Questions Case 1-1 You are the manager of the Sales department for a local clothing store that has three locations. You have prepared a worksheet containing data about the sales figures for the company, which also has a chart to illustrate of the data. You want to use a shape style to change the look of your chart, but first you want see a Live Preview of how it will look. What do you do with the pointer to see a Live Preview?

To create a combo chart, select the data you want to plot, and click the Combo chart button in the Charts group on the _____ tab.​

When the mouse pointer hovers over any chart object, the name of the selected object appears on screen as a(n) ____________________.

Each value in a cell selected for a chart is called a ____.

In a pie chart, you can emphasize one data point by plotting , or pulling that slice away from, the pie chart. _________________________

Data ____________________ appear next to data markers in a chart and can indicate the series name, category name, and/or the value of one or more data points.​

Chart annotations are labels  that further describe your data.​ ____________________

The horizontal axis is also called the value axis.

Shape ____ make it possible to apply multiple formats to a data series, such as an outline, fill color, and text color, all with a single click.

An example of a(n) ____ chart is a column chart with a line chart.

Critical Thinking Questions Case 1-1 You are the manager of the Sales department for a local clothing store that has three locations. You have prepared a worksheet containing data about the sales figures for the company, which also has a chart to illustrate of the data. If you want to reposition the chart by changing a page's margins, where do you find the Show Margins button to display the margins in preview?