1
11Oppidan
Hi,
I am writing a VB .NET addin for excel (2000) which pulls data from MS SQLS
using ADO.Net and passes data the data into Excel as a range. The program
needs to be able to generate charts with multiple series from these various
ranges queried from SQL. I am able to create a XY Scatter plot fine on the
first pass but am unable to find a way to correctly reference the x and y
columns on any additional series. I seem to need to be able to set the
series x and y values separately but are unable to find a way which
works?!?
I would be most grateful if someone could help me understand how to achieve
this. Any code examples of this kind of thing would be much appreciated.
Many thanks
I am writing a VB .NET addin for excel (2000) which pulls data from MS SQLS
using ADO.Net and passes data the data into Excel as a range. The program
needs to be able to generate charts with multiple series from these various
ranges queried from SQL. I am able to create a XY Scatter plot fine on the
first pass but am unable to find a way to correctly reference the x and y
columns on any additional series. I seem to need to be able to set the
series x and y values separately but are unable to find a way which
works?!?
I would be most grateful if someone could help me understand how to achieve
this. Any code examples of this kind of thing would be much appreciated.
Many thanks