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 Comments

Anybody would need data to do much...attach the .xls file or read it and attach a .mat file

Sign in to comment.

 Accepted Answer

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

More Answers (0)

Categories

Find more on 2-D and 3-D Plots in Help Center and File Exchange

Products

Release

R2019a

Asked:

on 12 Dec 2020

Answered:

on 12 Dec 2020

Community Treasure Hunt

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

Start Hunting!