DOCUMENT:Q140291 15-APR-1999 [foxpro] TITLE :HOWTO: Call the Graph Wizard & Create a Chart Programmatically PRODUCT :Microsoft FoxPro PROD/VER:MACINTOSH:3.0b; WINDOWS:3.0,3.0b,5.0,5.0a,6.0 OPER/SYS: KEYWORDS:kbvfp300 kbvfp300b kbvfp500 ====================================================================== ------------------------------------------------------------------------------- The information in this article applies to: - Microsoft Visual FoxPro for Windows, versions 3.0, 3.0b, 5.0, 5.0a, 6.0 - Microsoft Visual FoxPro for Macintosh, version 3.0b ------------------------------------------------------------------------------- SUMMARY ======= You can create a Chart in Microsoft Graph from the data in the currently selected work area by calling the Graph Wizard programmatically. MORE INFORMATION ================ To create a Chart programmatically, use this syntax: SELECT DO (_GENGRAPH) WITH [,] [,]...[,]. NOTE: If DO command listed above causes the error "File does not exist," an alternative command is: DO HOME() + 'wizards\wzgraph.app' WITH [,] ... [,] IMPORTANT: this code will not work in an executable run outside of Visual FoxPro. The Graph Wizard will always take its data from the currently selected table. The Graph Wizard application (Wzgraph.app) accepts these parameters: parm1 - "AUTOGRAPH" (required) parm2 - chart type (numeric) parm3 - chart subtype (numeric) parm4 - title (character) parm5 - series by row / column (logical) parm6 - has legend (logical) parm7 - use autoformat (logical) parm8 - output DBF (character) parm9 - don't display graph with MODIFY GENERAL (logical) How the Parameters Interact with Each Other ------------------------------------------- Parm1 - "AUTOGRAPH" If a character string other than "AUTOGRAPH" is specified, Visual FoxPro will present either Step 1 (if no table is open) or Step 2 of the interactive Graph Wizard. If you use "AUTOGRAPH" and no table is open, the Graph Wizard returns an error, if a table is open, the resulting behavior depends on the value of parm8. Parm8 - output DBF If Parm8 is omitted or empty (for example, " "), you will be prompted for an output file name. If you supply the name of an output file, it must be an existing .dbf file that contains a General field. If the file does not exist, the Graph Wizard returns this error: The table you selected is already in use. WARNING: If the file exists, but does not contain a General field, the file is deleted and replaced with a new table of that name containing a single record with a single General field that contains the Graph object. Each call to (_GENGRAPH) with the same file name in parm8 adds a new record to the table and places the generated graph in the General field. If you are using Visual FoxPro 6.0, the .dbf name must have a .dbf file extension because by default the data is saved to a .scx file. Parm7 - use autoformat The value of this parameter influences how the numbers passed to parm2 and parm3 are interpreted. Parm2 - chart type and parm3 - chart subtype If parm7 is true (.T.), parm2 will be 1-15 corresponding to the options in the Gallery list that is displayed when you click AutoFormat on the Format menu in MSGraph. Parm3 will be the number of the selected format displayed for the specific Gallery selected. If parm7 is false (.F.), parm2 will be 1-14 corresponding to the chart types that are displayed when you click Chart Type on the Format menu in MSGraph. The first 1-8 are the 2-D charts (counted from left to right and top to bottom), 9-14 are the 3-D chart types. Parm3 will be one of the Subtypes that are displayed when you click the Options button in the Chart Type window. Valid numbers depend on which Chart Type is specified. Parm4 - title This is the title that will appear on the chart. If left empty or omitted, the chart will have no title. This is the same as setting the ChartTitle property of the chart. Parm5 - series by row /column This is the equivalent to clicking either Series in Rows or Series in Columns on the Data menu in MSGraph. True (.T.) indicates Series in Rows, and false (.F.) indicates Series in Columns. These settings are explained in the Microsoft Graph Help file. Parm6 - has legend If this is true (.T.), the chart displays a legend. This is the same as setting the HasLegend property of the chart. Parm9 - don't display graph with MODIFY GENERAL If this is false (.F.) the General field is displayed in a window as though the MODIFY GENERAL command had been issued. Additional query words: ====================================================================== Keywords : kbvfp300 kbvfp300b kbvfp500 Technology : kbHWMAC kbOSMAC kbVFPsearch kbAudDeveloper kbVFP300bMac kbVFP300 kbVFP300b kbVFP500 kbVFP600 kbVFP500a Version : MACINTOSH:3.0b; WINDOWS:3.0,3.0b,5.0,5.0a,6.0 Issue type : kbhowto ============================================================================= THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY. Copyright Microsoft Corporation 1999.