Skip to content

Home / Statistical Tools / Analysis Tools / Piechart / How-To

How-To

Quick Start

Create your first pie chart in less than two minutes.

This example shows the simplest way to create a pie chart: a single column of category names where each row is one observation. Quantum XL counts how many times each category appears.

Goal

Create a pie chart showing headcount distribution across departments.

Sample Data

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

Department
Sales
Engineering
Marketing
Sales
Engineering
Sales
Support
Engineering
Marketing
Sales

Each row represents one employee. Quantum XL will count how many times each department appears (Sales: 4, Engineering: 3, Marketing: 2, Support: 1).

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:A11 (the header row plus all 10 data rows).

  4. Configure the analysis

    In the Pie Chart dialog:

    • Data Columns: "Department" should be checked

    Quantum XL automatically selects the single provided data column, so you don't need to change any options. Click Finish to generate the chart.

Result

Quantum XL creates a pie chart showing department distribution. Sales has the largest slice (4 out of 10, or 40%), followed by Engineering (30%), Marketing (20%), and Support (10%).

More Examples

Ready for more? See these variations: