VBA for Access chart colors

[Tcurtis]

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

[June7]

Don't understand. You want every wedge of pie chart to be same color?

[Tcurtis]

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.

[June7]

Review https://www.accessforums.net/program...vba-29178.html

[Tcurtis]

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.

[June7]

Did you download the sample db?

[Tcurtis]

I did not see that, I just down loaded the file Thanks