Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

chart data labels overlap 1

Status
Not open for further replies.

skitty123

Technical User
May 4, 2004
56
US
I have pie charts in my report tahts how product names. sometimes the product names are long so they overlap with other names.
is there anyway to avoid this?
using Crystal 8.1 (i think) that comes with Visual studio .net 2003 I tried chaneging font size but it seems to have no effect :(
 
Not sure about the trimmed down version that comes with .NET.

For CR 8.5, click the chart while in the Preview mode, select Analyzer from the menu->Format Chart->General->Data Labels->Labels on Sides and improve this.

-k
 
I am not sure if this is ok, but I have a similar problem with pie chart labeling.(I am using version 9)
Not only do some of my labels over lap at times, they also have a text boxy size considerably larger than the text contained in them. Additionally, I get sporadic placement when I try to drag a label to a slightly different location.
I need better controls over these labels, any more help?
 
You might also try the 'Auto-Arrange' menu item.
Right click on the pie and do ChartOptions->AutoArrange

Dan Weingart
OEM Technical Manager
Three D Graphics, Inc.
 
Just wondering if you solved this problem ... I have the same problem with 3d charts .... here is my story

I have a 3d area chart whose group axis is time. This chart shows some data for each hour of the day. The problem is for 24 hrs of data the time labels become cluttered ... i.e. they overlap each other. Is there a way I can show just alternate labels ??

I created a formula to do this but the problem now is that the graph only shows for alternate time. What I want is that graph should show all the data points but only alternate time labels are printed.

Here is the formula field I created ...

If Hour ({WMSReportTable.Date_Time}) Mod 2 = 0 Then
Formula = TimeValue ({WMSReportTable.Date_Time})
End If

Is there a way to associate this just with the labels and not with the graph??

Can anyone help me with that. Let me know if the question is not clear ...

Thanks in advance
DK
 
FYI ... I am using microsoft .net framework to create the crystal report.

DK
 
If you go to the chart analyzer there is an option to stagger labels. Go to chart analyzer->format chart->grid->group axis tab->labels tab->stagger labels. You have the option of entering the number of groups between lables.

-LB
 
Wow ... that did the trick .... thanks LB

Now I am wondering why I did not see that option.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top