LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ken Ken is offline
external usenet poster
 
Posts: 590
Default Series Collection Question

I keep getting an error with the following code:

Dim mySrs As Series

For Each mySrs In oChartObj.Chart.SeriesCollection
Debug.Print mySrs.PlotOrder, mySrs.Name, mySrs.Formula
If (mySrs.Name = SeriesStr) Then
Debug.Print "Found "; SeriesStr
End If
Next

I get a "Unable to get the PlotOrder property of the Series Class"

I am trying to update the series range values. I have other functions that
work correctly on other charts. I checked the chart to very the name of the
object is in the chart.

Any help would be great...

I really would like to be able to generate the charts on the fly but there
is so much formatting that it makes it impractical.

Thanks.
 
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
iterate through chart series collection Robert H Excel Programming 8 February 25th 07 03:30 PM
Returning a series collection end Point value Dan Thompson Excel Programming 2 February 23rd 07 10:06 PM
Series Collection Name Problem madeleine[_2_] Excel Programming 2 November 28th 06 03:07 PM
How to store the lengthy value in Series collection? ramkumar_cpt Charts and Charting in Excel 1 December 16th 05 01:16 PM
Series Collection Points Bill[_28_] Excel Programming 12 September 29th 04 04:21 PM


All times are GMT +1. The time now is 03:19 PM.

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"