MATLAB: Shade Area Between 2 Tabulated Plots.

importing excel datamultipleplot

Hello,

I have written a script which plots 2 curves from excel data. Could someone please help me as to how I can shade the area between the 2 curves?

This is my Script:

UserDir = 'C:\Users\****\Downloads\Test.xlsx';
SheetNameA = 'Sheet1';
Y_Values = readtable(UserDir,'Sheet',SheetNameA,'Range','A2:A150');
X_Values1 = readtable(UserDir,'Sheet',SheetNameA,'Range','C2:C150');
X_Values2 = readtable(UserDir,'Sheet',SheetNameA,'Range','D2:D150');
Y_data = Y_Values{:,1};
X_Data1 = X_Values1{:,1};
X_Data2 = X_Values2{:,1};
plot(X_Data1,Y_data,'b','Linewidth',1);
hold on
plot(X_Data2,Y_data,'b','Linewidth',1);
hold off

Please see the attached excel sheet (and change the UserDir).

To Clarify I would like something like this:

Thanks Everyone!

Best Answer

This is as close as I can get:

Y_Values = readtable(UserDir,'Sheet',SheetNameA,'Range','A2:A150','ReadVariableNames',0);
X_Values1 = readtable(UserDir,'Sheet',SheetNameA,'Range','C2:C150','ReadVariableNames',0);
X_Values2 = readtable(UserDir,'Sheet',SheetNameA,'Range','D2:D150','ReadVariableNames',0);
Y_data = Y_Values{:,1};
X_Data1 = X_Values1{:,1};
X_Data2 = X_Values2{:,1};
Y_data = Y_data(~isnan(Y_data));
X_Data1 = X_Data1(~isnan(X_Data1));
X_Data2 = X_Data2(~isnan(X_Data2));
figure
plot(X_Data1(1:end-1),Y_data(1:end-1),'b','Linewidth',1);
hold on
plot(X_Data2(1:end-1),Y_data(1:end-1),'b','Linewidth',1);
patch([X_Data1(1:end-2); X_Data2(end-1); flipud([X_Data2(1:end-2); X_Data1(end-1)])], [Y_data(1:end-1); flipud(Y_data(1:end-1))], 'r')
hold off
xlim([750 960])

There were a number of NaN values in your vectors that were interfering with the subscript referencing. I had to eliminate them, however their elimination do not appear to have affected the result. There were also some straight lines at the tops of each curve that I had to eliminate (they would have made the patch call much more difficult), thus the ‘(1:end-2)’ indexing. The concatenation of the vectors is necessary to join the curves at both ends, to create a filled figure.

This code then produces:

Shade Area Between 2 Tabulated Plots - 2019 10 12.png

I could not isolate the problem with the area at the top of the filled area.

Related Solutions

MATLAB: Plotting position every 10 secound

Adding this after the first loop gave me somehow the result that I needed, but it is not a nice piece of code..

axis([-0,400,-200,200])
hold on
% Data
x1 = squeeze(x_V);
y1 = squeeze(y_V);
N1 = NaN(size(x1));
x2 = squeeze(x_O);
y2 = squeeze(y_O);
N2 = NaN(size(x2));
% Create the line and get its X and Y data
h1 = plot(N1, N1);
h2 = plot(N2, N2);
xdata1 = get(h1, 'XData');
ydata1 = get(h1, 'YData');
xdata2 = get(h2, 'XData');
ydata2 = get(h2, 'YData');
for k = 1:length(x1)
    xdata1(k) = x1(k);
    ydata1(k) = y1(k);
    xdata2(k) = x2(k);
    ydata2(k) = y2(k);
    % Update the plot
    set(h1, 'XData', xdata1, 'YData', ydata1, 'Color', 'red');
    set(h2, 'XData', xdata2, 'YData', ydata2, 'Color', 'blue');
      drawnow
  end
for k = 1:100:length(x1)
    xdata1(k) = x1(k);
    ydata1(k) = y1(k);
    xdata2(k) = x2(k);
    ydata2(k) = y2(k);
      plot(xdata1(k),ydata1(k),'ro')
      plot(xdata2(k),ydata2(k),'bo')
  end

MATLAB: GA is not working…Function i have written separately calling in main program but not worked?

There are two version of code which are working but do not converge.

First:

xdata =[ 1 2 3 4 5 6] ;
ydata=(1./(xdata.^2+2*xdata+4));
FitnessFunction = @(x) sum((x(1)./(x(2).*xdata.^1.9+x(3).*xdata.^0.9+1)-ydata).^2);
numberOfVariables = 3;
x =ga(FitnessFunction,numberOfVariables)

Second:

xdata =[ 1 2 3 4 5 6] ;
ydata=(1./(xdata.^2+2*xdata+4));
numberOfVariables = 3;
x =ga(FitnessFunction,numberOfVariables)
%in separate file
function y=simple_fitness(xdata,ydata)
y=@(x) sum((x(1)./(x(2).*xdata.^1.9+x(3).*xdata.^0.9+1)-ydata).^2)
end

Best Answer

Related Solutions

MATLAB: Plotting position every 10 secound

MATLAB: GA is not working…Function i have written separately calling in main program but not worked?

Related Question