Home / Statistical Tools / Analysis Tools / Run Chart / How-To
How-To¶
Quick Start¶
Create your first run chart in less than two minutes.
This example shows the simplest way to create a run chart: a single column of numeric data with no X column. Quantum XL plots each value in order and auto-generates observation numbers (1, 2, 3...) for the X-axis.
Goal¶
Create a run chart showing temperature readings in sequential order.
Sample Data¶
Press Copy for Excel, then paste the table into a blank worksheet.
| Temperature |
|---|
| 72.1 |
| 73.4 |
| 71.8 |
| 74.2 |
| 73.0 |
| 75.1 |
| 72.6 |
| 74.8 |
| 73.5 |
| 76.0 |
Each row represents one temperature reading taken in sequence. Quantum XL will plot these values in order, connecting them with lines.
Steps¶
-
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.
-
Launch the analysis
From the Excel ribbon, select QXL Stat Tools → Analysis Tools → Run Chart.
-
Select your data
Select cells A1:A11 (the header row plus all 10 data rows).
-
Configure the analysis
In the Run Chart dialog:
- Y Columns: "Temperature" should be checked
- No X column is needed: Quantum XL will auto-generate observation numbers
Click Finish to generate the chart.
Result¶
Quantum XL creates a run chart with observation numbers (1 through 10) on the X-axis and temperature on the Y-axis. Each data point is marked with a circle and connected by lines, making it easy to see the sequential pattern: in this case, an overall upward trend in temperature.
More Examples¶
Ready for more? See these variations:
- With X Column: Use dates or another column as the X-axis
- Multiple Y Columns: Compare multiple series on the same chart
- GroupBy: Compare trends across segments