+ Reply to Thread
Results 1 to 2 of 2

How to manuall attach numerical values to bar graphs?

  1. #1
    Registered User
    Join Date
    03-11-2012
    Location
    home
    MS-Off Ver
    Excel 2010
    Posts
    6

    Exclamation How to manuall attach numerical values to bar graphs?

    Look at this image: http://img854.imageshack.us/img854/1755/barsr.jpg

    I am trying to figure out how to manually attach the exact numerical values for each bar to the graph. Excel does have the option for this through the chart layouts, however they do not have a layout that has the numerical values as well as other features I want. So I am stuck with a layout that either does not have the numerical values, or it does not have some other type of option I want. How can I add the numerical values manually? Is there a way I can create my own chart layout template by choosing from every available option from the sum of all the preselected chart layout templates?

  2. #2
    Forum Contributor
    Join Date
    08-06-2009
    Location
    Belfast
    MS-Off Ver
    Excel 2003
    Posts
    107

    Re: How to manuall attach numerical values to bar graphs?

    Hi

    You can right click on one of the bars.

    If you click on Add Data Labels this will give the actual amounts per bar.

    You may need to do it to them all depending on how the graph was contrusted.

    Hope this helps.

    L

+ 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