I have a datagrid on my form which displays a data table from a DataSet (extracted from an Access DB) when the user selects an option from a combo box on the form. I would like this same data to be displayed in an MSChart on the same page but I dont know how to link the chart to the DataSet.
To populate the datagrid i have used the following code:
DataGridView1.DataSource = K0201227ProjectDataSet.tblCardiff
I tried various things to populate the MSChart with this same data but no luck. I guess I have to specify what data from the DataSet I want to display in the Chart but I dont know how to do this at run time(??)