Graphing data against hours when there are hours with no data!

[mp9]

I'm graphing some data that has hour of the day along the x-axis. What I've actually got along the x-axis is a formula field which takes the form Hour({MYTABLE.TIMESTAMP})

My problem is this - there are some hours of the day where there is no data, and those hours get missed off the graph. So if there is data for midnight to 1am and 2am to 3am but nothing beterrn 1am and 2am, then the numbers along the bottom of the graph go 0, 2 instead of 0, 1, 2.

My question is - how can I force the scale along the x-axis to go from 0 to 23 without omitting any numbers for which there is no data?

Thanks.

 

[lbass]

You have to have a table that contains all hours to use as your on change of field, with a left join to the table that contains the results.

-LB