Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How To Create A Line Chart
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01272491
Message ID:
01272512
Views:
12
>I have a table with the following columns:
>
>poller C(50)
>from_date D
>to_date D
>approve N(03)
>
>There are 28 different Poller values.
>
>How do I create an Excel line chart on a VFP form?
>
>Thanks

There are several solutions depending on how you want to display the graph, and whether you want to do anything else with it.

See if the below is what you need:
clear
CLOSE TABLES all
lnmax=50

CREATE CURSOR inputs (poller C(50),from_date D,to_date D,approve N(3))
FOR ia=1 TO lnmax
	INSERT INTO inputs VALUES (PADL(ia,50,"0"),GOMONTH(DATE(),-1*ia),GOMONTH(DATE(),-1*(ia-1)), 10*ia)
ENDFOR

*do wzgraph.app with ;
			"AUTOGRAPH", ;
			pNchart_type, ;
			pNchart_subtype,;
			pCtitle,;
			pLseriesbyrow_column,;
			pLhaslegend,;
			pLuseautoformat,;
			pCoutputdbf,;
			pLdisplaygraph

*ChartType property Specifies the chart type:
*1 = Area
*2 = Bar
*3 = Column
*4 = Line
*.....
			
ERASE hi.sc?
do wzgraph.app with "AUTOGRAPH", 4,1,"Hello",.f.,.f.,.t.,"HI",.f.
do form hi
Previous
Reply
Map
View

Click here to load this message in the networking platform