Assign Permanent Colors to Piechart Categories

[Jack_Green]

Hi,

I'm working on an Access 2000 database where I have created a form that uses a dropdown selction menu to change to different goal statments. By change the selection, I am able to change what data is displayed in the sub-forms. To show the status of each goal I have a pie chart that shows how all the tasks under each goal are currently standing. Some task are complete, some are on track, some have a little risk and others have failed. I want to set up the piechart to always display one particulr color for each category, but the trouble is that when one of kind of task class does not esits for the goal selection, the colors shift inthe piechart. So were I wanted failed tasks to be represetned as red, they are now blue because tasks with some risk do not exist for that goal.

Is there anyway to permanently assign a color to a category and not to a row in the datasheet?

 

[DCrake]

Right click on a segment on the pie chart then select format data point. Then on the Patterns Tab click on the Area section and pick a colour for that segment. Repeat for all segments.

David

 

[Jack_Green]

Right click on a segment on the pie chart then select format data point. Then on the Patterns Tab click on the Area section and pick a colour for that segment. Repeat for all segments.

David

That I know, but I'm reuseing the chart when I change goals. If one of the category states do not exist for another goal, the color assignments shift.

As an example, goal 1 has 5 category states, Risk (red), Some Risk (yellow), On Track (green), Complete (blue), Not Started (White). If I switch to goal 2, the category state for "Some Risk" does not exist, so "On Track" is now yellow, "Complete" is now green, "Not Started" is now blue. This also happens when you view the datasheet and hide one do the rows, you can see the color codeing switch.

I think there has to be a VB solution, but I'm at a loss on how to set it up.

-Jack