I have a table of data, however, it is in 2D (XY):

X 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
Y 4 4 4 4 10 15 20 25 25 25 25 25 25 20 15 10 4 4 4 4

And the graph obtained will look like this:

So, here is my problem. Actually, I want to plot a 3D graph that will look exactly like the image attached above when we see it in 2D, but to plot the 3D graph, I do not have any ideas about the Z data or Z equation that I need to consider.

Below is the example of 3D graph that I want:

I am so sorry if my question is confusing. I really hope someone can help me. I need help in identifying the Z equation in order for me to produce the 3D graph.

After the 3D graph is obtained, I need to proceed with calculating its slope. That is why I really need to know how to plot a 3D graph based on the image attached.

2

1 Answer

This video contains a tutorial for creating 3d graphs in Excel.

Once your X and Y data are properly prepared (in a column and a row respectively), you can enter the Z data in the cells corresponding to each X and Y value. In the video, this is done via a formula.

To create a Surface graph like the video demonstrates, click Insert, Other Charts, then one of the icons under Surface.

Other methods of plotting 3d data can be found here and here.

2

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password Submit

Post as a guest

Post Your Answer Discard

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy