Question MSChart from DataGrid / Access

[Tinkerbell]

Hello

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(??)

Please help!

Thank you
Amy

 

[Tinkerbell]

Can anybody help with this?

I need to either extract it from the datagrid or directly from Access tables or from a DataTable/Dataset. Whatever is possible! Would really appreciate any help.

Thanks
Amy