[RESOLVED] [2005] Determine variables in Excel Chart

[campster]

After thinking about what is avaiable to a chart, I've realized the the variables do not exist directly. I need to access the range of the series then I can go to the worksheet that contains the series data and extract the variable names.

This brings me back to the seriecollection method of the chart object. Does anyone know how to use this to get the range of the Y axis values?

[campster]

I think that I'm getting close. I can get the number of variables per chart using the code below but when I try to run I get an exception when I cast the seriesCollection.item to a string.

Public Function GetCharts() As TreeNode
        Dim parentNode As TreeNode = Nothing
 
        Try
 
            For Each oCht As Excel.Chart In oExcel.Workbooks(1).Charts
                Dim var As String
 
                parentNode = New TreeNode(oCht.Name)
 
                Dim cnt As Integer = CType(oCht.SeriesCollection, Excel.SeriesCollection).Count
                For i As Integer = 1 To cnt
                    var = CStr(CType(oCht.SeriesCollection, Excel.SeriesCollection).Item(i))
                    parentNode.Nodes.Add(var)
                Next
            Next
 
        Catch ex As Exception
            MessageBox.Show("GetCharts.GetVariables: " & ex.Message.ToString)
        End Try
 
        Return parentNode
 
    End Function

[campster]

bump

I'm finally at a point that this is holding up progress. Any Excel/.Net experts out there that want to give this a go?