How can I conditionally scale the axis in a graph of crystal reports?

Question

Is there a way (or a workaround) to conditionally set the max and min values ​​(and perhars even tick intervals) of the axis in the crystal report diagram?

I want to have the same scale on two different line charts, where one reaches a maximum of about 75 'and the other about 110', which makes automatic values ​​for selecting different scales. Setting the values ​​manually means that I have to change the values ​​if the numbers undergo large changes over time, and makes the report less multiple for other business units of different sizes.

Answer 1

I ran into the same charting issues in Crystal Reports. The best I could do was play with the option "Number of divisions" on the "Axis" tab in the "Expert Chart". In addition, in the "Data Values" section, the "Autoscale" checkbox is not selected by default in my version. In Xcelsius (Crystal Dashboards), you can easily set the range of axes by reference to a cell, but Crystal Reports does not show us this option.