Create 3D plot using Excel data

1 view (last 30 days)
Romain Bouvet
Romain Bouvet on 12 Jan 2021
Answered: Cris LaPierre on 12 Jan 2021
Hello,
I have an Excel file containing around 10.000 row and 15 columns, with 10 first column are parameters my robot (for example foot length, arm width, ...) and last 5 columns are results (each row have a completely different kind of data for example speed, jump height, ...). Each row is a different combination of all parameters with it's results.
I want to be able to create 3D plots with on each axis a parameter and on colour a result.
Can you please indicate me the best method to perform this ?
NB : I'm completely a newbie on Matlab, sorry for that.

Answers (1)

Cris LaPierre
Cris LaPierre on 12 Jan 2021
When you say you are a complete newbie, my first recommendation is to complete MATLAB Onramp.
Your problem has 2 parts
  1. Importing your data into MATLAB
  2. Creating a 3D plot
Importind Data and simple plotting are both topics covered in onramp. They likely won't cover exactly what you'll need to do, but will build a good foundation to build on.
Once you have those fundamentals, I suggest this page on importing spreadsheet data.
As for creating 3D plots, there are a variety of options depending on what type of plot you want: iine, scatter, mesh, contour, etc. Ch 8 of MATLAB Onramp is probably relevant here, as the documentation is a good place to start. It will help you with the syntax and give you examples to help you get started.

Products


Release

R2018b

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!