Your data analysis solution

Adding a curve on an Excel chart

2017-03-02

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

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.gifNote : 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.

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