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
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
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.
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.
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.
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.
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.
I did not see that, I just down loaded the file Thanks