Home / Statistical Tools / Analysis Tools / Piechart / Examples / Count Frequency

Count Frequency

When your data includes counts that need to be aggregated by category, use a Count column as the frequency. Quantum XL automatically sums the counts for each category — you don't need to pre-summarize your data.

Goal

Create a pie chart from product sales data where the same product appears multiple times. Quantum XL will aggregate (sum) the units sold for each product automatically.

Sample Data

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

Product	Units Sold
Widget A	150
Widget B	89
Widget A	210
Widget C	45
Widget B	67
Widget A	180
Widget D	12
Widget C	33
Widget B	54
Widget D	8

Notice that "Widget A" appears 3 times, "Widget B" 3 times, and "Widget C" and "Widget D" twice each. Quantum XL will automatically sum the units sold:

• Widget A: 150 + 210 + 180 = 540
• Widget B: 89 + 67 + 54 = 210
• Widget C: 45 + 33 = 78
• Widget D: 12 + 8 = 20

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:

   • Deselect "Units Sold" under Data Columns (if auto-selected)
   • Check "Units Sold" under Frequency Data (Optional)

   Click Finish to generate the chart.

Result

Quantum XL aggregates the units sold by product and creates the pie chart. Widget A dominates with 540 units (64% of the total 848), followed by Widget B at 210 units (25%), Widget C at 78 units (9%), and Widget D at 20 units (2%).