This tutorial shows how to add a curve to an existing Excel chart, using the XLSTAT software.
Dataset to add a curve on a Microsoft Excel chart
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.
Adding a curve on a Microsoft Excel chart
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).
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).
As soon as you click OK, the function is displayed.
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.