Home / Statistical Tools / Analysis Tools / Piechart / How-To / 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

Press Copy for Excel, then paste the table into a blank worksheet.

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. Put the data in Excel

   Press Copy for Excel above the table, click cell A1 in a blank worksheet, and press Ctrl+V. The header row lands in row 1 and the 10 data rows in rows 2 through 11.

2. Launch the analysis

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

3. Select your data

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

4. 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?"