Formatting the Date on the X axis

[georgedickson]

Hi,

 First post, so please be gentle.  I have spent some time looking in these forums for an answer to this question but I have been unsuccessful.

I have base data which is sampled every 5 minutes.  I'm displaying the results over a 12 hour period (so (60/5) * 12 = 144 points).  The issue I have is that the X axis (Collection Time) looks awful.  I would like to find out how I can retain all 144 points of data but have the x-axis display 06:00 , 07:00 , 08:00 etc....

I'm sure this is a common problem but I just can find an answer !

I have experimented with a time-series chart but all I get are 12 points of data over the 12 hour period.

I'm using iReport 3.7.1 community edition.

Thanks in advance,

GeorgieDee

Post Edited by georgiedee at 03/30/2010 13:33

Post Edited by georgiedee at 03/30/2010 13:58

[mdahlman]

GeorgieDee,

The Timeseries chart is definitely the way to go. It's intended for data like this. It sounds like you set the "Time period" to hour. Set it to minute and see if you get what you're looking for.

Regards,
Matt

[georgedickson]

Matt,

 

I tried your solution.....and it worked first time !  Can't believe I was so stupid not to try a time-series chart before now !

Great advice and nice to see that these forums do work to provide solid solutions.

Have a great Easter,

GeorgieDee