Results 1 to 4 of 4
  1. #1
    jamal numan is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jan 2011
    Location
    Ramallah, West Bank
    Posts
    113

    Question How to set the format of the labels on the graph to be “percent”?

    I wanted to represent the “N” values are “percent” on the graph. I went back to the table and chose the format to be “percent”, nevertheless, they are appearing as real numbers in the graph!
    How to set the format of the labels on the graph to be “percet”
    Thank you in advance,

    Regards



    Jamal

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,770
    Format property setting does not change the data. The graphed data is the actual values. Think will have to calculate (x 100) and graph that. Probably want to use Round function also.

    This is why I don't set properties in tables. I want to see real values when I look at my tables.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    jamal numan is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jan 2011
    Location
    Ramallah, West Bank
    Posts
    113

    Thumbs up

    Quote Originally Posted by June7 View Post
    Format property setting does not change the data. The graphed data is the actual values. Think will have to calculate (x 100) and graph that. Probably want to use Round function also.

    This is why I don't set properties in tables. I want to see real values when I look at my tables.

    Thank you June7 for the answer. Your way of think is correct. i got the feature to present the values as percentages. please, have a look on the attached screenshot.

    the issues know is how can i select all the bars (all columns of different colors) at a time to give them this setting?

    best

    Jamal

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,770
    I saw your other thread with that question. Will respond there.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Negative percent on a report
    By bcoots in forum Reports
    Replies: 2
    Last Post: 01-05-2012, 03:05 PM
  2. Replies: 14
    Last Post: 07-19-2011, 04:00 PM
  3. Replies: 3
    Last Post: 01-10-2011, 10:31 AM
  4. workinkg hours by percent
    By Mosely in forum Queries
    Replies: 1
    Last Post: 11-01-2010, 09:32 AM
  5. Access 2007: Percent Format Issue
    By diane802 in forum Access
    Replies: 6
    Last Post: 12-30-2009, 10:29 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums