How to Make a Box and Whisker Plot in Word

To learn how to make a box and whisker plot in Word, place the cursor where the figure should appear and select Insert > Chart > All Charts > Box & Whisker. Word inserts the chart and opens an embedded Excel-style data sheet. Replace its sample values with your data, adjust the highlighted source range, and close the data window.

The result is an editable statistical chart stored inside the document. You can display multiple groups, change the quartile method, show outliers or mean markers, add a caption, and position the figure alongside your report text. Word’s main advantage is not advanced statistical analysis; it is the ability to build the chart directly into an assignment, research paper, or business report with controlled layout and publishing options.

Quick Word Workflow

1. Position the cursor where the chart belongs.
2. Select Insert > Chart.
3. Open All Charts.
4. Choose Box & Whisker and select OK.
5. Replace the sample values in the embedded data sheet.
6. Keep each comparison group in a separate labeled column.
7. Adjust the highlighted source range to include only your data.
8. Close the data sheet and review the chart.
9. Use Chart Design and Format Data Series to refine it.
10. Add a caption, alt text, and a suitable page layout.
11. Check the result in Print Preview and the exported PDF.

How to Make a Box and Whisker Plot in Word From Raw Data

Recent compatible desktop versions of Word can create the chart without requiring you to prepare it in a separate Excel file.

1. Choose the insertion point

Click in the document where you want the figure to appear. For a report, this is usually after the paragraph that first introduces the data or comparison.

Do not worry about exact positioning yet. Word inserts the chart as an object that can be resized or moved later.

2. Open the Insert Chart window

Go to the Insert tab and find Chart in the Illustrations group. In the Insert Chart dialog, choose All Charts, then select Box & Whisker.

Choose the available preview and click OK.

Word creates two connected elements:

• a chart object inside the document;
• an embedded Excel-style sheet containing its source data.

The worksheet may contain placeholder values. These values are examples only and must be replaced.

3. Replace the sample worksheet

Use the embedded grid to enter the following example:

Class A	Class B	Class C
62	68	58
65	70	61
67	72	63
69	74	66
71	75	68
73	77	70
74	79	71
76	80	73
78	82	75
94	84	77

Each column represents one data series. Its header supplies the series or category name displayed on the chart.

Class A, Class B, and Class C should therefore produce three side-by-side boxes. The value 94 in Class A may appear as a separate potential outlier, depending on the quartile calculation selected.

4. Correct the highlighted data range

The embedded sheet uses a colored outline to show which cells feed the chart. Make sure that outline covers all three headers and their observations—but no remaining placeholder rows or columns.

If the source range is too large, Word may include unwanted sample values or empty categories. Drag the range handle to fit your table, or use Chart Design > Select Data after returning to the document.

5. Close the data window

Close or minimize the embedded sheet when the data entry is complete. The Word chart remains in place and can be edited later.

To reopen the values, select the chart and choose:

Chart Design > Edit Data

Some versions also offer Edit Data in Excel, which opens a fuller spreadsheet interface for the embedded information.

What Word Calculates for the Chart

The chart summarizes each numeric series through quartiles and whiskers. The central box extends from the first quartile to the third quartile, representing the middle 50% of the observations. A line inside the box marks the median.

Whiskers extend beyond the box to show the non-outlier range under the chart’s selected rules. Values outside the outlier limits may appear as separate markers.

Word relies on Microsoft’s charting engine and the embedded spreadsheet data. It does not inspect whether the observations are reasonable, correctly entered, measured in matching units, or drawn from comparable groups.

Review the source before treating the chart as reliable. Check for:

• numbers entered as text;
• accidental duplicated values;
• missing observations;
• inconsistent units;
• formulas returning errors;
• placeholder data left in the sheet;
• headings included among the numeric observations;
• a source range that excludes part of a series.

A visually polished chart cannot correct invalid input.

Adjust the Statistical Display

Select a box in the chart, right-click it, and choose Format Data Series. The available Series Options control both appearance and statistical detail.

Gap width

Gap width changes the space between the plotted groups. A smaller gap generally creates wider boxes; a larger gap makes them narrower.

This is a design setting. It does not change the quartiles, median, or whiskers.

Show inner points

Inner points display individual observations that fall within the whisker range. They can add useful detail when each class or group contains only a modest number of values.

With a large sample, displaying every point may clutter the figure and hide the box itself.

Show outlier points

This option displays observations identified as potential outliers. If the option is switched off, the points disappear from view, but their cells remain in the embedded worksheet.

Hiding an outlier marker is not the same as removing, correcting, or excluding the observation. If the report does not display potential outliers, that design decision should not be used to imply that none exist.

Show mean markers

A mean marker commonly appears as an X or another symbol. It represents the arithmetic average.

The horizontal line inside each box is the median. The mean marker and median line are different statistics and may appear in different positions.

Show mean line

When several groups are displayed, Word may allow a line connecting their mean markers. This can help when the groups represent an ordered sequence, such as successive months.

Avoid connecting means when the categories have no natural order. A line can imply a trend that the data structure does not support.

Quartile calculation

The chart can offer inclusive and exclusive quartile methods. These approaches may produce different Q1 and Q3 values, particularly with small data sets.

Use the convention required for the assignment, analysis plan, or organization. If the report will be reviewed closely, state the method in the caption, figure note, or methods section.

The chart is intended to present the distribution, not establish which quartile convention is universally correct.

Repair Incorrect Groups or Labels

If Word produces one box instead of three, the chart engine may be reading the table in the wrong direction.

Select the chart and open:

Chart Design > Select Data

Review the listed data series and category labels. Each class should appear as a separate series, and each series should point to the corresponding worksheet column.

The Switch Row/Column command can reverse the interpretation. Use it only if the resulting categories match the intended structure. If switching creates many boxes—one for each row—the worksheet should be reorganized instead.

Clear column headers are especially important. Generic names such as Series 1 and Series 2 make the chart harder to interpret and can remain in legends, captions, or accessibility descriptions.

Add Titles Without Crowding the Figure

A chart inside a formal document should be understandable without relying on the surrounding paragraph for every detail.

Use Chart Design > Add Chart Element to add or adjust:

• chart title;
• axis titles;
• legend;
• gridlines;
• data labels where suitable.

A clear title for the example could be:

Distribution of Test Scores by Class

The numeric axis should identify its unit, such as:

Test score (points)

Keep chart wording concise. Long explanations belong in the figure caption or body text, not inside the plotting area.

Choose fonts that remain readable at the chart’s final printed size. A label that looks clear while the chart is enlarged on screen may become too small after the figure is fitted into a page column.

Direct, Embedded, Linked, or Pasted as a Picture?

Word provides several ways to place an existing Excel box plot into a document. The best choice depends on whether the figure must update, travel with the document, or remain locked.

Method	Best for	Main advantage	Main limitation
Insert directly in Word	Self-contained reports	Editable without a separate source file	Embedded data are less convenient for complex analysis
Embed an Excel chart	Editable document delivery	Chart and workbook content travel with Word	Can increase the file size
Link an Excel chart	Reports updated from Excel	Source changes can flow into Word	Link can break if the workbook moves
Paste as a picture	Final, fixed documents	Stable appearance and placement	Chart data and elements cannot be edited

Direct Word chart

The Insert Chart method creates an embedded chart and worksheet inside Word. It suits school assignments, reports, and documents that need to remain self-contained.

Embedded Excel chart

If the chart already exists in Excel, copy it and choose a paste option that embeds the workbook. Labels vary among Word versions, but options may mention Embed Workbook, Keep Source Formatting, or Use Destination Theme.

An embedded chart remains editable and does not need the original workbook to be present. The tradeoff is a larger document and possible duplication of data.

Linked Excel chart

A linked chart keeps a connection to the original workbook. When the source changes, Word may update the figure.

Linking is useful for recurring reports, but the connection depends on the source-file path. Moving, renaming, deleting, or denying access to the workbook can break the link. Sending the Word file alone may therefore leave another reader without a working source.

Static picture

Pasting as a picture locks the appearance and removes the risk of accidental data edits. It works well for final reports whose analysis is already approved.

A picture cannot provide editable chart elements or embedded values. Use a high-quality paste format so text and lines remain clear after resizing or PDF export.

Position the Chart Reliably on the Page

Word treats charts as document objects. Their placement depends on text-wrapping settings.

Inline with Text

An inline chart behaves like a large character in a paragraph. It moves with the surrounding text and is usually the most stable choice for academic papers, reports, and templates.

You can center it by applying paragraph alignment. Inline placement also makes it easier to keep the figure in a predictable reading order.

Floating layout

Options such as Square, Tight, Top and Bottom, or In Front of Text allow text to wrap around the chart. Floating objects offer more visual freedom but can move when paragraphs are edited, page margins change, or the document opens on another system.

If a chart keeps shifting:

• use Inline with Text;
• avoid positioning it with repeated spaces or blank lines;
• keep it within the page margins;
• review its anchor and layout settings;
• place the chart and caption together;
• check whether nearby headings force a page break.

Resize using a corner handle to preserve proportions. Dragging only a side handle can stretch the chart and distort text or boxes.

Add a Numbered Figure Caption

Formal documents should identify charts as numbered figures. Select the chart, open the References tab, and choose Insert Caption.

A suitable caption is:

Figure 1. Distribution of test scores for Classes A, B, and C. Boxes show the interquartile range, center lines show medians, and separate points indicate potential outliers.

Word’s caption feature can number figures automatically. If a new figure is inserted earlier, the numbering can be updated instead of corrected manually.

To refer to the chart in the text, use a cross-reference rather than typing “Figure 1” as ordinary text. Cross-references can update when figure numbers change.

A useful sentence might read:

“As shown in Figure 1, Class B has a higher central score than Class C.”

The body text should explain the main finding rather than asking the figure to speak entirely for itself.

Make the Chart Accessible

A reader using assistive technology may not receive the information conveyed by the chart’s shapes and colors. Accessibility needs to be planned, not added as an afterthought.

Add concise alternative text

Open the chart’s context menu and find the Alt Text option. Describe the chart’s purpose and main result without repeating every value.

For example:

“Box plots compare test-score distributions for Classes A, B, and C. Class B has the highest median. Class A includes one high potential outlier.”

Do not rely on color alone

If classes are distinguished only by red, green, and blue, some readers may not be able to identify them. Combine color with direct labels, borders, patterns where available, or a clear legend.

Maintain sufficient contrast

Use text, borders, and fills that remain visible in grayscale and on common displays. Very pale boxes can disappear during printing.

Explain the result in nearby text

The paragraph accompanying the figure should state its most important message. Alt text is not a replacement for analysis in the report.

Check the Chart Before Printing or Exporting

A chart that looks acceptable while zoomed in may fail in the final document. Review it at normal page size.

Check:

• axis labels and units;
• category names;
• figure number and caption;
• font size;
• outlier visibility;
• page margins;
• line thickness;
• grayscale legibility;
• whether the chart and caption split across pages.

Use Print Preview to inspect pagination. Then export or save the document as PDF and examine the actual PDF at normal zoom.

Linked charts should be updated and checked before export. A PDF captures the displayed version at the time of export; it will not continue updating from the source workbook.

If a pasted chart appears blurry, replace it with an editable Office chart or a higher-quality vector-style paste option where available. Avoid enlarging a low-resolution screenshot.

Troubleshooting Word Box Plots

Box & Whisker is missing

Built-in support is generally available in Word 2016 and newer compatible desktop versions. Word for Mac, Word for the web, mobile apps, older releases, and managed installations may present different options.

If the chart type is unavailable, create it in a compatible desktop version of Excel and paste or embed it in Word. A manual chart construction is possible but unnecessarily complex for most reports.

The placeholder data are still visible

Reopen Chart Design > Edit Data and remove every unused sample row and column. Adjust the highlighted source range so it covers only the intended table.

Only one box appears

Ensure that each group occupies a separate column with its own header. Check Select Data and try Switch Row/Column only when the table’s orientation supports that change.

The category names are wrong

Edit the first row of the embedded sheet or correct the series names through Select Data. Confirm that the headers are not being interpreted as observations.

The data window has disappeared

Select the chart, open Chart Design, and choose Edit Data or Edit Data in Excel. If Chart Design is not visible, click the chart object first.

Outlier points do not appear

Open Format Data Series and enable Show outlier points. If nothing changes, the observation may not exceed the chart’s outlier threshold under the selected quartile method.

The chart moves unexpectedly

Switch to Inline with Text, remove manual spacing around it, and keep the caption in the following paragraph. Floating layout options are more sensitive to surrounding edits.

The linked chart cannot find its source

Restore the original workbook path, relink the chart where possible, or replace it with an embedded chart. For documents sent to other people, embedding or using a fixed picture may be more dependable.

Frequently Asked Questions

Can Word create a box and whisker plot without Excel?

Word can insert the chart directly, but it uses an embedded Excel-style sheet to store and process the values. A separate Excel workbook is not required for this method.

Where is Box & Whisker in Microsoft Word?

In a compatible desktop version, choose Insert > Chart > All Charts > Box & Whisker. If it is absent, check the Word version, operating system, update status, and available desktop features.

How do I edit the data after closing the worksheet?

Select the chart and choose Chart Design > Edit Data. Use Edit Data in Excel if the fuller spreadsheet interface is available and helpful.

Can I make several box plots in one Word chart?

Yes. Enter each group in a separate column and place a unique header in the first row. Expand the selected source range to cover all groups.

What does the X mean on a Word box plot?

The X normally represents the arithmetic mean when mean markers are enabled. The line inside the box is the median, so the two symbols should not be interpreted as the same statistic.

Does hiding outliers remove them from the chart calculations?

No. Turning off outlier markers changes only their visibility. The observations remain in the embedded source data and should not be described as removed.

Should I link or embed an Excel box plot?

Link the chart when the source workbook changes regularly and will remain accessible. Embed it when the Word file must be self-contained and editable. Use a picture when the final appearance should be fixed.

How do I stop a box plot from moving in Word?

Set the chart to Inline with Text, center its paragraph, and avoid positioning it with spaces or blank lines. This layout is usually more stable than floating text wrapping.

Finish the Figure as Part of the Document

Knowing how to make a box and whisker plot in Word includes more than inserting the correct chart type. The embedded values must represent the intended groups, while the finished figure must fit the page, remain legible, and explain its statistical conventions.

Choose direct insertion, embedding, linking, or a static picture according to how the report will be maintained. Then add a numbered caption, accessible description, and nearby interpretation. A final check in Print Preview and PDF form helps ensure the chart remains clear outside the Word editing window.