+ Reply to Thread
Results 1 to 2 of 2

Display Data Labels for only the First and Last Data Points

  1. #1
    Registered User
    Join Date
    05-20-2010
    Location
    Washington DC
    MS-Off Ver
    Excel 2003
    Posts
    20

    Display Data Labels for only the First and Last Data Points

    My graph looks like this:

    \1

    Basically, I want to get rid of the center labels for the red and blue lines (series). This is a dynamic graph and the value will vary by user input. Thus, I can't simply delete these labels and fix the problem. I need to set-up excel so that only the first and last values of the two series have labels. The end result would look like:

    \1

    Is this possible? A VBA solution would be great. Thank you.

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Display Data Labels for only the First and Last Data Points

    I am curious about the layout of the source data, and what aspects are dynamic. There might be a very simple non-VBA solution for this, depending on what "dynamic" means in this case.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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