>I'm sorry. I'll explain. On one of the series I show the months Jan. throught Dec. When it displays negative values the Jan. throught Dec. axis moves to the top. It's like the chart is display upside down. Try going to this address to view the chart.
>
>
http://ec.innova.net/cgi-bin/ec.exe/graphdata@trg/ec?custcode=1001&graph=ppv
Unfortunately I couldn't see your graph (image missing ?). Here is what I understand :
with .Axes(xlValue)
#define xlCustom -4114
#define xlMinimum 4
#define xlMaximum 2
.Crosses = xlMinimum
endwith
Can be applied to category and value axes and "only" in 2D charts.
BTW: Although not precise everytime, you can create a similar graph in excel, start recording a macro, apply formatting as you like. Then stop the macro, go to macros and edit your macro. There you can get nearly all you want. Each time I use this I had to furnish syntax to accomodate VFP syntax but with very little changes. Invaluable in complex things especially when you don't know which property-method to use. vbagrp8.hlp and vbaxl8.hlp (vbagrp9 and vbaxl9 for 2000) fill the gap (actually they're placed as shortcuts on my system quicklaunch toolbar).
Cetin