+ Reply to Thread
Results 1 to 10 of 10

Displaying actual values on a percentage bar graph

  1. #1
    Registered User
    Join Date
    10-04-2010
    Location
    Blacksburg, Virginia
    MS-Off Ver
    Excel 2003
    Posts
    34

    Question Displaying actual values on a percentage bar graph

    I have created a bar graph with percentages on the Y axis. I would like to display the actual values (that this percentage was calculated from) next to each individual bar, how to do this?

    Many thanks,
    Brandon

  2. #2
    Registered User
    Join Date
    10-04-2010
    Location
    Blacksburg, Virginia
    MS-Off Ver
    Excel 2003
    Posts
    34

    Re: Displaying actual values on a percentage bar graph

    and by the way I'm actually using Excel 2007

  3. #3
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,582

    Re: Displaying actual values on a percentage bar graph

    Can you upload a dummy spreadsheet showing how your data is laid out?
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  4. #4
    Registered User
    Join Date
    10-04-2010
    Location
    Blacksburg, Virginia
    MS-Off Ver
    Excel 2003
    Posts
    34

    Re: Displaying actual values on a percentage bar graph

    Quote Originally Posted by ChemistB View Post
    Can you upload a dummy spreadsheet showing how your data is laid out?
    How can I attach a excel doc? Basically what it is is two table. one that Counts projects that happen +/- 0-10% estimate from bid, +/- 10-20% estimate from bid, >+/-20% estimate from bid, in various regions. The next table, which im getting my data from to graph it, shows the percentages of those counts for each +/- 0-10% estimate from bid, +/- 10-20% estimate from bid, >+/-20% estimate from bid. So for example I might have 40% of projects +/- 0-10% estimate from bid, and my graph shows that since the y-axis is labelled percentages, but i want to able to be label each individual bar with the specific number of projects that that 40% encompasses.

  5. #5
    Registered User
    Join Date
    10-04-2010
    Location
    Blacksburg, Virginia
    MS-Off Ver
    Excel 2003
    Posts
    34

    Re: Displaying actual values on a percentage bar graph

    I hope that helps to explain the situation...

  6. #6
    Registered User
    Join Date
    10-04-2010
    Location
    Blacksburg, Virginia
    MS-Off Ver
    Excel 2003
    Posts
    34

    Re: Displaying actual values on a percentage bar graph

    Anyone? - its important

  7. #7
    Registered User
    Join Date
    10-04-2010
    Location
    Blacksburg, Virginia
    MS-Off Ver
    Excel 2003
    Posts
    34

    Re: Displaying actual values on a percentage bar graph

    Nvm , I figured it out...excel doesn't make it easy though, this is something that needs to be fixed

  8. #8
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,430

    Re: Displaying actual values on a percentage bar graph

    Use this addin to link data labels to cells.
    http://www.appspro.com/Utilities/ChartLabeler.htm
    Cheers
    Andy
    www.andypope.info

  9. #9
    Registered User
    Join Date
    10-04-2010
    Location
    Blacksburg, Virginia
    MS-Off Ver
    Excel 2003
    Posts
    34

    Re: Displaying actual values on a percentage bar graph

    did you not understand the question? - I'm not labelling based on the range of data that i'm pulling from. The range I'm pulling from is pulling from another data that has Counts that i need to be used as labels, which are vital in expressing the meaningfulness of the percents (but I need the y-axis to be in percents from the the range that the graph is pulling from).....but like I said, I figured it out. You just have to go a round about way of doing it because excel hasn't addressed it directly.

  10. #10
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,430

    Re: Displaying actual values on a percentage bar graph

    perhaps you did understand the implictation of the addin.
    It allows you to display any information in the data label, not just the series or category name or the value.

    but hey if you solved your problem then great!

+ 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