I create a pivot chart using a form and have the source for the chart as a query. When I add data labels I make the fill color property 'none' (transparent). In the print preview the chart looks fine but when i print it, all the data labels are printed with a black fill. At the moment I have made the fill color of the labels white but when there is more information the labels overlap and the white background blocks some numbers in the data labels.
If I could get some insight into making the fill color of the data labels to be 'none' (transparent) that would be best.
Thanks