Hi,
I have a chart in Crystal report that is pulling data from BI Query.
I have to diplay the bar chart on X axis that reports the values against Y1 axes and there is a trendline that reports values in the Y2 axis. Basically making the use of Dual Axes and Multi Axes option in the Chart Options.
The values in the Y1 axis is Number whereas the values in Y2 axis is Percentage.
Now in the Axes settings when I change the settings for the datalabels to Percentage, the reporting values in the Y1 axes also changes to percentage and a % symbol gets suffixed to the number in both the data labes for Y1 and Y2 axes.
It seems that both work in conjunction to eachother.
Can anyone please suggest a workaround based on the past experience.
Thanks!
sapboite (BOB member since 2009-02-01)