Creating a ternary diagram in XLSTAT

Dataset to create a ternary diagram

An Excel sheet with both the data and the results can be downloaded by clicking here.

The data used in this tutorial correspond to 3 chemical components and the yield obtained for a fourth component that is being tested.

A ternary diagram represents within a triangle a set of points that have their coordinates in a three-dimensional space, with the constraint that the sum of the coordinates is constant.

Setting up a ternary diagram

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

Ternary diagram: Menu

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

Ternary diagram: Dialog box - General

Select the data on the Excel sheet. The third column does not need to be entered as the values are known from the 2 other dimensions and the value of the constant sum that is entered in the Options tab. As object labels we select the yields so that they are displayed on the ternary plot

Ternary diagram: Dialog box - Options

The Charts tab allows defining a triangle within the ternary plot where we want to make the focus on. Here we left the default with all minimum values set to 0 and all maximum values set to 1. The number of segments determines how many tick marks and values are displayed along the axes. We decide to display both the projection lines and the lines between the axes.

Ternary diagram: Dialog box - Charts

Interpreting a ternary diagram

Then, after you have clicked on the OK button, the ternary diagram is displayed on a new Excel sheet (because the Sheet option has been selected for outputs).

Ternary diagram

It allows to see how the points cover the space and potential zones that should be explored during the next experiments.

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