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

Continuous Frequency

When each observation has an associated measurement (like revenue, cost, or time), use a Continuous column as the frequency. This creates a pie chart weighted by that measurement rather than by simple counts.

Goal

Create a pie chart showing regions ranked by total revenue, revealing which regions contribute the most to overall performance.

Sample Data

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

Region	Revenue
North	245.78
South	89.32
North	187.45
East	52.16
West	134.50
North	312.67
South	156.29
East	78.93
West	95.41
North	156.22

Each row represents one transaction with its revenue value. Quantum XL will sum the revenue for each region to determine the slice sizes.

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: Uncheck "Revenue"
   • Frequency Data (Optional): Check "Revenue"

   Click Finish to generate the chart.

Result

Quantum XL sums the revenue for each region and creates the pie chart:

• North: $902.12 (4 transactions) — the largest slice
• South: $245.61 (2 transactions)
• West: $229.91 (2 transactions)
• East: $131.09 (2 transactions)

The pie chart shows North dominates with about 60% of total revenue, making it easy to see the relative contribution of each region at a glance.