Excel: Charting Data Flashcards

Which chart type displays three variables simultaneously using X position, Y position, and the size of each data point?

Answer: Bubble chart

A Bubble chart extends the Scatter chart by using a third numeric variable to determine the size (bubble diameter) of each plotted point.

When you move a chart from the current worksheet to a separate chart sheet, the chart's data source:

Answer: Remains linked to the original worksheet

Moving a chart to a chart sheet only relocates the chart object; the data still resides in and links to the original worksheet.

Which option in the Format Data Labels pane allows you to show the category name next to each data point?

Answer: Category Name checkbox under Label Contains

Checking 'Category Name' in the Label Contains section displays the category (axis label) alongside each data marker.

A Radar chart is best suited for which type of analysis?

Answer: Comparing multiple attributes of several items simultaneously

Radar (or spider) charts display multiple quantitative variables on axes radiating from a central point, ideal for comparing profiles across categories.

What does the 'Explosion' setting in the Format Data Point pane do for a Pie chart?

Answer: Pulls a single slice away from the rest of the pie

Explosion separates an individual slice from the body of the pie chart to emphasize that specific data point.

Which Excel feature lets you save a customized chart format so you can apply it to future charts quickly?

Answer: Chart Templates

Saving a chart as a Chart Template (.crtx file) stores its formatting, colors, and layout for reuse via the Change Chart Type dialog.

To change the color of a single bar in a Bar chart without affecting the other bars, you should:

Answer: Double-click the bar to select only that data point, then change its fill color

Double-clicking a bar deselects the whole series and selects only that individual data point, allowing independent color formatting.