Your data analysis solution

Chart with error bars in Excel with just two clicks

2016-07-13

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).

barerr.gif

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.

err1.gif

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

err2.gif

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.

err3.gif

1c26995d494fb3061dd0ae8571ffc0a4@xlstat.desk-mail.com
https://cdn.desk.com/
false
desk
Loading
seconds ago
a minute ago
minutes ago
an hour ago
hours ago
a day ago
days ago
about
false
Invalid characters found
/customer/portal/articles/autocomplete
9283