mschart

Please let me about MS-Chart control, how to define its coordinates using recordset, etc. How do i print ms-chart throug code?

Use Microsoft Chart Control.

Private Sub Command1_Click()

Chart1.ColumnCount = 1
Chart1.RowCount = 3
Chart1.Column = 1


Chart1.Row = 1: Chart1.Data = 1
Chart1.RowLabel = "January" 'label for bar 1(row)
Chart1.Row = 2: Chart1.Data = 2
Chart1.RowLabel = "February"
Chart1.Row = 3: Chart1.Data = 3
Chart1.RowLabel = "March"

end sub

Here instead of 1,2,3 put your recordset values: rs!Field1....etc

Iouri Boutchkine
[email protected]