Specific colors in a pie chart

[Animal]

Hi there,

I would like to get help with this problem:

I want each category in my pie chart to represent a specific color, even if
there is no data in it.
For example:

Chart Datasheet:
STATUS (value) COUNTOFSTATUS (value)
COLOR_RED: "Red" 5
COLOR_YELLOW: "Yellow" 0
COLOR_GREEN: "Green" 10

When I run this query as a pie chart, the colors turns out to be red= "red"
and yellow = "green" because the are no yellow values.
I want the colors to be defined, how do I do?
I know that this can bee done with other charts, why not this one, the pie?

Thanks,
Animal

 

[Al Campagna]

Animal,
I think you're allowing the chart to assign colors (color is set to Auto).
When viewing the chart in design mode, with data that yields ALL pie sectors...
Select each pie sector individually, one at a time, and "hard" wire the color through
the FormatDataSeries.
Each sector "should" hold their color, even if a series is missing.
--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."

 

[Animal via AccessMonster.com]

Al Campanga,

Thanks so much for your answer....but it still doesn't work as I like to.

I have done exactly as you wrote and it does hold it's colour but only when I
allow it to sort the values automatically in the legend.

Try this to see what I mean:

Query:
STATUS COUNTOFSTATUS SORTCOLOUR
Red 2 1
Yellow 0 2
Green 1 3

When I have a query like this, it doesn't hold it's colour.
Isn't that odd?

Can you please help me with this one.

Thanks,
Animal

 

[Al Campagna]

Animal,
I'm not sure what you mean by "sort the values automatically in the legend" The
sorting is controlled by the query behind the chart.
For constant colors, the sorting of the elements must always be the same.
Ex.
Category Series Color
A 1 red
B 2 blue
C 3 green

B 1 red
A 2 blue
C 3 green

A great resource for charts...
http://peltiertech.com/Excel/Charts/index.html
--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."