Problem with log scale in Excel 2007

[random379]

I have a program to construct log probability graphs in Excel. The graphs have a log scale on the x axis. It was originally written in vba in xl2003 and runs without a problem. An example of the output in shown in pic2.jpg.
When I run the the same program in XL2007 on my desktop pc (w7 Home Premium 64 bit OS), it runs but with a different result as shown in pic1.jpg.
The code where it goes wrong is:

Please Login or Register  to view this content.

I can step thru the code to the line .ScaleType = xlLogarithmic and everything is fine. As soon as I step past this line, the graph goes as shown in pic1 and the program goes to completion without any program errors.

So what am I doing wrong? What has me beaten is that if I run the same code on my laptop which has XL2007 and is running W7 Ultimate on a 64bit OS, it runs without any problems and I get the same result as pic2.

I have copied the xls from XL2003 to the other machines so the same references etc should be used in all instances.
The problem is not a data problem as there are no negative or zero values in the data sets and the same results occur using many different data sets.


Any ideas gratefully accepted.

Thanks