Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Graphs
Message
De
18/01/2000 02:11:15
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
Re: Graphs
Divers
Thread ID:
00318861
Message ID:
00319318
Vues:
20
>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform