Formatting Charts & Sparklines¶

A default chart is functional; a formatted chart is persuasive. Small touches make data readable at a glance.

A polished, well-labeled line chart on a report

The Three Chart Buttons¶

When a chart is selected, three buttons appear at its top-right:

Button	Controls
+ Chart Elements	Title, labels, legend, axes, gridlines
🖌 Chart Styles	Pre-built color/style themes
🔽 Chart Filters	Show/hide specific series or categories

+Add a descriptive **title** ("Q1 Sales by Region", not "Chart 1")

+Add **data labels** so readers see exact values

+Remove clutter: drop redundant gridlines and legends

+Use one accent color; grey out the rest to highlight a key bar

−Don't use rainbow colors, 3-D effects, or busy backgrounds

Right-click chart → Change Chart Type
Right-click chart → Select Data   (add/remove series)

To plot Sales (large numbers) and Growth % (small) together, use a combo chart with a secondary axis:

Change Chart Type → Combo
  Sales  → Clustered Column   (primary axis)
  Growth → Line, Secondary Axis ✓

A sparkline is a mini chart that fits in a single cell — perfect beside a row of data.

Insert → Sparklines → Line (or Column / Win-Loss)
Data Range:     B2:M2     (12 months)
Location:       N2        (one cell)

| Region | Jan…Dec | Trend |
| North  | ...     | ╱╲╱   |   ← a tiny line chart inside cell N2

Tip

Sparklines make summary tables instantly scannable: one trend line per row shows the shape of the data without a full chart.