Excel 2007 Surface Plot with Logarithmic vertical axis crash
Hi,
I am attempting to plot a surface plot with a series of data in Excel 2007.
It plots fine, but when I try to make the vertical axis logarithmic (base10)
excel stops responding. Trying it on other computers the plot seems to work
without a problem in excel 2003, but crashes a friends excel 2007 also. The
data i am using is in csv format below, but i assume it is reproducible with
any data.
Can anyone help me plot this?
Thanks
James M
,1,0.9,0.8,0.7,0.6,0.5,0.4,0.3,0.2,0.1
1,1.112030506,1.10708952,1.062082767,1.064427376,0 .154501915,0.093814373,0.045709133,0.004607677,0.0 02029419,0.003849506
0.9,0.155748367,0.148407936,0.148925304,0.00460243 2,0.003372192,0.00288868,0.003694534,0.001461506,0 .001527786,0.001524925
0.8,0.005078793,0.002126217,0.001059532,0.00109291 1,0.000800133,0.000939369,0.001060009,0.001783848, 0.000533104,0.000521183
0.7,0.001777649,0.000542164,0.000788212,0.0009408, 0.000313282,0.000838757,0.000826359,0.000461102,0. 000377178,0.000418186
0.6,0.000479221,0.000511646,0.000487804,0.00108623 5,0.000458717,0.00031805,0.000252724,0.000243664,0 .000544548,0.000193596
0.5,0.004296303,0.000306606,0.000452995,0.0002985, 0.000286579,0.000244617,0.000190735,0.001344204,0. 004283905,0.000166416
0.4,0.000397682,0.004140854,0.000201702,0.00024223 3,0.000196457,0.000254154,0.000247002,0.000178814, 0.000291348,0.000185966
0.3,0.003354549,0.001691341,0.000842571,0.00027275 1,0.000409603,0.000255585,0.000771046,0.000388145, 0.000174522,0.00016737
0.2,0.000622749,0.000359535,0.000285149,0.00022077 6,0.000175953,0.000436306,0.000161648,0.000183582, 0.000145435,0.00013876
0.1,0.000203609,0.000220299,0.000144482,0.00022125 2,0.000259399,0.000463009,0.000213146,0.00014782,0 .000140667,0.000176907
0,0.000349998,0.000265121,0.000478268,0.000279427, 0.000739098,0.000171661,0.000926971,0.000136375,0. 000123501,0.000111103
|