How to Draw a Boundary Around Points in an Excel Scatter Plot with WPS Office
Question details
A scatter plot cannot automatically create an outer boundary around geographic or coordinate-based points; the user needs to calculate boundary points and add them as a separate XY line series.
- Product
- WPS Office Spreadsheets
- Device & OS
- not provided
- Scenario
- The user wants to enclose plotted coordinate or geographic points with a clear outer boundary in a scatter plot.
- Observed behavior
- The scatter plot displays the individual data points but does not automatically generate an outer boundary or outline around the point set.
Open the workbook containing the point coordinates and confirm the scatter plot already displays the data points. You will also need the calculated hull or boundary coordinates ready in the same worksheet before adding the second series.
Add a Calculated Boundary as a Second Scatter Series in WPS Office Spreadsheets
Use this method when you need a clean, printable boundary around point data and can calculate the hull points manually or with a helper tool.
A scatter plot only draws the provided series. To create an outer boundary, calculate the convex hull of the X and Y coordinate pairs, then add those hull points as a second XY series with lines and no markers.
For complex geographic or irregular datasets, a GIS or computational-geometry tool may help generate the hull coordinates before you paste them into WPS Spreadsheets.
Select the X and Y columns, click the Insert tab, and choose Scatter to insert or confirm the scatter chart that displays the original points.
Right-click the chart and choose Select Data, then click Add and enter the calculated hull points as a new XY series.
Right-click the new boundary series, choose Format Data Series, set a line style for the outline, and set Markers to None so only the boundary appears.
Draw a Scatter Plot Boundary in WPS Office Spreadsheets
Create a second XY series from calculated hull coordinates in WPS Office Spreadsheets to add a clean boundary around scatter plot points without leaving your workbook.
- 1. Open your workbook: Launch WPS Office, open the workbook that contains the scatter plot coordinates, and select the scatter chart area.
- 2. Add the calculated XY series: Right-click the chart, choose Select Data, then click Add and specify the hull coordinate range for the boundary series.
- 3. Format the outline: Select the new series, set the line color and width for the boundary, and choose No Markers so only the outline is displayed.
- 4. Save or export: Click File, choose Save As, and save the workbook as .xlsx to keep the chart compatible with Excel and WPS Office.
Frequently Asked Questions
Why does a scatter plot not create a boundary automatically?
A scatter plot only calculates axes, scales, and plot points from the supplied data. It does not run geometric boundary detection, so you must calculate hull or outline points and add them as a separate series.
How do I calculate the convex hull points for my scatter plot?
You can calculate convex hull coordinates in a GIS tool, a computational geometry library, or manually for small datasets, then paste the ordered boundary X and Y pairs into your WPS Spreadsheets worksheet.
Can I add the boundary to an existing chart without recreating it?
Yes. Right-click the existing scatter chart, choose Select Data, click Add, and define a second XY series using the boundary coordinate cells.
How do I make the boundary line show without markers?
Select the boundary series, open Format Data Series or the line settings, choose a solid or dashed line, and set the marker option to None.
Does this method work for irregular or concave shapes?
A convex hull works for a simple outer outline. Irregular or concave boundaries require polygon points from a GIS or geometry tool and may need a line series or shape overlay instead.
