Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.

Dismiss

Plot with Chartspace

0 views

Skip to first unread message

unread,

Jan 7, 2008, 11:59:56 AM1/7/08

Hi,

I am using VB .NET , visual studio 2005 and developing a windows
application.

I am trying to plot using OWC11 chartspace. I have added the
chartspace to the windows form
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?

Thanks.

0 new messages