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.

Series Collection Question
 

What ChartType(s) is/are applied to your series. Can return very little from
series in a 3DSurfaceArea type, also (rarely) can be problematic from 2nd &
subsequent series of certain chart types.

Regards,
Peter T

"Ken" wrote in message
...
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.

Series Collection Question
 

It is a 2-D Scatter plot, with 2 other single points on it.



"Peter T" wrote:

What ChartType(s) is/are applied to your series. Can return very little from
series in a 3DSurfaceArea type, also (rarely) can be problematic from 2nd &
subsequent series of certain chart types.

Regards,
Peter T

"Ken" wrote in message
...
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.

Series Collection Question
 

Are any of the series backed up by unplottable data (no numeric values to
plot in the data ranges so no points are plotted)? If so, marker-based
series (line and XY chart series) cause errors when you try to use VBA to
read some of their properties.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Ken" wrote in message
...
It is a 2-D Scatter plot, with 2 other single points on it.



"Peter T" wrote:

What ChartType(s) is/are applied to your series. Can return very little
from
series in a 3DSurfaceArea type, also (rarely) can be problematic from 2nd
&
subsequent series of certain chart types.

Regards,
Peter T

"Ken" wrote in message
...
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.

Series Collection Question
 

I am plotting a single point that has data in it. The odd part is that this
function used to work and I have not had any problems before.

"Jon Peltier" wrote:

Are any of the series backed up by unplottable data (no numeric values to
plot in the data ranges so no points are plotted)? If so, marker-based
series (line and XY chart series) cause errors when you try to use VBA to
read some of their properties.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Ken" wrote in message
...
It is a 2-D Scatter plot, with 2 other single points on it.



"Peter T" wrote:

What ChartType(s) is/are applied to your series. Can return very little
from
series in a 3DSurfaceArea type, also (rarely) can be problematic from 2nd
&
subsequent series of certain chart types.

Regards,
Peter T

"Ken" wrote in message
...
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.

Series Collection Question
 

I don't think I know enough about your particular error. Does the point
appear in the chart?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Ken" wrote in message
...
I am plotting a single point that has data in it. The odd part is that
this
function used to work and I have not had any problems before.

"Jon Peltier" wrote:

Are any of the series backed up by unplottable data (no numeric values to
plot in the data ranges so no points are plotted)? If so, marker-based
series (line and XY chart series) cause errors when you try to use VBA to
read some of their properties.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Ken" wrote in message
...
It is a 2-D Scatter plot, with 2 other single points on it.



"Peter T" wrote:

What ChartType(s) is/are applied to your series. Can return very
little
from
series in a 3DSurfaceArea type, also (rarely) can be problematic from
2nd
&
subsequent series of certain chart types.

Regards,
Peter T

"Ken" wrote in message
...
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.

Series Collection Question
 

Hi Jon,

The point is does show up on the chart and has a formula in it.

Ken

Series Collection Question
 

Ken -

I'm intrigued. If you email me the file I'll take a look.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Ken" wrote in message
...
Hi Jon,

The point is does show up on the chart and has a formula in it.

Ken