Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |