+ Reply to Thread
Results 1 to 6 of 6

Excel 2007 : Show Exact Value on Graph

  1. #1
    Registered User
    Join Date
    03-01-2009
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    3

    Show Exact Value on Graph

    I'm new to Exel 2007 and I'm having some trouble with the graphs.

    Say I'm making a graphs on Admin Stats and I want the exact number to show on the graph. Instead of the graph being round 90 it would say 89.20. That is written on the graph.

    I hope someone will be able to understand what I'm trying to say.

    I would appreciate any tips or hints!

    Thank you!
    Last edited by cpclare; 03-01-2009 at 08:32 PM. Reason: Title Change

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Graphs Question!

    Welcome to the forum.

    Please take a few minutes to read the Forum Rules about thread titles, and then edit yours to make it descriptive of your problem.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    03-01-2009
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Graphs Question!

    Quote Originally Posted by shg View Post
    Welcome to the forum.

    Please take a few minutes to read the Forum Rules about thread titles, and then edit yours to make it descriptive of your problem.
    Ah! Thanks... Not sure what to call it - but I hope what I've got there is fine. If not, do let me know!

  4. #4
    Forum Contributor mewingkitty's Avatar
    Join Date
    09-29-2008
    Location
    Fort McMurray, Alberta, Canada
    MS-Off Ver
    Excel 2003
    Posts
    949

    re: Show Exact Value on Graph

    I think that'll do.
    A general rule of thumb - Make your thread title something along the lines of what you'd search for if you were to look for an answer on google. IE "Help please" is a common thread title, but won't get you very many answers, since it doesn't appeal to anyone in particular in terms of area of expertise, nor does it help anyone out who is looking for a solution in the future.

    Anyways, back to your problem

    Should be able to "add data labels", an option if you right click on your graph
    Then right click the data labels, and choose "format data labels"
    You can then choose the method in which they're represented. Choose "Number" and go with 2 decimals, or whatever works for you.
    =IF(AND(OR(BLONDE,BRUNETTE,REDHEAD),OR(MY PLACE,HER PLACE),ME),BOW-CHICKA-BOW-WOW,ANOTHER NIGHT ON THE INTERNET)

  5. #5
    Registered User
    Join Date
    03-01-2009
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    3

    re: Show Exact Value on Graph

    Great - I'll have a go and see how it turns out.

    Thanks for your advice - I'll have a go!


  6. #6
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    re: Show Exact Value on Graph

    Much better, cpclare, thank you.

+ 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