I am currently using OWC9 in my VB.Net app to graph data, but it seems very
clunky.

I create a chart space and a spreadsheet object.
Then populate the spreadsheet object with data (using CSVData as can't
access cells after row 712)
Then set series to appropriate cells.

It works but has limits. I can't plot 2 types of series (scatter line & bar)
on the same chart.

I can't have 2 y-axis with 1 series using 1 and a second using 2. Creating
the axis is OK.

Is this the best way to use Excel charts in VB.Net or is there some other way!

The apps data is being updated every 15s so graph is changing. The data is
coming from multiple databases.
--
Thanks

Dave R