xlsgen > overview > Chart error bars

The chart error bars are optional series of values which help analyze when and where values are greater or less than a given threshold. This threshold is either a known fixed value, or the result of a formula computation.

When the error bar threshold is governed by a formula, the custom error bar must be used. The custom error bar interface is described here.

An error bar is accessed from a series object thanks to the XErrorBar and YErrorBar properties. Here are the following properties of error bar interface.

Error bars cannot be attached to 3D charts and pie charts. If you try to do so, xlsgen will return an error.

With the exception of scatter and bubble charts, only Y error bars are accessible. X error bars make sense for scatter and bubble charts due to the nature of those charts.

• Common options.
• Direction of the error bar, thanks to the definition of a positive or a negative threshold, or both.
• Custom threshold.