Superimposing a line plot onto a contour plot using data from excel

I have a data sheel in excel, with a contour plot that outputs an Outlet Temperature of Harvested Milk in a Heat Exchanger as a function of Mass Flow Rate of Cooling Water and Number of Cows.
I also have a line plot of the Minimum Cooling Water Flow Rate to Output Milk at 13C as a Water Flow Rate vs Number of Cows graph.
I would like to import the Contour Plot Data and Line Plot Data from excel to Matlab, then plot the contour plot and superpose the line graph onto the contour plot as an isocontour.
I've attached images for clarity hopefully.

2 Kommentare

Anybody would need data to do much...attach the .xls file or read it and attach a .mat file
I've attached the excel file.

Melden Sie sich an, um zu kommentieren.

 Akzeptierte Antwort

KSSV
KSSV am 12 Dez. 2020
A = xlsread("Contour.xlsx") ;
x = A(1,2:end) ;
y = A(2:end,1) ;
Z = A(2:end,2:end) ;
contourf(x,y,Z)

Weitere Antworten (0)

Kategorien

Mehr zu 2-D and 3-D Plots finden Sie in Hilfe-Center und File Exchange

Produkte

Version

R2019a

Gefragt:

am 12 Dez. 2020

Beantwortet:

am 12 Dez. 2020

Community Treasure Hunt

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

Start Hunting!

Translated by