Using the Microsoft Office Chart control

[Scott H]

Hello,
I'm trying it use the Microsoft Office Chart control 11.0 in VB.net
(for a windows forms project) and can't seem to get it to work, I've
been playing around with various snippets of code. below is what I've
got at the moment, I'm trying to feed in literal numbers.

I placed a chart control on the form and called it ChartSpace1 and
adjusted a couple of settings to get it roughly as I want it, then ran
this code:

Dim chConstants
Dim chtNewChart

chConstants = ChartSpace1.Constants
chtNewChart = ChartSpace1.Charts.Item(0)
chtNewChart.SetData(OWC11.ChartDimensionsEnum.chDi mCategories,
0, "Test")
It fails on the last line, with an "unspecified error"
I'm not looking to do anything complicated, just a simple bar graph,
and no, I do not want to pay $400 for a third-party control :-)

Thanks for any help offered.

Scott