Crystal Reports Display every hour of day in chart

Message

   Hi,

I've searched all around for an answer to my problem, but I don't seem to find it (or I don't know how to look for it).

I have a chart that shows record volumes per hour, populated by the formula field TimeValue({INCIDENT.INCIDENTTIME})

The issue is that sometimes there is no activity during some hours of the day, so the chart is not graphing the 24 hours I need to see. Example:

I see this:

52    45    78    23    56   23    75    34
1am 2am 3am 5am 6am 7am 9am 12pm....

I need to see:

52    45    78    0     23    56   23    0      75    0        0        34
1am 2am 3am 4am 5am 6am 7am 8am 9am 10am 11am 12pm... and so on

Do I explain myself?
Hope someone can help me with this one!

Cheers,
Andrea