Chart - Problem getting value from SeriesCollection

[JohnM3]

Hi

There is no code attached ....

The following simplifies the problem (I think)

=================
START
=================
Note:
StackedBar - byRows

------------------------------------------
On Excel Worksheet
------------------------------------------
Fruit Color Sweet Hardness
Apple .05 .06 .02
Orange .08 .07 .06
Pear .07 .08 .09

GraphRange = the entire matrix above

=================
Part of Code
=================

For i = 2 to GraphRangeRowCnt

   Set FruitRange = Union(WS_Control.Range(GraphRange.Rows(1).Address), _
                                      WS_Control.Range(GraphRange.Rows(i).Address))

   'Code 
    .
   'Later Code 

            '--------------------
            '   Series Collection - returns array containg data values
            '--------------------
            With mo_Chart
                'vSeries is a Variant Variable
                vSeries = .SeriesCollection(1).Values
            End With

   'Later Code  (Problem)
            '--------------------
            '   Axis - xlLabel
            '--------------------
            With mo_Chart
                Set oAxisValue = .Axes(xlValue, xlPrimary)
                With oAxisValue
                    With .AxisTitle.Characters
                        .Font.FontStyle = "Regular"
                        .Font.Name = FN2
                        .Font.Size = 9
                        .Font.Bold = False
                        .Font.Color = 1
                        .Font.ColorIndex = 1
                        .Text = <--------------------- FRUIT NAME E.G. APPLE (from SeriesCollection ???)
                    End With

              End With
Next

=================
END
=================

I realize this
vSeries = .SeriesCollection(1).Values
returns array containing the data values

My question is:

What SeriesCollection PROPERTY returns APPLE ?

vSeries = .SeriesCollection(1).WHAT_PROPERTY

Note:
I realize I can get the value from the underlying RANGE but I think
it more "correct" to get the value from the SERIES.

regards
JohnM3

[teylyn]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

[JohnM3]

The answer was to use the .SeriesCollection(1).Name - Name Property.

 '--------------------
 '   Series
 '--------------------
 With mo_Chart
      SeriesName = .SeriesCollection(1).Name
      SeriesXValues = .SeriesCollection(1).XValues
      SeriesValues = .SeriesCollection(1).Values
 End With

'--------------------
' Axis - xlLabel
'--------------------
With mo_Chart

Set oAxisValue = .Axes(xlValue, xlPrimary)

With oAxisValue

     With .AxisTitle.Characters
        .Font.FontStyle = "Regular"
        .Font.Name = FN2
        .Font.Size = 9
        .Font.Bold = False
        .Font.Color = 1
        .Font.ColorIndex = 1
        .Text = <--------------------- FRUIT NAME E.G. APPLE (from SeriesCollection ???)
        .Text = SeriesName
       End With

End With

regards
JohnM3