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 commentaires

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.

Connectez-vous pour commenter.

 Réponse acceptée

A = xlsread("Contour.xlsx") ;
x = A(1,2:end) ;
y = A(2:end,1) ;
Z = A(2:end,2:end) ;
contourf(x,y,Z)

Plus de réponses (0)

Catégories

En savoir plus sur 2-D and 3-D Plots dans Centre d'aide et File Exchange

Produits

Version

R2019a

Community Treasure Hunt

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

Start Hunting!

Translated by