OWC11 (connect Spreadsheet + Chart)

[Pieter]

Hi

In my application I've got an AxSpreadsheet with data.
I want to draw a chart from the data in the spreadsheet.

I am having trouble "connecting" the spreadsheet to the chart.
I found quite a few examples on the net on doing this but all of these
examples says:
ChartSpace1.DataSource = Spreadsheet1

This results in a "Option stric on disallows implicit conversion....."
(I don't want to turn strict off)

When I typecast to
ChartSpace1.DataSource = CType(Spreadsheet1, msdatasrc.DataSource)

and run the code, it results in "Specified cast is not valid"

Any ideas? ( I am using VB.NET)

Thanks in advance