Forum Discussion
How to change the color of each pie chart slice in access?
I need to set standard colors for Pie charts in our Access database. Currently, this is what I see. But our organization has standard colors used in other applications and want to use it in access charts as well. I am also attaching a screenshot of the chart settings.
Any advice would be greatly appreciated.
Thank you!
2 Replies
Not exactly what you want but I found a way to flip the blue/orange color, since colors are given by
alphabetical order blue is given to the first letter while orange to the second (in your example "Campus" starts with letter "C" which precedes letter "T" from "Telework"
Either choose words starts with the order you desire or in your case if you want "Telework" blue and "Campus" orange just add space before " Telework" which pushes it to top
Sorry for not having a better way...
Hi,
4 years ago Shane Groff from the Access team wrote in a comment on the New Charts blog post:
> Pie Charts don't currently support manually setting the colors of the slices.
This hasn't changed since then. There are color options for the other chart types but not for pie charts.
Maybe you can use the old charts still available in Access, where you can set the colors also in pie charts.
Servus
Karl
****************
Access Forever
Access News
Access DevCon
Access-Entwickler-Konferenz AEK
