LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 8
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007: Contour map (surface map) Sam Charts and Charting in Excel 1 April 14th 08 12:50 PM
Excel 2007 - Switch vertical and horizontal axis? Beach Lover Excel Discussion (Misc queries) 3 February 13th 08 03:41 AM
logarithmic charting and excel 2007 jonny Charts and Charting in Excel 3 July 16th 07 04:49 AM
can I make the vertical axis the category axis in Excel line graph power1 Charts and Charting in Excel 1 March 20th 06 08:45 PM
How do I plot multiple 3D surface charts David in Jakarta Charts and Charting in Excel 1 February 13th 06 12:11 PM


All times are GMT +1. The time now is 08:14 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"