How do I make a scatter plot with line of best fit from my data?
Choose a local CSV, Excel, JSON or Parquet file, or paste CSV with a header row. Choose the fields in the controls to draw and edit your chart; xmetric processes the data in this browser.
No data loaded. Choose your own file or try the sample.
What does a scatter plot with line of best fit show?
A scatter plot with a line of best fit adds a fitted linear trend to numeric observations.
Definition source: Scatter plot with line of best fit reference. xmetric uses its own native chart engine.
What does the scatter plot with line of best fit sample show?
With Period as X and Value as Y, sample observations include (1, 12) and (2, 18). The least-squares line minimizes the sum of squared vertical residuals over all sample points; it does not imply causation.
Source: the illustrative input rows below, also supplied by Try sample data. This is an example, not a result from your file.
| Period | Category | Value | Other | Size |
|---|---|---|---|---|
| 1 | North | 12 | 8 | 3 |
| 2 | South | 18 | 13 | 6 |
| 3 | North | 15 | 17 | 4 |
| 4 | South | 24 | 21 | 9 |
| 5 | North | 20 | 19 | 5 |
| 6 | South | 28 | 30 | 8 |
When should I choose a scatter plot with line of best fit instead of a scatter plot?
Choose a plain scatter plot when a fitted linear relationship would not help answer the question.
| Chart | Use it for |
|---|---|
| Scatter plot with line of best fit | A scatter plot with a line of best fit adds a fitted linear trend to numeric observations. |
| Scatter plot | Choose a plain scatter plot when a fitted linear relationship would not help answer the question. |
What limits apply to my data?
These limits apply to tabular imports, not native Power BI or Tableau report compatibility. File size and browser memory limit what xmetric can open. Group large datasets before drawing a chart.
| Limit | Current behavior |
|---|---|
| File size | 32 MiB on constrained devices; 160 MiB otherwise |
| Imported rows | Up to 3,500,000 |
| Chart marks | Up to 10,000 |
| Download | SVG chart |
Source: xmetric limits and verification record, checked 2026-10-27. These are product limits, not file-format limits.
Can I chart a CSV without uploading my data?
Yes. xmetric reads the selected file or pasted CSV in your browser. Opening and editing this local chart does not upload the file.
Which columns does this scatter plot with line of best fit need?
Plot two numeric columns and fit a linear trend using the xmetric analytics engine. Start with X value and Y value. Choose the additional series, target or date fields when the controls request them.
Can I export the chart and keep editing it?
Yes. Download SVG for a static chart, or choose Continue editing in xmetric to carry the data and selected chart into the app. Check the chart before sharing it.