Chartspace usage




I am trying to plot using OWC11 chartspace. I have added the
chartspace to the windows form.(I am using VB .NET , visual studio
2005 and developing a windows application.).

I have the the data in a spreadsheet component.

I made a plot with x axis A1:A10 and Y axis B1:B10 . For this I
used :

chartspace1.datasource = excelspace.getocx
dim chart 1 as OWC11.chchart
chart1 = chartspace1.Charts.Add

chart1.Type = ChartChartTypeEnum.chChartTypeSmoothLineMarkers

Dim ser1 As OWC11.ChSeries
ser1 = chart1.SeriesCollection.Add

ser1.SetData(ChartDimensionsEnum.chDimCategories, 0, "A1:A10")
ser1.SetData(ChartDimensionsEnum.chDimValues, 0, "B1:B10")

NOW, I want to add a series to the chartspace where the x axis is
the cells A2 , A4 , A7 and A12 while the Y axis is the values B2 ,
B4, B7 and B12.

Can anyone help me in doing this? How to select those cells? and give
it to x-axis?




Alvin Bruney [MVP]

Google this newsgroup, there are a lot of examples posted in here over there
years to do this and other things.

Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The O.W.C. Black Book, 2nd Edition
Exclusively on $19.99

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question