How do I create a chart with error bars with just two clicks?

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.

Once XLSTAT-Pro 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.

Click here for other tutorials.