Skip to content

Home / Statistical Tools / Analysis Tools / Piechart / Examples / Examples

Examples

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

Download PieChart_QuickStart.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.

Excel Protected View warning

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

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. Launch the analysis

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

  2. Select your data

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

  3. 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: