MO-211: Manage Advanced Charts and Tables

A dual-axis chart plots two data series with different scales (say, revenue in dollars and units sold as a count) against two separate vertical axes on the same chart, so neither series is visually flattened by the other's scale. It's built by changing one series to a secondary axis via Format Data Series, not by inserting a special chart type.

The specialty chart types — Box and Whisker, Combo, Funnel, Histogram, Sunburst, and Waterfall — are each suited to a specific kind of story: Box and Whisker for statistical distribution and outliers, Histogram for frequency distribution, Waterfall for a running total that increases and decreases in steps (like a cash-flow breakdown), Funnel for values decreasing through stages, Sunburst for hierarchical/nested categories, and Combo for mixing chart types (like columns and a line) in one chart.

You don't need to memorize a textbook definition of each type — you need to recognize which one a task's described outcome is asking for. A task describing 'a chart showing how a starting value increases and decreases to a final value' is asking for Waterfall by description, not by name.

PivotTables have no equivalent anywhere on MO-210 — this is genuinely new territory. A PivotTable summarizes and reorganizes data interactively: drag a field into Rows, Columns, Values, or Filters, and the table recalculates without touching the source data.

Slicers are visual filter buttons that connect to a PivotTable (or table) and make filtering a click instead of a dropdown menu — Insert > Slicer, then choosing which field to filter by. Grouping PivotTable data (right-click a field > Group) combines individual values into ranges or categories, commonly used to group dates into months/quarters or numbers into bins.

Calculated fields add a new field to the PivotTable computed from existing fields (PivotTable Analyze > Fields, Items & Sets > Calculated Field) — different from a calculated column in the source data because it's computed inside the PivotTable itself. Value field settings (right-click a value > Value Field Settings) control how a field summarizes — sum vs count vs average — and how it's displayed, including showing a value as a percentage of the total.

A PivotChart is a chart connected to a PivotTable's data, so filtering or restructuring the PivotTable updates the chart automatically. You create one from Insert > PivotChart, either from an existing PivotTable or building both together from raw data.

Manipulating options in an existing PivotChart and applying styles works much like a normal chart, but with the added layer of PivotChart-specific field buttons on the chart itself, which can be shown or hidden.

Drilling down into PivotChart details means double-clicking a data point to see the underlying rows that make it up, which Excel places on a new worksheet — a genuinely useful skill for real analysis work, and a specific interaction worth practicing rather than reading about, since it isn't obvious from the ribbon alone.