📊 Lesson 5.2: Charts & Sparklines

Why Charts — Matching Type to Question

The most common charting mistake isn't a technical one — it's picking the wrong type. A chart is an answer to a question, and different questions want different shapes. Before you insert anything, ask what you're trying to show:

• Comparing categories ("which region sold most?") → column or bar chart.
• Change over time ("how did sales trend this year?") → line chart.
• Parts of a whole ("what share is each category?") → pie chart, but only with a few slices and honest labels.
• Relationship ("does price relate to sales?") → scatter chart.

Inserting & Editing a Chart

The workflow is simple:

1. Select your data — including the header labels, which become the chart's labels. A pivot table or a small summary table is ideal source data.
2. Insert → Chart. Sheets guesses a type; don't worry if it guesses wrong.
3. The Chart editor opens on the right with two tabs:
   • Setup — the chart type, the data range, and which rows/columns are the series vs the labels (the "X axis").
   • Customize — titles, axis labels and ranges, colors, legend position, gridlines, data labels, fonts.

A chart is live: it's linked to its source range, so when the data changes, the chart redraws automatically. Move it around by dragging, or use the chart's three-dot menu to cut/copy it, put it on its own tab, or download it as an image.

The Common Chart Types

Column vs bar is just orientation (vertical vs horizontal); bar charts are handy when category names are long. When in doubt between fancy options, a clean sorted column chart or a simple line chart answers most real questions.

SPARKLINE — Tiny In-Cell Charts

Sometimes you don't want a big chart — you want a tiny visual right beside a number. That's SPARKLINE: a mini chart that lives inside a single cell, perfect for a summary table or dashboard where each row gets its own little trend.

A simple line sparkline of a row of values:
=SPARKLINE(B2:M2)

A colored bar chart in a cell:
=SPARKLINE(B2:M2, {"charttype","column"; "color","#0f9d58"})

A win/loss sparkline (positive vs negative):
=SPARKLINE(B2:M2, {"charttype","winloss"; "negcolor","red"})

The second argument is a set of options in curly braces — pairs of an option name and its value. The main charttype values are line (the default), column, bar, and winloss. Because a sparkline is just a formula in a cell, you can copy it down a column so every row gets its own mini chart.

Honest, Clear Charts

A chart can mislead as easily as it can clarify — sometimes by accident. A few principles keep yours honest:

• Start bar/column axes at zero. A truncated axis exaggerates small differences into dramatic-looking gaps. (Line charts showing a trend can sometimes zoom in, but label it clearly.)
• Label directly. A clear title that states the takeaway ("West leads Q1 sales") and labeled axes beat a mystery chart the reader has to decode.
• Don't over-slice pies. More than about five slices and nobody can compare them; a sorted bar chart is clearer.
• Use color with purpose. Highlight the one series that matters; don't rainbow everything. Keep enough contrast for readers in both light and dark, and don't rely on color alone to convey meaning (accessibility).

⚠️ Important Note: Charts and pivot tables can be copied straight into Google Docs and Slides and stay linked to the source sheet — update the data and click "Update" in the doc to refresh the chart. That's a great way to keep a report always current — try it with your capstone charts in Lesson 8.3.

🎯 Project: A Small Chart Panel

You'll build a tidy little visualization panel from data you already have — the kind that could sit on a dashboard.

Line (default):   =SPARKLINE(B2:M2)
Green columns:    =SPARKLINE(B2:M2, {"charttype","column";"color","#0f9d58"})
Win/loss:         =SPARKLINE(B2:M2, {"charttype","winloss"})

Best Practices for Charts

✅ Do's

• Pick the type by the question — comparison, trend, part-of-whole, relationship.
• Chart from summaries and start value axes at zero.
• Title with the takeaway so the point lands instantly.

❌ Don'ts

• Don't truncate a bar axis to exaggerate differences.
• Don't over-slice pies or rainbow every series.
• Don't rely on color alone to convey meaning — label directly for accessibility.

📓 Learning Journal

📝 Lesson Summary

🎉 What You've Accomplished

You can now turn a table into a picture that makes its point at a glance — and you know how to keep that picture honest. Combined with pivot tables, you've got the two big tools for making data understandable to other people, which is often the whole job.

❓ Common Questions at This Stage

🔭 Looking Ahead

Next — Lesson 5.3: Conditional Formatting — we make the cells themselves react to their values, so problems and highlights jump out automatically. It's the finishing touch that makes a tracker feel alive.

✅ Before the Next Lesson

• Keep your chart panel — you'll reuse charts in the project and capstone modules
• Try one sparkline column on a summary table
• Write your Learning Journal entry for this lesson

📚 Additional Resources

• Add & edit a chart or graph (Google Support)
• SPARKLINE function (Google Support)