Home / Statistical Tools / Analysis Tools / Piechart / Examples / Multiple Categories

Multiple Categories

When you have multiple category columns, Quantum XL creates a separate pie chart for each column, allowing you to analyze different dimensions of your data.

Goal

Create pie charts for both department and status, showing the distribution of each dimension.

Sample Data

Download PieChart_MultipleCategories.xlsx

Excel Protected View

When you open downloaded files, Excel displays a Protected View warning. You must click Enable Editing before you can use Quantum XL with the file.

Alternatively, you can copy the sample data from the table below and paste it directly into a new Excel workbook.

Department	Status
Sales	Active
Engineering	Active
Marketing	Inactive
Sales	Active
Engineering	Inactive
Sales	Active
Support	Active
Engineering	Active
Marketing	Active
Sales	Inactive

Each row represents one employee with two attributes: their department and their status.

Steps

1. Launch the analysis

   From the Excel ribbon, select QXL Stat Tools → Analysis Tools → Pie Chart.

2. Select your data

   Select cells A1:B11 (the header row plus all 10 data rows).

3. Configure the analysis

   In the Pie Chart dialog:

   • Data Columns: Leave "Department" and "Status" checked

   Click Finish to generate the charts.

Result

Quantum XL creates two pie charts:

Department chart — Shows Sales as the largest slice (4 out of 10), followed by Engineering (3), Marketing (2), and Support (1).

Status chart — Shows Active as the dominant slice (7 out of 10, or 70%) with Inactive at 30%.

This lets you answer two questions at once: "How are employees distributed across departments?" and "What percentage are active vs. inactive?"