Chart & Visualization Issues

How to Plot a Sphere from X, Y, and Z Coordinates in Excel

Emma BrownEmma Brown Nov 13, 2026 870 views

Question details

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

How to Plot a Sphere from X, Y, and Z Coordinates in Excel
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.
Before you start

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.

Solution 1

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.

1
Set up the coordinate columns

Open WPS Office Spreadsheet, create a new worksheet, and enter X, Y, and Z as headers in cells A1, B1, and C1.

2
Enter the sphere formula

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.

3
Fill the coordinate table

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.

Free Microsoft Office alternative

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. 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. 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. 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. 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.
Opens, edits, and saves .xlsx, .xls, and .csv sphere coordinate workbooks without losing data.Free and lightweight Office suite with a familiar ribbon interface for easy migration from Microsoft Excel.Built-in scatter and bubble charts let you preview X-Y-Z data before using a dedicated 3D rotation add-in.Compatible with Excel macros and add-ins in supported versions, so existing 3D chart workflows can continue.No subscription required to create, edit, and share your coordinate datasets.
QA img-9

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.