Need some help folks.
I have produced a chart that shows the highest speed offence detected at various locations in a reporting period (typically a week). This is fairly meaningless at the moment as ideally it would need to compare with a previous highest recorded speed at the same site (whenever this was visited). I'm fairly sure that using a stacked chart would be the best approach but I have no idea how to make it work. I have included a weeks worth of data for brevity but the original data is imported from a CSV so I can report between any given dates. However the data is 'flat' and only reports the highest detected speed.
I have produced a simple graphic representation on Sheet 1 of the sort of thing I am trying to achieve.
Words of wisdom please
Bookmarks