How to Plot a Sphere from X, Y, and Z Coordinates in Excel
Question details
The user needs to create a 3D sphere visualization from calculated X, Y, and Z coordinate columns in an Excel-compatible spreadsheet.

- Product
- WPS Office Spreadsheet (Excel-compatible)
- Device & OS
- not provided
- Scenario
- The user has generated sphere coordinates in three columns and wants to render them as a rotatable 3D sphere chart.
- Observed behavior
- Standard Excel and WPS charts have limited native support for true 3D scatter plots, so a regular scatter or bubble chart does not directly produce a true XYZ sphere.
Prepare an Excel-compatible workbook with X, Y, and Z coordinate columns generated from a parametric sphere formula. Verify that all three columns have the same number of rows, contain numeric values, and use a shared radius and angle range before charting.
Generate sphere coordinates in X, Y, and Z columns
Use this foundational method to prepare the raw data that any 3D chart tool or Excel-compatible solution requires.
A sphere can be expressed with radius R, latitude, and longitude. Storing the resulting X, Y, and Z values in separate columns makes the data ready for chart tools that support XYZ datasets.
Open WPS Office Spreadsheet, create a new worksheet, and enter X, Y, and Z as headers in cells A1, B1, and C1.
In row 2, enter =$E$1*COS(RADIANS(F2))*COS(RADIANS(G2)) for X, =$E$1*COS(RADIANS(F2))*SIN(RADIANS(G2)) for Y, and =$E$1*SIN(RADIANS(F2)) for Z, where E1 is radius, F2 is latitude, and G2 is longitude.
Create rows of latitude and longitude pairs in columns F and G, then copy the formulas in A2:C2 down through all angle pairs and save the workbook.
Use a 3D rotation chart add-in or Excel-compatible 3D chart solution
Use this when you need a true XYZ scatter plot with rotation and equal axis scaling in Excel or WPS Spreadsheet.
Approximate the sphere with a native scatter or bubble chart
Use this only as a quick preview when you cannot run an external 3D chart tool and do not require true XYZ rotation.
Plot and Share Sphere Coordinate Workbooks with WPS Office Free
True XYZ sphere plots require a 3D charting add-in because native Microsoft Excel has limited 3D scatter support. WPS Office is a free, lightweight alternative that opens and edits your coordinate workbooks, supports Excel file formats, and offers a familiar interface for turning your XYZ data into preview charts before you use a dedicated 3D rotation tool.
- 1. Download and install WPS Office: Click Download WPS Office Free, install it on your Windows, macOS, Linux, or mobile device, and open the spreadsheet app.
- 2. Open your coordinate workbook: Go to Menu > Open, select your .xlsx or .xls file, and verify that the X, Y, and Z columns are intact.
- 3. Create a preview chart: Select the X and Y columns, go to Insert > Chart, choose Scatter or Bubble, and map Z to bubble size as a visual check.
- 4. Continue with your 3D tool: Use your Excel-compatible 3D rotation add-in to generate the true XYZ sphere, then save the result in a format WPS Office can reopen.

Frequently Asked Questions
Can I create a true 3D scatter plot natively in Excel or WPS Office?
No. Neither Microsoft Excel nor WPS Office Spreadsheet has a native XYZ scatter plot type. You need a 3D rotation workbook, add-in, or another 3D charting solution that accepts X, Y, and Z coordinate columns.
How do I keep the sphere from looking stretched or distorted?
Set the X, Y, and Z axes to the same minimum and maximum values, or use an equal-aspect 3D chart tool. Unequal axis scales make the sphere appear elliptical.
What formula generates sphere coordinates for the chart?
For radius R, latitude L, and longitude G: X=R*COS(L)*COS(G), Y=R*COS(L)*SIN(G), and Z=R*SIN(L). Use RADIANS() in Excel or WPS Spreadsheet when your angles are in degrees.
Can WPS Office open the Andy Pope 3D rotation workbook?
WPS Office Spreadsheet can usually open Excel workbooks, including .xls and .xlsm files. Macro support depends on the WPS version, so enable macros or active content if prompted.
What chart type should I use in WPS Office if I cannot use a 3D add-in?
Use a Scatter or Bubble chart as a preview. Map X and Y to the axes and Z to bubble size, then set equal axis scales. This is not a true XYZ scatter plot, but it gives a useful 2D or pseudo-3D view.





