![]() |
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 |
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 |
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