Add error bars or up/down bars to a chart

Error bars express potential error amounts that are graphically relative to each data pointIndividual values plotted in a chart and represented by bars, columns, lines, pie or doughnut slices, dots, and other shapes called data markers. Data markers of the same color constitute a data series. or data marker A bar, area, dot, slice, or other symbol in a chart that represents a single data point or value that originates from a cell on a sheet. Data markers of the same color constitute a data series. in a data seriesA group of related data points plotted in a chart that originate from rows or columns on a single sheet. Each data series in a chart has a unique color or pattern. You can plot one or more data series in a chart. Pie charts have only one data series.. For example, you could show 5 percent positive and negative potential error amounts in the results of a scientific experiment. You can add error bars to data series in a 2-D area, bar, column, line, stock, xy (scatter), or bubble chart. For xy (scatter) and bubble charts, you can display error bars for the x values, the y values, or both.

Error bars in a chart

Do any of the following:

Express errors as a percentage, standard deviation, or standard error

Express errors as custom values

Add up/down bars