Results 1 to 7 of 7
  1. #1
    Tcurtis is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2014
    Location
    Tupelo, Ms
    Posts
    5

    VBA for Access chart colors


    I have several pie charts with 6 data points each. The data points are the same but some are zero and do not show up on the graphs. Is there a way to set the color for the data points so that they are all the same?
    Thanks

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,632
    Don't understand. You want every wedge of pie chart to be same color?
    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
    Tcurtis is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2014
    Location
    Tupelo, Ms
    Posts
    5
    Sorry, did not explain myself too well. I have several charts for different facilities. Each facility has the same information, Scrap, Obsolete, Lost, etc. I want the information from each plant to be the same color. Scrap = Red, Obsolete = yellow, etc. Does that make more sense? The colors "start over" if one plant has zero for one of the data points.

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,632
    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.

  5. #5
    Tcurtis is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2014
    Location
    Tupelo, Ms
    Posts
    5
    I worked on my charts trying to use this example but I am not good enough with VBA yet to know what I am doing with this code. I may be inserting this code in the wrong place? I am putting it into the graph and not the form that the graphs are on. I am counting the number of material numbers there are grouped by a status. Like 20 material numbers for Scrap, 30 material numbers for obsolete, etc. I have a total of 6 status categories. I know I am in over my head at this point but I don't see any other options for making the colors standardized.

  6. #6
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,632
    Did you download the sample db?
    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.

  7. #7
    Tcurtis is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2014
    Location
    Tupelo, Ms
    Posts
    5
    I did not see that, I just down loaded the file Thanks

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

Similar Threads

  1. Replies: 20
    Last Post: 10-25-2013, 06:16 AM
  2. Replies: 9
    Last Post: 01-29-2013, 06:44 PM
  3. Replies: 2
    Last Post: 07-12-2010, 05:39 AM
  4. Pie Chart Colors!
    By dannyowl in forum Access
    Replies: 0
    Last Post: 05-12-2010, 09:30 AM
  5. Replies: 1
    Last Post: 12-30-2005, 10:23 AM

Tags for this Thread

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