I have a horizontal bar chart sized to be the height of a full page, with data labels on the bars.
There are a lot of bars in this chart, and as a result they are quite narrow, and the font size for the data labels is too big. The labels overlap, or just look plain messy.
How can I make the font size of the data labels smaller?
I have tried:
(a) right clicking on the labels, and selecting Chart Options/Selected Item from the pop-up menu. The smallest font size available from the drop-down box in this dialog box is 4 points, which is too big (incidently, a genuine 4 point font would probably be plenty small enough, but CR increases the size of the font relative to the size of the chart, since the has been streched to be the height of a full page)
(b) Using the Chart Expert. Here I can deselect "automatically set chart options", and in the "Text" section of the expert I can set font attributes for various parts of the charts, including something called "Data labels". Here font sizes smaller than 4 points can be entered. But when I enter a font size here, it has no effect on the actual font size of the Data Labels in the chart. Is this a bug in Crystal reports? or am I looking in the wrong place?
NB: using Crystal Reports V 10.
I've been searching the net, searching the CR help files, and wasted heaps of time fiddling with the chart, but all to no avail - I look forward to your help!