Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Excel 2007 Surface Plot with Logarithmic vertical axis crash
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 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Excel 2007 Surface Plot with Logarithmic vertical axis crash
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 |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
Excel 2007 Surface Plot with Logarithmic vertical axis crash
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 _______ "Bernard Liengme" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007: Contour map (surface map) | Charts and Charting in Excel | |||
Excel 2007 - Switch vertical and horizontal axis? | Excel Discussion (Misc queries) | |||
logarithmic charting and excel 2007 | Charts and Charting in Excel | |||
can I make the vertical axis the category axis in Excel line graph | Charts and Charting in Excel | |||
How do I plot multiple 3D surface charts | Charts and Charting in Excel |