I am trying to construct a simple bar chart.
I noticed a post on this forum that said, to get the chart function working:
Quote:
-Open an ADO Recordset (myRS) which includes all info that needs displayed
-Set MSChart1.Datasource = myRS
However, this did not say if I needed to what references I need to add, (using the menu item References)
or what to Dim the MSChart1 as...
I have tried Dim MSChart1 as Chart and also Dim MSChart1 As Graph
but neither have worked.
Can anyone please help?
Thanks
