I am trying to construct a simple bar chart.

I noticed a post on this forum that said, to get the chart function working:

-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