MATLAB Answers

How to create a colourmap from coordinates and values from excel?

3 views (last 30 days)
Sam on 11 Jun 2021
Commented: Adam Danz on 11 Jun 2021
I am looking to produce a colourmap
My data is in excel with one column for the x-axis and y-axis co-ordiantes, with values attributed to each point. I am looking to make a colourmap with this data.
For example:
Lateral: Depth: CL:
0 0 2.8
0 1 3.2
0 2 9.4
0 3 21.5
0 4 25.1
0 5 29.1
1 1 3.5
1 2 3.5
1 3 8.2
1 4 19.0
1 5 27.6
1 6 28.2
So lateral is the x co-ordinate, depth is the y co-ordinate and CL is the value I want to plot.
I am fairly new to MatLab and have not produced anything like this before.
Thank you in advance!

Accepted Answer

Adam Danz
Adam Danz on 11 Jun 2021
Edited: Adam Danz on 11 Jun 2021
The type of plot was not mentioned. If you're creating a scatter plot, it's as easy as,
scatter(Lateral, Depth, 30, 'CL', 'filled')
where the 3rd input specifies the size of the markers. scatter(x,y,sz,c)
Update If you want a rectangular image, use imagesc(x,y,C) but first you need to reshape C into a matrix with rows and columns defined by x and y. That's shown in this answer.

Sign in to comment.

More Answers (0)





Community Treasure Hunt

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

Start Hunting!