Hi all
I am looking to produce a time scatter graph and want to know the best way to go about this.
the data is 2 columns one being amount and the other being the time
eg
£200.00 00:15:48
£400.00 02:25:74
£158.78 07:45:40
£40.12 12:11:12
etc
on the vertical axis would be the amount and on the horizontal axis the time but rather than the individual time I would like the axis to be per hour.
So there would be 0 to 23 points on the horizontal axis to represent each hour.
Is this possible?
I am looking to produce a time scatter graph and want to know the best way to go about this.
the data is 2 columns one being amount and the other being the time
eg
£200.00 00:15:48
£400.00 02:25:74
£158.78 07:45:40
£40.12 12:11:12
etc
on the vertical axis would be the amount and on the horizontal axis the time but rather than the individual time I would like the axis to be per hour.
So there would be 0 to 23 points on the horizontal axis to represent each hour.
Is this possible?
