Charts - Legend Colours

G

Guest

I have a Pie Chart and a Legend and I want to match the colours up to
specific colours, i.e. Legeng is..

Red
Amber
Green
Blue

and I want the colours on the Pie to be Red, amber, Green & Blue to match
the legend.

Is this possible ?
 
J

Jeff Boyce

Disregard the "you can't do this" response. It is either SPAM or something
worse. Follow the link at your own peril!

The person posting the response has used several different aliases, and is
now representing him/herself as an MVP.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
G

Guest

I was able to choose the color of the pie pieces by double-clicking the chart
to open up the datasheet then click on the chart again...and then once more
on one pie piece and it should select then right-click and choose the color
you want. Repeat selecting the other pie pieces to choose their colors as
well. The legend will automatically change to reflect these colors.
 
G

Guest

Thanks for this it worked however I have 4 segments to the pie, but when i'm
in Design mode only 3, hence I can't change the 4th missing one.
 
G

Guest

You can change the datasheet to include the 4th data segment entering any
dummy data you want. This will allow you to click the 4th pie piece and
choose the color. Hope that helps.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top