Chart x axis display question

[Jacque]

Merry Christmas everyone, [santa2]
Got a question regarding chart x axis display.

Crystal XI
SQL Server db
Chart type: Numeric Axis (Date axis bar chart)
Advanced Layout: on chg of date show event count.

My user would like to see a total of 5 risers/bars - begining with the Minimum date and ending with the Maximum date as the last riser/bar. The minimum date is always the first bar but the last riser is for an earlier date. Is this possible? I don't do enough charts to know if this is doable .


Thanks in advance!
Jacque

 

[rugger30]

We are using charting on Years and we do it setting a formula we call Year (year(Date)) where Date is however you are determining the date. We set the chart "on change of" @Year where the order is ascending. And then select the formula or field we want to show.

This seems to work quite well.