A scatter plot in Excel places each x,y pair from your spreadsheet onto a two-axis chart so unequal numeric gaps stay unequal on screen. Microsoft's native Insert > Chart > Scatter workflow handles this well for hundreds of points, but it sits inside the workbook, requires the right data layout, and produces a chart object that's awkward to share outside Excel. The Scatter Plot Maker runs entirely in the current browser tab and converts up to 200 strict numeric pairs into a standalone 800 by 500 SVG you can download, embed in a webpage, or attach to a document. Each valid pair becomes one blue circle, blank rows are ignored, and invalid rows are skipped rather than coerced to zero so a typo never silently distorts your plot. The on-page preview and the downloaded file come from the same generated string, so what you see is what you save, and no values are uploaded to a server while you work.
What a Scatter Plot Shows in Excel
A scatter plot draws one marker per pair of measurements, with the horizontal position controlled by the x value and the vertical position controlled by the y value. Each axis uses an independent linear scale, which means a gap of 10 units between two points occupies ten times the horizontal space of a gap of 1 unit, and the visual spacing between points always matches their numeric distance. That property is what makes a scatter plot useful for spotting whether two measurements move together, drift apart, or cluster. A bar chart or pie chart hides it, which is why pairs of numbers almost always belong on a scatter plot rather than a categorical chart.
The Scatter Plot Maker keeps that property intact. It does not snap x values to evenly spaced bins and it does not sort points by y, so the only thing the picture shows you is the raw two-dimensional layout of the pairs you pasted.
Why a Browser Tool Complements Excel
Excel's native scatter chart is the right choice when the chart must live inside the workbook, update as cells change, or feed downstream formulas. The Scatter Plot Maker is the right choice when the chart needs to leave Excel as a portable file. The output is a single self-contained SVG, which a vector format that stays sharp when resized, opens in any browser, embeds in HTML, and prints cleanly. If you paste into a slide deck, a static report, or a content management system that rejects Excel objects, an SVG beats an embedded chart every time.
Because the tool runs locally in the browser tab, your numbers never leave your machine while you build the chart. That makes it practical to paste a column of paired observations from a private workbook without worrying about how the file gets handled.
Prepare Excel Cells for the Scatter Plot Maker
Most Excel sheets used to feed a scatter plot look like this: column A holds an x variable (time, dose, distance, trial number) and column B holds the matching y measurement. The tool does not read .xlsx files directly, so the bridge between your workbook and the chart is a third column that concatenates the two with a comma.
- In cell C2, enter the formula =A2&","&B2 and press Enter.
- Drag the fill handle down column C until every data row has a joined value.
- Select the C column, copy it with Ctrl+C, and paste into the input box on the Scatter Plot Maker page.
- Strip currency symbols, percent signs, and thousands separators from column A and column B beforehand, because the parser only accepts strict numbers.
- If your x and y values already live in two columns without a helper, the walkthrough at Make a 2-Variable Scatter Plot From Excel Columns shows a single TEXTJOIN formula that builds the pasted text in one step.
Once the helper column is built, the paste box accepts the joined text directly and the parser handles the rest.
Enter x,y Pairs and Generate the Plot
The actual workflow inside the Scatter Plot Maker is short and predictable, so it fits easily into a copy-paste routine.
- Open the Scatter Plot Maker in your browser and type an optional title into the title field at the top of the page.
- Paste one strict x,y numeric pair per non-empty line into the input box. Use a single comma between the two numbers. Signed values, decimals, zero, and scientific notation such as 1e3 are accepted.
- Click Generate. The parser checks the first 200 non-empty rows for exactly two finite numbers, each with an absolute magnitude of 1e12 or less.
- Read the summary that appears under the chart. It reports valid points, invalid rows, and over-limit rows as three separate numbers, including when any count is zero.
- Inspect the preview. Verify the axis ranges shown in the five reference labels, hover over representative points, and confirm the count of blue circles matches your valid rows.
- Click Download SVG. The file is byte-identical to the preview because both use the same percent-encoded SVG data URI derived from one generated string.
- If you edit the title or paste new data, the download is disabled and the previous chart is cleared until you generate again.
Read the Three Row Counts
The summary line under the chart separates three buckets that are easy to confuse. Knowing which is which prevents silent data loss when you paste a large block.
| Input line | Bucket | Reason |
|---|---|---|
| 1.5, 3 | valid point | Two finite numbers, strict comma format |
| 2, -4.2 | valid point | Signed decimals are accepted |
| 1e3, 0 | valid point | Scientific notation and zero both fine |
| -0, 4 | valid point | Negative zero normalized to zero |
| (blank line) | ignored | Blank rows are skipped, never counted |
| 5, | invalid row | Empty y component fails strict format |
| abc, 7 | invalid row | Non-numeric x is invalid |
| 1, 2, 3 | invalid row | Extra comma, more than two components |
| 5e15, 1 | invalid row | Magnitude above 1e12 is invalid |
| Any row past the 200th non-empty line | over-limit row | Not parsed, reported separately from invalid |
Invalid rows never become zero points or get pushed to an axis. Over-limit rows are never mixed into the invalid count because they were deliberately not parsed. If no valid point remains after generation, the tool reports an error and clears any older chart rather than saving a half-built file.
How Constant Axes Are Handled
When every x value in your data is the same number, the smallest x and the largest x are equal. A naive linear layout would divide by zero and produce invalid coordinates, so the tool expands the x domain symmetrically around that constant value by ten percent of its absolute magnitude or one unit, whichever is larger. The same rule applies independently to a constant y column.
The practical result is that a single valid point sits centered on both axes instead of failing to render, and a vertical or horizontal line of identical coordinates still produces a readable chart with axis labels showing the expanded range. Always read the five reference lines before interpreting the apparent spread of a cluster, because the displayed range is not necessarily the range you typed and the axes do not automatically include zero.
Inspect and Download the SVG
The output file is a single 800 by 500 SVG with a white background, an optional title at the top, a light grid, numeric tick labels on both axes, and one blue circle per valid pair. Because SVG is a vector format, lines, text, and circles stay sharp when the file is resized for slides, printed handouts, or embedded web pages. Each circle carries an SVG title child element with the exact formatted x and y values for that point, so SVG-aware viewers show a tooltip on hover. For background on the format itself, the MDN SVG tutorial covers the elements the chart uses.
Text you typed into the title field is XML-escaped before it enters the markup, so ampersands, angle brackets, quotes, and apostrophes become XML entities and forbidden code points become the replacement character. A title containing closing tags or script-like text therefore stays visible text and cannot create SVG elements in the generated markup.
When You Need a Statistical Package Instead
The Scatter Plot Maker is a visualization, not a precision-preserving data format. Coordinates are rounded to three decimal places in the SVG and axis labels use practical significant digits, which is fine for a quick visual check but not a substitute for the original spreadsheet. The chart does not calculate a correlation coefficient, fit a regression line, draw confidence intervals, render error bars, estimate density, identify clusters, or report statistical significance.
If the task needs any of those, keep the source rows in Excel and use a dedicated plotting or statistics package. For dense data with overlapping points, categorical color, accessible labeling, logarithmic scales, or publication styling, the same rule applies: use a dedicated tool and retain the source dataset for reproducibility and uncertainty analysis. Overlapping points can hide one another, especially when identical pairs repeat, so always verify a representative sample by hovering and reading the formatted values in the SVG before publishing.
Related reading: Generate a Random Yes or No for Excel Sheets.