chart

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Plotting a number of series using code below:

For jjj = LBound(XY, 2) To UBound(XY, 2)
Set srsNew = chtChart.SeriesCollection.NewSeries
With srsNew
.name = SeriesName(jjj)
.xValues = XY(0, jjj)
.Values = XY(1, jjj)

After looping through about midway I get an error saying it cant assign
values to .xValues. Arrays in the matrix used for source data is all okay
containing numbers. Any ideas what could be the source of error message?

ojv
 
What kind of chart are you plotting, and how many series are added when it
crashes?
 
You must log in or register to reply here.

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

Similar Threads

Charts Having X Axis Scaled Using Calendar Weeks 4
help with chart script and data labels 7
Help Please !!! 3
Error with Using Macro for XYScatter plots 2
Creating a chart with VBA 1
Chart error: plotting series data XY scatter plot 3
Problem programming .SeriesCollection().XValues and .Values 7
Setting Source Data for Chart Ranges in VB 1

Back
Top