MSChart from DataGrid or Access

[Piglet]

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

[Lennie]

Hi Yummy Piglet,

Before I share my information with you I need to know what data you want to display on the MSCHART.


Cheers,
Lennie

[Piglet]

Hey Lennie

Thanks for responding! I have a table with two columns, 'date&time' and 'averagevalue'. I would like the 'date&time' column as the X axis along the bottom and the 'averagevalue' (integer values) as the y axis. Let me know if you need more info..

Thank you!
Amy

[Piglet]

Anyone got any ideas?