Last post Jun 25, 2007 06:58 AM by CLIPER
Jun 21, 2007 08:46 AM|paxa|LINK
hi, this is my first post in here.
and...i don't know if it's the right section for it.
i using VS 2003 and vb.net as the language for developing an solution that involves saving some data to an excell worksheet and some charts.
my problem is that in the chart i can't change the values of the series in order to fill the chart
oChart = oExcell.Worksheets("Graficos").ChartObjects("Gráfico 1025")
'# series declaration
Dim ser As Excel.Series = CType(oChart.Chart.SeriesCollection(1), Excel.Series) '# primeira series collection
Dim ser2 As Excel.Series = CType(oChart.Chart.SeriesCollection(2), Excel.Series)
'#change series values
ser.XValues(1) = "=Dados!R3C1:R" & maxapos & "C1"
ser.Values(1) = "=Dados!R3C2:R" & maxapos & "C2"
ser2.Values(1) = "=Dados!R3C19:R" & maxapos & "C19"
help would be appreciated
thanks in advance
Jun 22, 2007 04:17 AM|paxa|LINK
can anyone give some pointers please???
this is driving me a little insane....
Jun 25, 2007 06:37 AM|paxa|LINK
it's really annoying, i can't get this to work, can anyone please give me some pointers, i've searched and so far i couldn't get any answers for this
Jun 25, 2007 06:58 AM|CLIPER|LINK
so what would be the returned error?