Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 4 of 4

Thread: Get Value Of A Chart Data Point With Vba

  1. #1
    Join Date
    27th June 2007
    Posts
    3

    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

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    7th March 2003
    Location
    Essex, England
    Posts
    11,314

    Re: Get Value Of A Chart Data Point With Vba

    Cheers
    Andy


  3. #3
    Join Date
    27th June 2007
    Posts
    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.

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    27th June 2007
    Posts
    3

    Re: Get Value Of A Chart Data Point With Vba

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

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

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. Label data point in Scatter chart
    By tqv1969 in forum EXCEL HELP
    Replies: 6
    Last Post: October 28th, 2010, 17:03
  2. Centered Data Point In Line & Bar Chart
    By deesy in forum EXCEL HELP
    Replies: 4
    Last Post: December 15th, 2006, 06:36
  3. Replies: 4
    Last Post: September 9th, 2006, 10:50
  4. pick data point from chart
    By stu2005 in forum EXCEL HELP
    Replies: 7
    Last Post: April 12th, 2006, 09:39
  5. Chart Data Point Colours [SOLVED]
    By Neal in forum EXCEL HELP
    Replies: 2
    Last Post: March 30th, 2003, 20:13

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
porno