+ Reply to Thread
Results 1 to 3 of 3

Display Data Label for first & last data points

  1. #1
    Forum Contributor
    Join Date
    09-09-2008
    Location
    Middlesbrough, England
    MS-Off Ver
    2007
    Posts
    174

    Display Data Label for first & last data points

    Hello,

    I've created a graph that updates based on the year selected & would like to display the data label for first & last data points.

    The issue i have is the last data point moves depending on the year selected.

    Eg. This year ends at Oct atm (Dont have Nov / Dec data).

    Any advice on a workaround?

    Cheers

    Chris
    Attached Files Attached Files

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,634

    Re: Display Data Label for first & last data points

    Hi Chris,

    As you have Excel 2007, I'd got that way:

    - remove labels
    - add 2 dummy data series for labels only
    data for this series could be constructed this way:
    B4 and copy to B5:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    (at the beginning copy this also to I4:M5)

    C4 and copy to C5, as well as to right D4:H5 (at the very end copy further right, also to I4:M5, but not now):
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    now add these 2 new series to your graph, format as labels (see points 1-5) in attachment and middle steps graph in right part of worksheet

    And final touch (not shown in attachment, because earlier steps fwould not be visible): copy formula from C4 to I4:M5 (and of course remove comments + extra graphs )
    Attached Files Attached Files
    Best Regards,

    Kaper

  3. #3
    Valued Forum Contributor
    Join Date
    09-25-2015
    Location
    Nowy Tomysl, Poland
    MS-Off Ver
    2019, O365
    Posts
    398

    Re: Display Data Label for first & last data points

    My suggestion using a pivot table. However, data is in another layout in the "Data" sheet. When you add more data, simply refresh the pivot table (Data Sheet - Refresh).
    From the PivotTable Filter, select the Year you want to show on the graphs.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Get a label used in Userform to display only two decimal points
    By darbar76528 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-25-2017, 06:56 PM
  2. Add data label when hovering mouse over data points on a XY scatter plot.
    By mingxia in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-30-2016, 01:53 PM
  3. Replies: 4
    Last Post: 01-26-2016, 05:08 AM
  4. Loop through data points and change color based on label
    By rodrignj in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-22-2013, 09:38 AM
  5. Replies: 1
    Last Post: 03-03-2011, 06:11 PM
  6. Display category name and Y value in data label
    By jeffreybrown in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 12-03-2009, 06:44 PM
  7. Date label for data points.
    By Jim15 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 11-22-2008, 07:41 AM

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