How do I create a scatter plot with XLSTAT?

An Excel sheet with both the data and the results can be downloaded by clicking here. The data correspond to a small group of patients that have been on a specific diet. Their doctor has recorded their Weight before the treatment (kg), how much weight they've lost (kg), if they are satisfied or not with the diet effect, and their Age. Our goal is here to visualize the results while keeping as much information as possible.

Once XLSTAT-Pro is activated, select the XLSTAT/Visualizing data/Scatter Plot command, or click on the corresponding button of the "Visualizing Data" toolbar (see below).

Once you have clicked on the button, the Scatter Plot dialog box appears.

Select the data on the Excel sheet as following:

  • X: Weight;
  • Y: Weight loss;
  • Z: Age;
  • Groups: Satisfied.

Note that the "Frequencies" and "Only if >1"options have been activated because we want to know if two or more points are superimposed if there is such as case.

Interpreting a scatter plot

After you have clicked on the OK button, a chart is displayed on the Excel sheet (because the Range option has been selected for outputs).

Note 1: for one of the observations a label has been added. This tells us that two observations are superimposed.

Note 2: the observation labels haven't been used on the chart because the "Show Observation labels" hasn't been activated.

Watch the following video to see how the settings are done.

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


Like us on Facebook Facebook

Get in Touch

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