Chart with error bars in Excel with just two clicks

This tutorial shows how to quickly create charts with error bars in Excel using the XLSTAT software.

Dataset to create a chart with error bars

Setting up a chart with error bars

Once XLSTAT is activated, select the XLSTAT / Visualizing data / Error bars command, or click on the corresponding button of the Visualizing data toolbar (see below).

Once you have clicked on the button, the dialog box appears. Select the "Month" data that correspond to the Xs, then the two "Value" series.

Then check the Lower bound option and select the two columns that correspond to the "minimum values" for both the Value(Eur) and Value(USA) series, and do the same for the Upper bound.

On the Charts tab we select the Curve option.

After you have clicked on the OK button, the results are displayed on a new Excel sheet (because the Sheet option has been selected for outputs).

Interpreting a chart with error bars

The chart with the two series and the corresponding error bars is displayed. As this is a standard Excel chart, you can customize it as much as you want.