Use VBA code to choose slice colors on a pie chart report

[Guest]

Hello,

I have a report with a pie chart. It displays correctly, except I would like
to be able to choose my own colors for the chart slices.

Can anyone give me a vba sample of this?
The data headings and desired colors are:
Stocks: Blue
Bonds:Green
Mutual Funds: Grey

Thanks,

 

[Guest]

Hi John,

Perhaps this KB article will be helpful to you:

http://support.microsoft.com/kb/200527/en-us

Note: In the second line of code shown in this example, I recommend using
explicit declaration of your recordset.

Change:
Dim rsRowSourceFiltered As Recordset
To:
Dim rsRowSourceFiltered As DAO.Recordset

You should also add code at the end of the procedure to close this recordset
and set it = Nothing.


Tom Wickerath, Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________