Results 1 to 3 of 3
  1. #1
    SpookiePower is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Nov 2013
    Location
    Denmark
    Posts
    14

    Pivotchart - change values on axis and add names ?


    I have a pivortchart that shows how many different items I have sold. But the value on the left side has a lot of digits after the number. How can remove these digits so that 30,162.... will be 30 ?

    Another question - is it possible to add names to each bar ? I know that I can use the legend feature, but with all my bars, it is pretty hard to find the right color and name.

    Click image for larger version. 

Name:	Pivotchart.jpg 
Views:	5 
Size:	105.5 KB 
ID:	14562

  2. #2
    SpookiePower is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Nov 2013
    Location
    Denmark
    Posts
    14
    I found the solution to the many digits - Click on the numbers - Property sheet - Scale - Custom major unit = 10

    But I still don't know if it is possible to add names to all the bars.

  3. #3
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,930
    Can't the chart show the data above each bar?

    I know that can be done with a graph object. I have never used pivotchart.
    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. Change Excel Sheet Names
    By qwerty1 in forum Access
    Replies: 4
    Last Post: 06-12-2012, 09:53 AM
  2. Chart axis change with .Chartype changes
    By alangea in forum Programming
    Replies: 2
    Last Post: 05-20-2012, 12:41 PM
  3. Scatter Chart not Showing X-axis Values
    By ward0749 in forum Forms
    Replies: 4
    Last Post: 03-20-2012, 06:37 AM
  4. Replies: 3
    Last Post: 11-29-2011, 02:37 PM
  5. Replies: 0
    Last Post: 05-07-2011, 04:24 PM

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