SAP Knowledge Base Article - Public

1198785 - How to avoid overlapping of labels and data labels from the stacked bar chart in Crystal Reports.

Symptom

In the stacked bar chart  the negative value (data label ) is overlapping with the label on the left side.


Reproducing the Issue

1.Create a crystal report using a stacked bar chart.

2.Place the field in the On change of Group in the Chart Expert.

3.Check if the labels and the data labels are overlapping or not.

Cause






 

Resolution

1) Create a formula "frlTest",
    {
         {Field1.Name} & ChrW(13) & ChrW(13) & ChrW(13)  & ChrW(13) & ChrW(13)
     }

2) Add this formula in the chart expert on change of the group.

3) Now you  view that the label in the "Y" axis of the stacked bar chart is moved towards left and then it is not over lapping.

Keywords

KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , How To

Product

Crystal Reports 2008 V0 ; SAP Crystal Reports XI ; SAP Crystal Reports XI R2