Welcome, Guest. Sign In | Register
Click here to go back to the main website.

Knowledge Base » SigmaXL Toolbox

Stacked vs Unstacked Data Column Format

on January 01, 2012

Should I use the Stacked Data Column Format or the Unstacked Multiple Column Format?

There are two possible data formats that SigmaXL can accommodate: stacked column and unstacked multiple column.

The stacked column format has an X column also referred to as the “Group Category” column and a Y column that contains the data of interest.

The following is an example of data in stacked column format, with three unique groups of Customer Type:

If the data is in unstacked multiple column format, each unique group of X corresponds to a different column.

The data below is shown in unstacked format with customer satisfaction scores for each customer type in separate columns:

Was this helpful? Yes No Print/Save Pdf