The description ‘Time at x-axis , cost at y-axis and Profit = revenue - cost at y-axis’ describes a 2D plot.
Try this:
D = xlsread('myfile.xlsx');
Time = D(:,1);
Revenuev = D(:,2);
Costmtx = D(:,3:end);
Profit = Revenuev - Costmtx;
figure
plot(Time, Costmtx)
hold on
plot(Time, Profit, '--')
hold off
grid
xlim([0 500])
Cc = sprintfc('Cost%d', 1:5);
Pc = sprintfc('Profit%d',1:5);
legend([Cc, Pc], 'Location','E')
A 3D version:
figure
plot3((Time*ones(1,5)), Costmtx, Profitmtx)
grid on
xlabel('Time')
ylabel('Cost')
zlabel('Profit')
view(15,15)
legend('1','2','3','4','5')
