I have an Excel sheet full of data with 4 different parameters and 3 variables I want to draw 3D plot for these parameters. I couldn't do it in Excel. Is there any easy way to draw 3D plot except Matlab?
The thing is I have 3 different parameters which effects result which is m. so i want to draw m against x,y and z . I don know even t is right to call what I want 3D or not!
Yeah this is nice :) I want some thing like this. But the only problem is I have scatter data point and I don't have any relationship between m And x,y,z!
Sheida, you can use "Graphing Calculator 3D" to plot them. You can import and plot multiple data files, but the program doesn't sort them. So for the sorting part you probably need another software.
You might be able to use a program called XYZ Mesh. It converts XYZ data into a MESH format that Microsoft Excel can read. It also has a setting that will reduce the amount of rows and columns of the MESH data into a number small enough to graph inside Microsoft Excel.
Perhaps BioVinci will meet your needs (if you're still looking for the one). It works for my 3D scatter plot. I believe the interactive stuffs and tooltip function over there will be helpful for you.
Their web version is kinda cool, but it seems to work best for small data. You can download one if your data is big.
I usually use MATLAB. If you want to plot 3D graphics, you only need your vectors [x, y, z] and use the commands: MESH (the mesh function creates a wireframe mesh) and SURF (the surf function is used to create a 3-D surface plot). Here you will find more information: https://www.mathworks.com/help/matlab/ref/meshgrid.html
You can try "MINITAB" software ( https://www.minitab.com/en-us/ ). Its a statistical tools and easy to use. Also, I can introduce you a free and useful statistical data analysis software, namely "PAST"