Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Charts in Crystal reports - font size in Data labels

Posted on 2004-10-27
Medium Priority
Last Modified: 2013-12-03
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!

Question by:sam__b
LVL 42

Assisted Solution

frodoman earned 123 total points
ID: 12432247
I haven't seen any way to make them any smaller than what you've already done.  


Expert Comment

ID: 12432575
You can't make the font any smaller, but you could stagger the labels.

In CR10, select the label on the group Axis, right click and choose "Chart Options -> Grid".  Next you will see two vertical "tabs", Data Axis and Group Axis.  Click on Group Axis.  Now you will see a "Labels" tab.  You can either "Stagger" labels or only have ever Xth label appear.

That's it.
LVL 28

Expert Comment

ID: 12433041

You can make the font smaller.
Right Click the Chart, and choose Chart Expert.
Click the Text tab.
Highlight Legend title under Format in the lower right, and click the Font button.
In the Font dialog, instead of selecting a value from the listbox, type your own value in the text box.  I used a 3 and it worked fine.
If it doesn't work, then your font may not support that size.
I used the standard Arial font and was able to put in a 1,2, or a 3.  CR 10 even supports half sizes like 3.5 if you wanted to use it.

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

LVL 28

Accepted Solution

bdreed35 earned 126 total points
ID: 12433068
Oops, I reread the post and realized that you were referring to the data labels and not the legend text.

I agree with the other experts that the DATA LABEL text can not be made smaller than the values listed in the listbox.
LVL 28

Expert Comment

ID: 12433094
It is a little strange why they would give you full control over the size of any of the Legend text, Title, Subtitle, or Footnote, yet they make you stay within the confines of the preset values for the data labels.

Assisted Solution

dtaylor92 earned 126 total points
ID: 12448638
Only possible alternative I know is to give a call to:


These guys built the graphics engine that Crystal Reports uses, so perhaps their sales people would be able to make a recommendation, if it's really that critical.

Are you going to close this thread now?

Author Comment

ID: 12458291
Hi people,

Thanks for your comments
frodoman, bdreed35 - although you have not provided a solution, thanks for your comments which have relieved me of the suspicion that I might be insane for not being able to figure it out.
dtaylor92 - note to your first comment - I was trying to edit the labels that go on the bars rather than the labels that go on the axis (although you may have figured this out already). I will investigate the plug-in you have suggested.  From a brief browse of their website, it appears that it may tidy up some of the weaknesses in the CR charting functionality - a pity these features aren't included!

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

578 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question