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

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

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