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
An Excel sheet with both the data and the results can be downloaded by clicking here. The data correspond to economic data for Europe and USA. For each month we have the average, the minimum and the maximum of the index.
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.