Format record bound charts in Access, data labels and colors

T

TRS_JC

In Access 2000 (MS 2003) I have created record bound charts in a report. In
a pie chart, I would like to know how to prevent the data labels from writing
over each other. I am having trouble formatting the labels because on each
chart (different reports) the sections of the pie are different sizes. When
the pie slices next to each other are small, the data labels cover each other
up.

The other issue I am having is that the colors are not consistent among all
the pie charts. I want each category to be represented by a color even if
there is no data. I eliminated these records from the query because I didn't
want the data labels to show up and reflect the 0% (too crowded). So I was
wondering if it is possible to set each category to a specific color.
 
Top