Help required constructing stacked chart

[Smudge.Smith]

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

[ben_hensel]

It is not clear at all to me what you want. To me the thing on Chart1 you have is pretty intuitive, but the example cartoon on Sheet1 looks halfway between nonsense and deception.

The x axis is a list of the locations. Okay.

What are the y axis values? A stack of the "offence excess speeds"?

You called the chart you have "fairly meaningless".

What's the meaning you're trying to find in the chart, then? Which Locations have the most offences? Which locations have the most dangerous/serious offences as a total or a (proportion of the total)?

I don't have a sense of what you want this chart to say, let alone how you want it to say it.

[Smudge.Smith]

Something must have got lost in the Anglo-American translation.

In Chart 1, I have the highest recorded speed of an offender, breaking the speed limit at various sites on various days. (The measuring period for this particular report was one week). As I said, This data alone is fairly meaningless. What use saying the highest recorded offence at Location 1, Location 2, Location 3 etc on a certain day was x mph?

More meaningful would be to COMPARE the highest recorded speed at Location 1, Location 2, Location 3 etc... with EARLIER recorded highest speeds at the same locations. Eg is the maximum recorded speed we have measured at Location 1 any higher or lower than the last time we visited Location 1 (and the same question applies for any other Location that was visited during the reporting period).

You must excuse my 'cartoon' too. If I could reproduce in Excel what I wanted, then I would hardly be asking for assistance.

Thanks for responding - hope this helps you to understand what I'm trying to achieve.