Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Graphs
Message
From
18/01/2000 02:11:15
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Re: Graphs
Miscellaneous
Thread ID:
00318861
Message ID:
00319318
Views:
21
>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
*  .CrossesAt = nValue && Setting this with xlCustom is better as I could see
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
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Reply
Map
View

Click here to load this message in the networking platform