How to add custom error bars to a bar chart in Excel

In this video, you’ll learn step-by-step how to create a bar chart in Excel and correctly add standard error bars—a key requirement for high-quality scientific figures. We start by quickly building a basic bar chart using mean values, then walk through best practices for formatting your figure (axis labels, tick marks, font size, and layout) before adding error bars. From there, you’ll see exactly how to add custom standard error bars using a properly formatted summary table. The video covers: • Creating a bar chart from mean values • Formatting a graph to meet scientific conventions • Why standard error bars are important when reporting averages • Setting up a summary table for means and standard error • Adding custom error bars in Excel (not the default options) • Applying error bars to: • A single data series (e.g., fertilizer treatments and plant height) • Multiple data series (e.g., enzyme activity at different temperatures and pH levels) • Common troubleshooting tips (including Mac vs. Windows differences) Important note: Custom error bars require the desktop version of Microsoft Excel. This feature is not available in Excel Online or some alternative spreadsheet programs. This tutorial is ideal for students in biology, environmental science, chemistry, or any course that requires proper data visualization and statistical reporting.