15.1 Chart Types — Choosing the Right One

Every chart type tells a different story about your data. Choosing the wrong type confuses readers; the right type makes your point immediately obvious.

15.2 Inserting a Word-Native Chart

Word's built-in chart engine uses a mini Excel-like datasheet to store chart data — no separate Excel file is needed.

Step-by-Step: Insert a Chart

1. Position your cursor where the chart should appear in the document
2. Click the Insert tab → Illustrations group → Chart
3. The Insert Chart dialog opens — it shows all chart types in a left-hand list and subtypes (variations) as thumbnails across the top of the right panel
4. Select the chart type from the left list (e.g., Column, Line, Pie)
5. Select the specific subtype from the thumbnail gallery (e.g., Clustered Column, Stacked Column, 3-D Column)
6. Click OK
7. Two things appear:
   • A chart placeholder in your Word document (with sample data)
   • A small Excel datasheet opens alongside the document — this is where you enter your actual data

Entering Chart Data in the Datasheet

The datasheet works like a simplified Excel spreadsheet:

• Column A (Row 2 onwards) — the category labels (X-axis labels in a column/line chart; slice labels in a pie chart)
• Row 1 (Column B onwards) — the series names (appear in the chart legend)
• Data cells — the actual numbers for each data point
• The blue border around the datasheet indicates which cells are included in the chart — drag its corner to expand or reduce the data range

Editing Chart Data After Creation

1. Click the chart in Word to select it
2. Click the Chart Design contextual tab → Data group → Edit Data
3. — or — right-click the chart → Edit Data
4. The Excel datasheet reopens — edit values, add or remove rows/columns, rename series or categories
5. The chart updates in real time as you change values
6. Close the datasheet (X button on the Excel window) — the updated chart is saved in the Word document

Switching Rows and Columns

• Chart Design → Data group → Switch Row/Column
• This swaps what is on the X-axis with what is in the legend — useful when the default arrangement is not what you want (e.g., chart is showing series as categories instead of months as categories)

Selecting Data Range (Refine Which Cells the Chart Uses)

• Chart Design → Data group → Select Data
• The Select Data Source dialog lets you add, edit, or remove data series and adjust axis labels independently

15.3 The Chart Contextual Tabs

When a chart is selected in Word, three contextual tabs appear in the Ribbon:

Chart Design Tab

Format Tab

Three Chart Quick Buttons

When a chart is selected, three small icon buttons appear to its right edge:

• + (Chart Elements) — toggle on/off: Chart Title, Axis Titles, Legend, Data Labels, Data Table, Gridlines, Trendline, Error Bars
• 🎨 (Chart Styles) — quickly switch between style presets and colour palettes
• ⊽ (Chart Filters) — show/hide specific data series or categories without deleting them from the data source

15.4 Formatting Chart Elements

Every element of a chart can be formatted individually — double-clicking any element opens its formatting pane on the right side of the Word window.

Common Chart Elements and How to Format Them

Formatting the Value Axis (Numbers)

The value axis (Y-axis on column/line charts) often needs custom number formatting to match your data type:

1. Double-click the Y-axis numbers to open the Format Axis pane
2. Click Axis Options → expand the Number section
3. In the Format Code field, enter your number format:
   • R #,##0 — Rand with thousands separator (R 1,250)
   • R #,##0.00 — Rand with two decimals (R 1,250.50)
   • 0% — whole number percentage (75%)
   • 0.0% — percentage with one decimal (75.3%)
   • #,##0,, — divide by millions (shows 1.25 for 1,250,000)
4. Also set Minimum and Maximum bounds — do not leave these on Auto if your data starts far from zero, as the chart may show a misleading truncated axis

Adding a Trendline

1. Select the data series on the chart
2. Chart + button → tick Trendline — or — right-click the series → Add Trendline
3. In the Format Trendline pane, choose the type:
   • Linear — straight trend line (most common — shows overall direction)
   • Exponential / Logarithmic / Power / Polynomial — curved trends for non-linear data
   • Moving Average — smooths out fluctuations to show the underlying trend
4. Tick "Display Equation on chart" and/or "Display R-squared value" if you need to show the statistical fit
5. Set the Forward periods to extend the trendline as a forecast beyond your existing data

15.5 Chart Sizing, Positioning & Text Wrapping

Resizing a Chart

• Drag corner handles — click the chart outer border to select it (a border with white square handles appears) → drag any corner to resize
• Hold Shift while dragging a corner handle to maintain the chart's aspect ratio (proportional resize)
• Precise dimensions: Format tab → Size group → set exact Width and Height in cm
• Standard chart sizes for Word documents:
  • Full-width chart: 16 cm wide × 9–12 cm tall
  • Half-page chart: 8 cm wide × 7 cm tall
  • Inline quarter-page: 7.5 cm × 6 cm

Positioning a Chart

• Inline with text (default) — the chart sits on its own line, pushing text above and below. Move it by pressing Enter before it or placing your cursor before the chart.
• Text wrapping around the chart: Right-click the chart → Wrap Text → choose:
  • Square — text wraps around the chart's rectangular bounding box
  • Top and Bottom — text appears above and below but not beside the chart
  • Through / Tight — text wraps closely to the actual chart shape (rarely useful for charts)
  • Behind Text — the chart sits behind the text (rarely used)
  • In Front of Text — the chart floats above text (can obscure it)
• Once text wrapping is set to anything other than Inline, the chart can be dragged anywhere on the page freely

15.6 Inserting an Excel Spreadsheet as an Object

Embedding or linking an Excel spreadsheet brings the full power of Excel — formulas, formatting, pivot tables — directly into your Word document. There are two distinct approaches: embedding (a self-contained copy) and linking (a live connection to an external file).

Method 1 — Embed a New Blank Excel Spreadsheet

1. Click in the Word document where the spreadsheet should appear
2. Insert tab → Text group → Object → Object…
3. In the Object dialog → Create New tab
4. In the "Object type" list, select Microsoft Excel Worksheet
5. Click OK
6. An Excel grid appears embedded in the Word document with full Excel Ribbon — enter your data and formulas directly
7. Click anywhere outside the Excel area to return to Word — the spreadsheet displays as a rendered table in the document
8. Double-click the embedded spreadsheet at any time to re-enter Excel editing mode

Method 2 — Embed an Existing Excel File

1. Insert → Object → Create from File tab
2. Click Browse… → navigate to the existing .xlsx file → click Insert
3. Leave "Link to file" unticked — this embeds a static copy of the spreadsheet inside the Word document. Changes to the original Excel file do NOT affect the embedded version.
4. Click OK
5. Double-click to open the embedded Excel environment and edit it independently of the original file

Method 3 — Link to an Existing Excel File (Live Connection)

1. Insert → Object → Create from File → Browse → select the .xlsx file
2. Tick "Link to file"
3. Click OK
4. The spreadsheet appears in Word showing the current data. When the original Excel file is updated and saved, the Word document updates to reflect the changes when you open it (or manually: right-click the object → Update Link)

Paste Special — Pasting Excel Data into Word

An alternative to embedding the whole spreadsheet: copy Excel data and paste it into Word with specific formatting options.

1. In Excel: select your data range → Ctrl+C
2. In Word: Ctrl+Alt+V — or — Home → Clipboard → Paste → Paste Special…
3. Choose from the Paste Special options:

Editing an Embedded Excel Spreadsheet

1. Double-click the embedded object in Word
2. Word's Ribbon is replaced by the Excel Ribbon — you are now editing in Excel mode within Word
3. Enter data, write formulas, apply Excel number formatting, add charts within the spreadsheet
4. Click anywhere outside the object boundary to return to Word editing mode

Resizing an Embedded Spreadsheet Object

• Click the embedded object once (not double-click) — selection handles appear around the object boundary
• Drag any handle to resize — the object scales to show more or fewer rows/columns
• Right-click the object → Format Object → Size tab for precise dimensions

15.7 Quick Tables

Quick Tables are pre-formatted, ready-to-use table designs stored in Word's Building Blocks gallery — similar to Quick Parts but for tables. They save significant formatting time for common table layouts.

Inserting a Quick Table

1. Insert → Tables group → Table → Quick Tables
2. A flyout gallery shows built-in designs — scroll through and click to insert:
   • Calendar 1–4 — monthly calendar grids in different styles
   • Double Table — two side-by-side mini tables
   • Matrix — a grid for comparison data
   • Tabular List — a simple pre-formatted data list
   • With Subheads — a table with category subheadings
3. The table inserts with placeholder content — click each cell to replace the sample text with your own data

Saving a Custom Table to the Quick Tables Gallery

1. Format a table exactly as required (style, borders, shading, column widths, header row)
2. Select the entire table (click the ⊕ Table Selector)
3. Insert → Table → Quick Tables → Save Selection to Quick Tables Gallery…
4. In the Create New Building Block dialog:
   • Name — give it a descriptive name (e.g., "Corp Invoice Table")
   • Gallery — Tables (leave as default)
   • Category — create a custom category (e.g., "Acme Corp Templates")
   • Save in — Building Blocks.dotx (makes it available across all documents) or your custom template .dotx
5. Click OK — the table design is now available in the Quick Tables gallery

15.8 Chart Design Best Practices

A technically correct chart can still fail to communicate. These principles separate good charts from great ones.

Clarity Principles

• One key message per chart: Every chart should answer one specific question. If you need to show two unrelated ideas, use two charts.
• Chart title = the message: Instead of "Revenue by Month", write "Revenue peaked in July before the seasonal decline". The title should tell the reader what to conclude from the chart, not just describe the data.
• Label directly when possible: Data labels on bars or lines are often clearer than a separate legend that forces the reader to cross-reference. Remove the legend if direct labels are used.
• Start the Y-axis at zero (for bar/column charts): Truncating the axis makes differences look larger than they are and misleads the reader. The only exception is when the data range is very small relative to the absolute values (e.g., 99.1% to 99.8%).

Visual Design Principles

• Colour purposefully: Use your corporate colour palette. Use a single accent colour to highlight the most important bar or data point — make the rest grey or muted. Do not use colour just for decoration.
• Remove chart junk: Eliminate 3-D effects, heavy gridlines, redundant borders, background fills, and excessive tick marks. Every element that does not convey data should be removed.
• Font consistency: Use the same font family as the rest of your document. Keep font sizes readable — no smaller than 9pt for data labels, 10pt for axis labels, 12pt for the chart title.
• Consistent chart sizing: All charts in the same document should be the same size unless there is a specific reason for variation.
• Order matters in bar charts: Sort bars from largest to smallest (or vice versa) unless there is an inherent order (e.g., months, categories with a logical sequence). Alphabetical ordering is usually the least informative choice.

Quick Cleanup Checklist Before Finalising a Chart

15.9 Quick Self-Check

Q1: You need to show how a company's total revenue breaks down across five divisions (Marketing, Operations, Finance, HR, IT) as percentages of the whole. Which chart type should you use and what is a common mistake to avoid?

✓ Use a Pie Chart (or Doughnut Chart). The values must add up to a meaningful 100% — in this case, five divisions sharing total revenue is appropriate. Common mistake to avoid: using more than 5–6 slices (labels become unreadable), using 3-D effects (distorts perceived slice sizes), or using a pie chart to compare across multiple time periods (use column charts instead).

Q2: After inserting a chart in Word, you realise the months are showing as the legend and the product series are on the X-axis — which is the reverse of what you wanted. How do you fix this without re-entering the data?

✓ Click the chart to select it → Chart Design tab → Data group → click "Switch Row/Column". This swaps what is shown as the axis categories with what is shown in the legend — no re-entry of data required. The chart immediately rearranges to the correct orientation.

Q3: You have embedded an Excel spreadsheet in a Word annual report. A colleague updates the original Excel file with new figures. Will the embedded spreadsheet in Word update automatically? What should you have done differently if you wanted automatic updates?

✓ No — an embedded spreadsheet (Insert → Object → Create from File, without "Link to file" ticked) is a self-contained copy stored inside the Word document. Changes to the original Excel file have no effect on the embedded copy. To get automatic updates, you should have used "Link to file" — this creates a live connection so the Word document reflects the current state of the Excel file when updated. To update a linked object manually: right-click the object → Update Link.

Q4: Your bar chart's Y-axis currently shows values from 80 to 100, making the differences between bars look very large. The actual values are 88, 91, 95, and 99. What is the problem and how do you fix it?

✓ The Y-axis minimum has been set (or auto-defaulted) to 80 instead of 0. This truncated axis makes the differences look proportionally much larger than they are in reality — a form of visual distortion that misleads readers. Fix: double-click the Y-axis → Format Axis pane → Axis Options → set Minimum to 0 (Fixed: 0). The bars will now show the true relative sizes of the values.

Q5: You frequently use the same invoice table layout (3 columns: Description, Qty, Amount — with specific border styles, shading, and column widths). How do you save this so it is available for quick insertion in any future Word document?

✓ Format the invoice table perfectly. Select the entire table (click the ⊕ Table Selector). Go to Insert → Table → Quick Tables → Save Selection to Quick Tables Gallery. Name it "Invoice Table", set Category to a custom name (e.g., "Company Tables"), save in Building Blocks.dotx → OK. The table now appears in the Quick Tables gallery for instant insertion in any future document. Share the Building Blocks.dotx file with colleagues to make it available across the team.

Q6: You want to add a straight trendline to a line chart showing monthly sales to visualise the overall growth direction. How do you add it, and what additional feature would you use to project the trend for the next 3 months beyond the existing data?

✓ Click the data series on the chart → click the + Chart Elements button → tick Trendline → choose "Linear" from the sub-menu (or right-click the series → Add Trendline → select Linear in the Format Trendline pane). To project forward 3 months: in the Format Trendline pane → Trendline Options → set "Forward" periods to 3. The trendline extends 3 data points beyond the last actual data point, showing the projected trend direction.

✓ Module 15 Complete — You Have Learned:

• Twelve chart types — Column, Bar, Line, Pie, Doughnut, Area, Scatter, Combo, Waterfall, Funnel, Histogram, Box & Whisker — with best use cases and examples
• Pie chart rules — max slices, 100% requirement, when to use alternatives
• Inserting a Word-native chart — Insert Chart dialog, chart type selection, the datasheet structure (categories, series, data cells, blue border)
• Entering and editing chart data — datasheet navigation, editing after creation via Chart Design → Edit Data, Switch Row/Column, Select Data
• The three chart contextual tabs — Chart Design (Layouts, Styles, Data, Type) and Format (Current Selection, Shape Styles, Size)
• The three chart quick buttons — + Elements, 🎨 Styles, ⊽ Filters
• Formatting chart elements — Chart Title, Data Series, Data Labels, Axes, Legend, Plot Area, Chart Area, Gridlines — all with double-click to format pane
• Formatting the value axis — custom number format codes (R #,##0, 0%, #,##0,,), Minimum/Maximum bounds
• Adding and configuring trendlines — all types, Display Equation, Forward period forecast
• Chart sizing (drag handles, precise dimensions), positioning, and text wrapping options
• Embedding a new blank Excel spreadsheet — the full Excel environment within Word
• Embedding an existing Excel file — static copy, controlling visible cells
• Linking to an Excel file — live connection, auto-update behaviour, manual update via right-click
• Embedded vs Linked comparison — when to use each (4-scenario table)
• Paste Special — 5 paste options (Excel Object, RTF, Plain Text, Picture, Paste Link) with use cases
• Quick Tables — inserting from gallery and saving custom table designs to the gallery
• Sharing Building Blocks.dotx across the team
• Chart design best practices — clarity principles (one message, title = conclusion, label directly, Y-axis from zero)
• Visual design principles — colour strategy, removing chart junk, font consistency, bar ordering
• 7-item chart cleanup checklist with step-by-step fixes for each item