+ Reply to Thread
Results 1 to 4 of 4

Want to add data labels to a simple line graph

  1. #1
    Registered User
    Join Date
    06-02-2017
    Location
    NEWQUAY
    MS-Off Ver
    10
    Posts
    2

    Want to add data labels to a simple line graph

    Hey, i have been trying to add some simple data labels to a basic line graph, here is the graph i have and the data i want to use - basically the vertical axis will to the tally, the horizontal will be the date. i would also like to add labels to every date/tally point that displays the #hands (the data in the C column of the table):

    here is what the graph i have made so far looks like:
    Capture11.PNG


    I would like to add hands as a data label to every point that has been plotted on the graph - i want it to look like this (i made this on photoshop to show what i want the graph to look like):
    labels.PNG
    I have tried but can't seem to get labels that are not in the X, Y axis data, which seems crazy bc this seems like one of the most simple ways to display data on a graph. Maybe i am being very stupid if i am then please accept my apology in advance
    Attached Images Attached Images

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,064

    Re: Want to add data labels to a simple line graph

    You have attached an image. That's not very easy to work with. We have to re-type your information before we can begin to address your problem. That will put a lot of people off completely. Not only that, but (depending on their choice of browser) many members cannot even see the image.

    Will you please attach a SMALL sample Excel workbook (10-20 rows of data is usually enough)? Please don't attach a picture of one (no-one will want to re-type all your stuff before starting).

    1. Make sure that your sample data are truly REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

    2. Make sure that your desired solution is also shown (mock up the results manually).

    3. Make sure that all confidential information is removed first!!

    4. Try to avoid using merged cells. They cause lots of problems!

    Unfortunately the attachment icon doesn't work at the moment. So, to attach an Excel file you have to do the following: Just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: Lá fhéile Pádraig sona dhaoibh

  3. #3
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,829

    Re: Want to add data labels to a simple line graph

    IMO, the easiest way, by far, to do what you want in 2010 and earlier is to use Rob Bovey's free XY chart labeler add-in ( appspro.com ).
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  4. #4
    Registered User
    Join Date
    06-02-2017
    Location
    NEWQUAY
    MS-Off Ver
    10
    Posts
    2

    Re: Want to add data labels to a simple line graph

    Quote Originally Posted by MrShorty View Post
    IMO, the easiest way, by far, to do what you want in 2010 and earlier is to use Rob Bovey's free XY chart labeler add-in ( appspro.com ).
    thanks so much for the short, concise and helpful answer MrShorty

+ 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. Really simple line graph but can't do it.
    By DrPips in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-15-2014, 08:31 AM
  2. Replies: 2
    Last Post: 04-05-2014, 06:46 PM
  3. Need Some Simple Line Graph Help
    By richter394 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-07-2013, 06:27 AM
  4. Multiple Data labels in line graph
    By NadeemMd in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-18-2012, 11:15 AM
  5. Simple Line Graph
    By Muncey in forum Excel General
    Replies: 2
    Last Post: 01-11-2012, 12:47 PM
  6. Help with Simple Line Graph?
    By jodders in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-10-2008, 07:30 AM
  7. constructing a simple line graph
    By aragorn in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-27-2007, 12:27 PM

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