4 Charting Spreadsheet Data Free Online FlashCards

Which chart types compare values across categories?

Bar or column charts make it easier to compare values across categories; bars can work especially well with long category names.

Which chart type shows change over ordered time?

Use a line chart to show how a measure changes over ordered time, keeping the time periods in chronological order.

What does a stacked chart emphasize?

A stacked bar or column chart shows how categories contribute to a total, emphasizing both composition and the overall amount.

When is a pie chart suitable?

Use a pie chart only for a small number of categories that add up to one meaningful whole.

Which chart shows frequencies within value ranges?

A histogram shows the distribution of values by displaying their frequencies within ranges, such as test-score intervals.

What does each point in a scatter chart represent?

A scatter chart plots pairs of values to examine the relationship between two numeric variables.

When can a combination chart be useful?

A combination chart can compare measures with different units or scales, such as revenue columns and a profit-margin line. Clearly label any secondary axis.

How should data be arranged before charting?

Arrange the data in a rectangular range with clear headings, categories in one column, and values to compare in neighboring columns. Remove unintended blanks, totals, and unrelated fields.

How should chart categories and numeric columns be mapped?

Categories belong on the category axis, and each numeric column should be a separate series. If grouped incorrectly, switch rows and columns or edit the data range.

Where should a magnitude-comparison bar chart's axis usually start?

Bar and column charts used to compare magnitudes usually should start at zero; a truncated axis can exaggerate differences.

What information should a clear chart title and axis labels provide?

Use a title that states what is measured and, when useful, the time period or population. Label axes and include units.

When should a chart include a legend?

Use a legend when multiple series need identification; remove it when a single series makes it uninformative.