Excel 2007 Surface Plot with Logarithmic vertical axis crash

[James M]

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.002029419,0.003849506
0.9,0.155748367,0.148407936,0.148925304,0.004602432,0.003372192,0.00288868,0.003694534,0.001461506,0.001527786,0.001524925
0.8,0.005078793,0.002126217,0.001059532,0.001092911,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.001086235,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.000242233,0.000196457,0.000254154,0.000247002,0.000178814,0.000291348,0.000185966
0.3,0.003354549,0.001691341,0.000842571,0.000272751,0.000409603,0.000255585,0.000771046,0.000388145,0.000174522,0.00016737
0.2,0.000622749,0.000359535,0.000285149,0.000220776,0.000175953,0.000436306,0.000161648,0.000183582,0.000145435,0.00013876
0.1,0.000203609,0.000220299,0.000144482,0.000221252,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

 

[Bernard Liengme]

Confirmed. Works OK in XL2003 but hangs XL2007
If the data is multiplied by 1000 then log scale works.
I will report this as error
best wishes

 

[James M]

Thanks for your help Bernard,

and for pointing out it works when multiplied by 1000, this can be a
temporary fix. Also if the chart is plotted in XL2003 and imported to 2007
the chart is still broken (vertical axis occupies approx 10% of whole axis),
making changes crashes XL again.

Should i call Microsoft support to get a fix for this? (I don't want to
start my 90 day support period) How long does a fix normally take to appear?

Thanks

James

 

[Bernard Liengme]

No, do not call MS. You will just get a tech support person.
As an MVP, I have a way of telling the actual Excel development team about
the problem. I have already done this.
best wishes

 

[Jon Peltier]

And Bernard forgot to warn you not to hold your breath.

- Jon