Hi,
I have the following set of data in excel and I want to create a surface data where each Z value is a slightly different shade of colour.The finally surface plot should resemble an image of a 20cent coin however when I do this in excel my plot doesnt resemble a 20cent coin in the slightest.Any help please?Thanks!!!
John
X Y Z
0 0 0.00E+00
2.5 0 0.00E+00
5 0 0.00E+00
7.5 0 0.00E+00
10 0 0.00E+00
12.5 0 0.00E+00
15 0 0.00E+00
17.5 0 0.00E+00
20 0 0.00E+00
22.5 0 0.00E+00
25 0 0.00E+00
0 2.5 3.04E-01
2.5 2.5 1.68E-01
5 2.5 2.00E-01
7.5 2.5 2.64E-01
10 2.5 2.80E-01
12.5 2.5 2.40E-01
15 2.5 1.44E-01
17.5 2.5 8.00E-03
20 2.5 8.00E-03
22.5 2.5 8.00E-03
25 2.5 8.00E-03
0 5 8.00E-03
2.5 5 8.00E-03
5 5 8.00E-03
7.5 5 1.28E-01
10 5 2.48E-01
12.5 5 2.72E-01
15 5 1.92E-01
17.5 5 3.28E-01
20 5 2.72E-01
22.5 5 3.76E-01
25 5 2.48E-01
0 7.5 2.48E-01
2.5 7.5 3.76E-01
5 7.5 2.72E-01
7.5 7.5 3.28E-01
10 7.5 1.92E-01
12.5 7.5 2.72E-01
15 7.5 2.48E-01
17.5 7.5 1.28E-01
20 7.5 8.00E-03
22.5 7.5 8.00E-03
25 7.5 8.00E-03
0 10 8.00E-03
2.5 10 8.00E-03
5 10 1.60E-02
7.5 10 1.12E-01
10 10 1.68E-01
12.5 10 1.76E-01
15 10 3.04E-01
17.5 10 6.00E-01
20 10 5.20E-01
22.5 10 3.84E-01
25 10 5.44E-01
0 12.5 5.44E-01
2.5 12.5 3.84E-01
5 12.5 5.20E-01
7.5 12.5 6.00E-01
10 12.5 3.04E-01
12.5 12.5 1.76E-01
15 12.5 1.68E-01
17.5 12.5 1.12E-01
20 12.5 1.60E-02
22.5 12.5 8.00E-03
25 12.5 8.00E-03
0 15 8.72E-01
2.5 15 7.04E-01
5 15 3.84E-01
7.5 15 4.00E-01
10 15 4.16E-01
12.5 15 2.24E-01
15 15 1.28E-01
17.5 15 8.80E-02
20 15 8.00E-03
22.5 15 8.00E-03
25 15 8.00E-03
0 17.5 9.28E-01
2.5 17.5 7.84E-01
5 17.5 5.20E-01
7.5 17.5 2.40E-01
10 17.5 2.24E-01
12.5 17.5 2.72E-01
15 17.5 1.28E-01
17.5 17.5 6.40E-02
20 17.5 8.00E-03
22.5 17.5 8.00E-03
25 17.5 8.00E-03
0 20 8.00E-03
2.5 20 8.00E-03
5 20 8.00E-03
7.5 20 8.00E-03
10 20 5.60E-02
12.5 20 1.04E-01
15 20 1.92E-01
17.5 20 2.00E-01
20 20 2.80E-01
22.5 20 4.96E-01
25 20 8.32E-01
0 22.5 8.00E-03
2.5 22.5 8.00E-03
5 22.5 8.00E-03
7.5 22.5 8.00E-03
10 22.5 1.60E-02
12.5 22.5 5.60E-02
15 22.5 8.00E-02
17.5 22.5 2.16E-01
20 22.5 1.36E-01
22.5 22.5 2.32E-01
25 22.5 4.72E-01
0 25 8.00E-03
2.5 25 8.00E-03
5 25 8.00E-03
7.5 25 8.00E-03
10 25 8.00E-03
12.5 25 8.00E-03
15 25 1.60E-02
17.5 25 8.80E-02
20 25 1.60E-01
22.5 25 1.84E-01
25 25 1.76E-01