From: Khanh on
If I have an excel file such as:
A B C
1 1 14
1 2 43
1 3 24
2 1 25
2 2 87
2 3 3
3 1 23
3 2 34
3 3 7

How can I make a contour plot of A, B, and C? I tried different methods that I found online but doesn't work. Please show me a simple way to do this.
From: Sean on
"Khanh " <kdcung(a)mtu.edu> wrote in message <i3pj5q$d4g$1(a)fred.mathworks.com>...
> If I have an excel file such as:
> A B C
> 1 1 14
> 1 2 43
> 1 3 24
> 2 1 25
> 2 2 87
> 2 3 3
> 3 1 23
> 3 2 34
> 3 3 7
>
> How can I make a contour plot of A, B, and C? I tried different methods that I found online but doesn't work. Please show me a simple way to do this.

If I understand you properly (a big if)
% 1 1 14
% 1 2 43
% 1 3 24
% 2 1 25
% 2 2 87
% 2 3 3
% 3 1 23
% 3 2 34
% 3 3 7

val = [14
43
24
25
87
3
23
34
7];

val = reshape(val,3,3)';
contour(val);
From: Khanh on
Sean,
your answer works for the hypothetical problem that I posted. But what I was really looking for is to have A, B values on the axis.
Another way to say is, if I have
A=[1 3 6 8 1 3 6 8]
B=[1 1 1 1 2 2 2 2]
C=[3 6 2 8 3 5 3 6]
how Contour(A,B,C)??
From: Walter Roberson on
Khanh wrote:

> your answer works for the hypothetical problem that I posted. But what I
> was really looking for is to have A, B values on the axis.
> Another way to say is, if I have
> A=[1 3 6 8 1 3 6 8]
> B=[1 1 1 1 2 2 2 2]
> C=[3 6 2 8 3 5 3 6]
> how Contour(A,B,C)??

With difficulty.

I suggest you consider using gridfit
http://www.mathworks.com/matlabcentral/fileexchange/8998-surface-fitting-using-gridfit
From: Sean on
"Khanh " <kdcung(a)mtu.edu> wrote in message <i3pks4$2h5$1(a)fred.mathworks.com>...
> Sean,
> your answer works for the hypothetical problem that I posted. But what I was really looking for is to have A, B values on the axis.
> Another way to say is, if I have
> A=[1 3 6 8 1 3 6 8]
> B=[1 1 1 1 2 2 2 2]
> C=[3 6 2 8 3 5 3 6]
> how Contour(A,B,C)??

A=[1 3 6 8 1 3 6 8]
B=[1 1 1 1 2 2 2 2]
C=[3 6 2 8 3 5 3 6]

[rr cc] = meshgrid([1 2],[1 3 6 8])
contour(rr,cc,reshape(C,4,2))

Do you mean this? You still haven't specified _exactly_ what you expect.

Or do you mean this:
contour([A.',B.'],C)

It's very difficult to gauge what you want.