ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   chart (https://www.excelbanter.com/excel-programming/322915-chart.html)

ojv[_2_]

chart
 
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

K Dales[_2_]

chart
 
What kind of chart are you plotting, and how many series are added when it
crashes?

"ojv" wrote:

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


ojv[_2_]

chart
 
XY scatter plot. It appears around 10 series.

ojv

"K Dales" wrote:

What kind of chart are you plotting, and how many series are added when it
crashes?

"ojv" wrote:

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



All times are GMT +1. The time now is 04:30 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com