LabWindows/CVI

cancel
Showing results for 
Search instead for 
Did you mean: 

I can't add a new serie in an excel chart using seriescollection

I managed in creating a common graph with Excel_ChartChartWizard but I want to create a special one. It's simple using Visual Basic :
Charts.Add
ActiveChart.ChartType = xlColumnStacked
ActiveChart.SeriesCollection.NewSeries
ActiveChart.SeriesCollection.NewSeries
ActiveChart.SeriesCollection.NewSeries
ActiveChart.SeriesCollection(1).XValues = "={""current"",""pass""}"
ActiveChart.SeriesCollection(1).Values = "={1,2}"
ActiveChart.SeriesCollection(1).Name = "=""FAIL"""
ActiveChart.SeriesCollection(2).XValues = "={""current"",""pass""}"
ActiveChart.SeriesCollection(2).Values = "={0,3}"
ActiveChart.SeriesCollection(2).Name = "=""FIRST PASS"""
ActiveC
hart.SeriesCollection(3).XValues = "={""current"",""pass""}"
ActiveChart.SeriesCollection(3).Values = "={3,2}"
ActiveChart.SeriesCollection(3).Name = "=""SND PASS"""
ActiveChart.Location Where:=xlLocationAsObject, Name:="weekly report"
With ActiveChart
.HasTitle = False
.Axes(xlCategory, xlPrimary).HasTitle = False
.Axes(xlValue, xlPrimary).HasTitle = False
End With

But when I'm using Excel_ChartSeriesCollectionNewSeries after adding a chart in CVI, it returns an unknown error.
0 Kudos
Message 1 of 2
(3,257 Views)
Homer,

Thanks for using National Instruments Developer Zone. Your question would be better handled by our email or phone support teams. The web site www.ni.com/ask has all the information you will need to reach our top quality support experts.

Thanks!
Message 2 of 2
(3,257 Views)