MS Office Forum / Excel / Charting / April 2008
Excel 2007 Surface Plot with Logarithmic vertical axis crash
|
|
Thread rating:  |
James M - 22 Apr 2008 22:59 GMT 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 - 23 Apr 2008 00:45 GMT 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
 Signature Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email
> Hi, > I am attempting to plot a surface plot with a series of data in Excel [quoted text clipped - 26 lines] > 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 James M - 23 Apr 2008 13:46 GMT 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
> Confirmed. Works OK in XL2003 but hangs XL2007 > If the data is multiplied by 1000 then log scale works. [quoted text clipped - 30 lines] > > 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 - 24 Apr 2008 01:47 GMT 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
 Signature Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email
> Thanks for your help Bernard, > [quoted text clipped - 46 lines] >> > 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 Jon Peltier - 24 Apr 2008 02:24 GMT And Bernard forgot to warn you not to hold your breath.
- Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______
> 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 [quoted text clipped - 53 lines] >>> > 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
|
|
|