+ Reply to Thread
Results 1 to 8 of 8

Showing datapoints on chart

  1. #1
    Registered User
    Join Date
    01-28-2011
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    8

    Showing datapoints on chart

    Hi from a newbie.

    I've produced a chart programmatically containing an array of loads. I've discovered MATCH and INDEX to give the point at which the data exceeds a certain value. Now I want to plot and label this point on the curve of the overall data. How?

    Thanks - Steve
    Last edited by LonesomeTwin; 01-31-2011 at 05:42 AM.

  2. #2
    Valued Forum Contributor Blake 7's Avatar
    Join Date
    10-01-2010
    Location
    Bogota, Colombia
    MS-Off Ver
    Excel 2010 64 bit and Excel 2007,
    Posts
    1,377

    Re: Showing datapoints on chart

    if i have understood

    click on graph > Select Layout tab > data labels done.
    Blake 7

    If your question has been answered, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.

    If any member's response has helped to solve your problem, please consider using the scales icon on the top right of their post to show your appreciation.

    http://failblog.org/

  3. #3
    Registered User
    Join Date
    01-28-2011
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: Showing datapoints on chart

    That adds billions of labels to the chart, trouble is I only want one, well actually two. Is posting Excel files permitted here?

  4. #4
    Valued Forum Contributor Blake 7's Avatar
    Join Date
    10-01-2010
    Location
    Bogota, Colombia
    MS-Off Ver
    Excel 2010 64 bit and Excel 2007,
    Posts
    1,377

    Re: Showing datapoints on chart

    Hiya - yes you can post a file. There are some real chart experts here who im sure will be able to help you.

    Go to advanced - manage attachments

  5. #5
    Registered User
    Join Date
    01-28-2011
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: Showing datapoints on chart

    This is the sample data I'm playing with, the pic is the control program I'm trying to replicate. Thanks for all the good works, I may be here quite often for a while!
    Attached Images Attached Images
    Attached Files Attached Files

  6. #6
    Valued Forum Contributor Blake 7's Avatar
    Join Date
    10-01-2010
    Location
    Bogota, Colombia
    MS-Off Ver
    Excel 2010 64 bit and Excel 2007,
    Posts
    1,377

    Re: Showing datapoints on chart

    Wow - quite a data set.

    Try this web address to see if this helps.

    Andy is also a member here

    http://www.andypope.info/

  7. #7
    Registered User
    Join Date
    01-28-2011
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: Showing datapoints on chart

    Thanks Mr Blake

    Turns out the answer is to include the points I want on the graph as individual data sets. All done now (well nearly).

  8. #8
    Valued Forum Contributor Blake 7's Avatar
    Join Date
    10-01-2010
    Location
    Bogota, Colombia
    MS-Off Ver
    Excel 2010 64 bit and Excel 2007,
    Posts
    1,377

    Re: Showing datapoints on chart

    great - glad your sorted - did u find what you wanted on that website?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1