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

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.

err2.gif

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.

err3.gif

Click here for other tutorials.

About KCS

Kovach Computing Services (KCS) was founded in 1993 by Dr. Warren Kovach. The company specializes in the development and marketing of inexpensive and easy-to-use statistical software for scientists, as well as in data analysis consulting.

Mailing list Join our mailing list

Home | Order | MVSP | Oriana | XLStat
QDA Miner | Accent Composer | Stats Books
Stats Links | Anglesey

Share: FacebookFacebook TwitterTwitter RedditReddit
Del.icio.usDel.icio.us Stumble UponStumble Upon

 

Like us on Facebook

Get in Touch

  • Email:
    sales@kovcomp.com
  • Address:
    85 Nant y Felin
    Pentraeth, Isle of Anglesey
    LL75 8UY
    United Kingdom
  • Phone:
    (UK): 01248-450414
    (Intl.): +44-1248-450414