Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 53
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007 Chart - determining the color of a chart style Shane Devenshire[_2_] Charts and Charting in Excel 1 February 6th 10 04:09 AM
Excel 2003 is missing Built-In Custom Chart Types in Chart Wizard Julius Charts and Charting in Excel 2 March 6th 09 04:43 PM
Excel 2003 is missing Built-In Custom Chart Types in Chart Wizard Julius Setting up and Configuration of Excel 1 March 6th 09 01:57 AM
Creating a chart(? pie chart) that shows customers,dates and machi Mark M Charts and Charting in Excel 1 August 20th 08 10:19 PM
Huge differences in chart values screws my bar chart scale up. Sirritys Charts and Charting in Excel 2 June 13th 06 10:33 AM


All times are GMT +1. The time now is 09:44 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"