Hi John,
You're right that Excel doesn't have a built-in feature to create 3-dimensional plots over three dimensions. However, there is a workaround that you can use to create a 3D plot in Excel.
Here are the steps to create a 3D plot in Excel:
- Enter your data into Excel. You will need three columns of data: one for the x-axis, one for the y-axis, and one for the z-axis.
- Select the data range that you want to plot.
- Click on the Insert tab in the Excel ribbon.
- Click on the Surface chart type in the Charts section.
- Select the 3-D Surface chart subtype.
- Excel will create a 3D chart over two dimensions (x and y) with the z-axis represented by the height of the chart.
- To add the third dimension to the chart, you can use a color scale or a contour plot. To do this, click on the chart to select it, then click on the Chart Tools tab in the Excel ribbon.
- Click on the Format tab in the Chart Tools section.
- In the Current Selection group, select the Series option.
- In the Format Data Series pane, select the Fill & Line tab.
- Under Fill & Line, select the Gradient Fill option.
- Choose a color scale or a contour plot from the options provided.
- Adjust the settings as needed to customize the appearance of your 3D plot.
I hope this helps you create the 3D plot you were looking for in Excel. Let me know if you have any other questions!