How to Make an APA-Style Bar Chart with Error Bars in Excel (2026 Guide)

If you have ever stared at a blank Excel sheet wondering how to turn raw data into a clean, APA-style bar chart with error bars, you are in the right place. Learning how to make an APA-style bar chart with error bars in Excel is one of the most useful skills for students, researchers, and academics publishing in psychology, social sciences, and the life sciences. APA 7th edition has specific rules for figures, and getting the details right can be the difference between a polished lab report and one that gets sent back for revisions.

I have built dozens of these charts over the years for coursework, thesis projects, and published papers. The process comes down to five repeatable steps: organize your data, calculate the mean and your error amount, build the bar chart, add custom error bars, and format everything to APA specifications. This guide walks through each step using real Excel formulas so you can follow along with your own dataset.

By the end, you will understand the difference between standard deviation and standard error, know exactly which buttons to click, and have a checklist for APA 7 figure formatting that you can reuse for every future report.

What Are Error Bars and Why APA Format Requires Them

Error bars are visual representations of variability in your data. They sit above and below the top of each bar and show how spread out or uncertain your measurements are. Without them, a reader has no way to judge whether two bars that look different are actually statistically different or just noise.

The APA 7th edition publication manual requires error bars on bar graphs that represent sample means. Specifically, APA wants you to describe what the error bars represent in the figure caption, whether that is standard deviation, standard error, or a confidence interval. Leaving them off, or failing to label them, is a common reason reviewers flag a figure.

Think of error bars as a honesty marker. They tell the reader, “here is the average, and here is how much wiggle room exists around it.” That transparency is why every APA-style bar chart with error bars in Excel needs them from the start, not added as an afterthought.

Standard Deviation vs Standard Error: Which Should You Use?

This is the single most common question I see on forums like r/excel, and it matters because the choice changes how your chart is interpreted. Standard deviation (SD) describes the spread of individual data points around the mean. Standard error (SE) describes the precision of the sample mean itself.

Use standard deviation when you want to show how variable your individual observations are. Use standard error when you want to show how confident you are in the mean as an estimate of the population mean. Most APA publications in psychology and social sciences use standard error or 95 percent confidence intervals, but always check what your instructor or journal expects.

Here are the formulas you will use in Excel:

• Standard Deviation (sample): =STDEV.S(range)
• Standard Error: =STDEV.S(range)/SQRT(COUNT(range))
• Mean: =AVERAGE(range)

Notice that standard error is just standard deviation divided by the square root of your sample size. Larger samples shrink the standard error, which is why error bars based on SE tend to be smaller than those based on SD for the same dataset.

How to Make an APA-Style Bar Chart with Error Bars in Excel

This is the main walkthrough. I recommend reading through all five steps once before starting so you can see how the pieces fit together. Each step below assumes you are using Excel for Microsoft 365 on Windows, but I cover Mac differences in a later section.

Step 1: Enter and Organize Your Data

Start with a clean worksheet. Put each condition or group in its own column, with each row representing one participant or one observation. For example, if you ran an experiment with three conditions and 10 participants per condition, you would have three columns of 10 values each.

Keep raw data in columns A through C and reserve columns to the right for your calculated values. Label everything clearly in row 1 so you do not lose track of which column is which. APA figures reward tidy data, so spend a minute making sure headers are short and descriptive.

Avoid blank rows inside your data range, because Excel will treat them as gaps and your formulas may return errors. If a participant has missing data, decide in advance whether to exclude that row or use a different handling method.

Step 2: Calculate the Mean, Standard Deviation, and Standard Error

This step is the prerequisite that catches a lot of people off guard. On forums, users frequently ask whether they need to calculate averages and standard deviation before adding error bars. The answer is yes, especially if you want custom error bars, which APA charts almost always do.

Pick a cell to the right of your raw data and calculate the mean for the first condition with =AVERAGE(A2:A11). Below that, calculate standard deviation with =STDEV.S(A2:A11). Below that, calculate standard error with =STDEV.S(A2:A11)/SQRT(COUNT(A2:A11)). Repeat for each condition, adjusting the range letters.

You now have a small summary table with one mean and one error value per condition. These summary cells are what Excel will use as the bar heights and as the custom error bar amounts. Keep this table organized because you will reference it in the next steps.

Step 3: Create the Bar Chart

Select just the labels and the means from your summary table, not the raw data. Go to the Insert tab, click the Column or Bar Chart icon, and choose Clustered Column. Excel drops a basic bar chart onto your sheet with one bar per condition.

Do not worry that the chart looks generic right now. The default styling has gridlines, a chart title, and colors that all need to change for APA format. You will handle that in Step 5.

Delete the chart title for now, because APA figures use a caption below the chart instead of a title above it. Also delete any automatic legend if you only have one series, since it adds clutter without information.

Step 4: Add Custom Error Bars to Each Bar

This is where most tutorials lose people, so I will be specific. Click anywhere on the chart to select it. You should see a green plus icon, the Chart Elements button, appear at the top right of the chart. Click it, check the box next to Error Bars, and then click the small arrow beside Error Bars to open the submenu.

Choose More Options at the bottom of that submenu. The Format Error Bars pane opens on the right side of your screen. Under Error Bar Options, look for the Direction section and select Both, so the bars extend up and down. Under End Style, choose Cap if you want the small horizontal lines at the end of each error bar, which is standard for APA charts.

Now the critical part. Under Error Amount, select Custom instead of the default Standard Error. Click the Specify Value button. A small dialog appears with two input boxes: Positive Error Value and Negative Error Value.

For the Positive Error Value box, click and drag to select the cells containing your standard error (or standard deviation) values for each condition. Do the exact same thing for the Negative Error Value box, selecting the same range. Click OK.

Your chart now has individual error bars on each bar, with lengths matching the variability of each condition. This is the heart of an APA-style bar chart with error bars in Excel, and getting it right here is what separates a polished figure from a default one.

Step 5: Format the Chart for APA 7th Edition

APA 7 figures have a specific look. The goal is clarity and consistency, not decoration. Use the following checklist to bring your chart into compliance.

• Font: Set all chart text to a sans-serif font like Calibri or Arial, sized between 8 and 14 points.
• Axis labels: Add clear, concise labels to both axes using the Chart Elements button. Spell out units if relevant.
• Gridlines: Remove all gridlines. Click on them and press Delete.
• Bar color: Use a single solid color, typically black or dark gray, for all bars in a single-series chart.
• Bar outline: Add a thin black outline to each bar for definition.
• Y-axis scale: Start the y-axis at zero. Adjust the maximum to a round number that gives the bars some breathing room.
• Chart border: Remove any outer chart border by setting it to No Fill and No Line.
• Caption: Below the chart, write a figure number, title, and note describing what the error bars represent.

Here is an APA 7 figure caption template you can adapt:

Figure 1
Mean Scores by Condition
Note. Error bars represent one standard error of the mean. N = 30.

The “Note.” line is mandatory in APA 7 whenever error bars are present, and it must state what the bars represent. Without that line, your figure is technically incomplete even if the chart itself looks perfect.

Common Mistakes and Troubleshooting

Even with a clear guide, a few issues come up repeatedly. These are the problems I see most often on forums and in student work.

Using the wrong error amount type. If you leave the error bars set to the default Standard Error option, Excel calculates a single standard error across all data points and applies it uniformly. That is rarely what you want. Switch to Custom and point to your per-condition values.

Forgetting to calculate means first. Error bars only make sense on top of a mean. If you build the chart from raw data, each bar represents a single value rather than an average, and adding error bars becomes meaningless.

Selecting the wrong range in Specify Value. The Specify Value dialog is unforgiving. If you accidentally include a label cell or an empty cell, Excel throws an error or draws nonsense bars. Double-check your selection before clicking OK.

Confusing SD and SE. Standard deviation bars are wider than standard error bars on the same data because SE divides by the square root of n. If your error bars look surprisingly large or small, verify which formula you used.

Leaving default chart styling. Excel’s default blue bars and gray gridlines do not meet APA expectations. Spend five minutes applying the formatting checklist above before exporting.

Excel on Mac: What Is Different

If you are using Excel on a Mac, the overall process is the same, but a few menu locations shift. The Chart Elements button still appears as a green plus icon when you select the chart. The Format Error Bars pane still opens to the right.

The main difference is that some older Mac Excel versions, particularly Excel 2011 and Excel 2016, place error bar controls under the Chart Design tab rather than the Chart Elements flyout. If you do not see the green plus icon, look for Add Chart Element on the Chart Design ribbon and follow the same path to More Error Bars Options.

Custom error bars work identically on Mac and Windows in current versions of Excel for Microsoft 365. If you are on an older standalone version and the Specify Value button is grayed out, update Excel or use a workaround where you paste your chart into PowerPoint and add error bars there.

FAQ’s

Conclusion

Building an APA-style bar chart with error bars in Excel comes down to a sequence anyone can follow: organize your data, calculate means and standard error, insert a clustered column chart, add custom error bars through the Specify Value dialog, and format the result to APA 7 specifications. The trickiest part is almost always the custom error bar step, so take your time selecting the right ranges in that dialog.

Remember to label what your error bars represent in the figure caption, choose standard error or standard deviation based on what you want to communicate, and strip away default styling so the chart reads cleanly. Once you run through this workflow a few times, it takes about ten minutes per chart. Save your formatted chart as a template, and future reports get even faster.