Jolted_Chicken
Registered User.
- Local time
- Today, 17:28
- Joined
- Nov 7, 2002
- Messages
- 15
I have a pie chart that is based on IIF statements.
I want specfic colours for each sector. However, because it is based on IIF, not all the sections are there each time the report is produced.
Any hints on how to do this. I have tried setting the colour of the pie chart to manual instead of auto then selecting the colours. However, Access reassigns the colour cos not all the fields r there.
I want specfic colours for each sector. However, because it is based on IIF, not all the sections are there each time the report is produced.
Any hints on how to do this. I have tried setting the colour of the pie chart to manual instead of auto then selecting the colours. However, Access reassigns the colour cos not all the fields r there.