How do I add a curve on an Excel chart with XLSTAT ?

An Excel sheet with both the data and results used in this tutorial can be downloaded by clicking here. The data correspond to an experiment in physics where a particule is followed in an experimental space submitted to magnetic fields. Particules are detected at different times and their position is recorded on two dimensions. Our goal is to quickly plot the f(y)= x sin(x) function on the chart that shows the different positions that have been recorded, in order to validate the experimental framework. First we copy the chart showing the positions, and then we select it.

Once XLSTAT has been started, select the XLSTAT/Visualizing data/Plot a function command, or click on the corresponding button of the Visualizing data toolbar (see below).

barfuncpl.gif

A dialog box appears, where you can enter the function of interest, respecting the XLSTAT convention that abscissa must be declared with X1, and the Excel conventions for spreadsheet functions. In this case, we need to enter X1*SIN(X1).

funcpl1.gif

As soon as you click "OK", the function is displayed.

funcpl2.gif

Note : with this tool, you can also plot a function without starting from an existing chart.

The following video shows you how to add a curve on an Excel chart.

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