How Best to Display

[IanDGreen]

Hi Everyone,

I am attempting to visually illustrate the fluctuation of vehicle movement

(a) at two different locations,
(b) at half-hourly intervals throughout each (24hr) day of the week, and
(c) over a three-year period and, quite honestly, haven't a clue how to achieve it.

My brain has gone totally dead after compiling all the data, and I'd be grateful if someone could point me in the right direction with this.

Thank you,

Ian

[xlbiznes]

Hi, share sample data to understand this better.

[IanDGreen]

Hi xlbizines,

Herewith a sample of the type of data I have collated so far, together with a layout which I originally thought might be useful, but am now thinking otherwise.

Obviously the data for all other days and years I didn't bother including as it would just be repetitive.

Hope it makes sense to you?

Ian