Announcement

Collapse
No announcement yet.

Get Value Of A Chart Data Point With Vba

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Get Value Of A Chart Data Point With Vba

    Hi,
    I need to get the value of a chart data point using VBA. I tried the ActiveChart.SeriesCollection(x).Points(x).properties but cannot return any information.

    Alternatively returning the source range of the chart will be enough as I could get the data straight from the spreadsheet, but I cannot find a way of returning/getting the source range of a chart.

    Please help I cannot find a similar problem with a solution so far.

    Thanks
    Ray

  • #2
    Re: Get Value Of A Chart Data Point With Vba

    See this recent post
    http://www.ozgrid.com/forum/showthread.php?t=71828

    Cheers
    Andy

    Comment


    • #3
      Re: Get Value Of A Chart Data Point With Vba

      OK Thanks that's pretty much it, how did I miss it in the search?
      Thanks.

      Comment


      • #4
        Re: Get Value Of A Chart Data Point With Vba

        Yup thanks Andy this was a complete solution for me. Everythings working fine:

        Code:
        x=activechart.SeriesCollection(1).values 
        For i=LBound(x) To UBound(x) 
            Debug.Print "Point ";i;"=";x(i) 
        Next i
        Ray

        Comment

        Working...
        X