Microsoft KB Archive/103086: Difference between revisions

From BetaArchive Wiki
(importing KB archive)
 
m (Text replacement - "<" to "<")
 
Line 32: Line 32:
<pre class="CODESAMP">  SELECT RECNO() AS num, price, ltotal, price/ltotal*100 AS percent ;
<pre class="CODESAMP">  SELECT RECNO() AS num, price, ltotal, price/ltotal*100 AS percent ;
       FROM \foxprow\tutorial\detail ;
       FROM \foxprow\tutorial\detail ;
       WHERE recno()&lt;101 ;
       WHERE recno()<101 ;
       INTO CURSOR query
       INTO CURSOR query
   DO (_gengraph) </pre>
   DO (_gengraph) </pre>

Latest revision as of 10:17, 20 July 2020

How to Graph Multiple Data Items Using Microsoft Graph

ID: Q103086



The information in this article applies to:

  • Microsoft FoxPro for Windows, versions 2.5, 2.5a




SUMMARY

Microsoft Graph can be used from within FoxPro to graph multiple data items. By default, Graph is in row orientation. To graph items in a database so that they appear as expected, you may have to change this orientation. To do this, open Graph, and choose Series In Columns from the DataSeries menu.


MORE INFORMATION

This problem is demonstrated in the following example:

   SELECT RECNO() AS num, price, ltotal, price/ltotal*100 AS percent ;
      FROM \foxprow\tutorial\detail ;
      WHERE recno()<101 ;
      INTO CURSOR query
   DO (_gengraph) 

To correctly view the data in the graph, the user must double-click the first generated graph and change to column orientation by choosing Data In Columns from the DataSeries menu in Microsoft Graph. Additional query words: FoxWin 2.50 msgraph ms graph

Keywords          : FxprgGeneral 
Version           : 2.50 2.50a
Platform          : WINDOWS 
Issue type        : 

Last Reviewed: August 19, 1999
© 1999 Microsoft Corporation. All rights reserved. Terms of Use.