View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.charting
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default Excel 2007 Surface Plot with Logarithmic vertical axis crash

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
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"James M" wrote in message
...
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" wrote:

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
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"James M" wrote in message
...
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