Excel chart question

[HalifaxDrunk]

Does anyone know how to create a chart with the following info?

I have a list of different times that a report is triggered during the day. I want to create a chart (scatter?) that gives a visual view over each day of the week when the reports are created.

So along the X axis it would list the 7 days of the week and along the Y axis it would have the 24 hours of the day. Then each time a report is generated would be a pinpoint on the chart by day (X) and time (Y).

I hope this makes sense and is even possible.

Thanks
HD

[Ashartus]

I'm not sure it's the best way to present the data, but you could make a table with the first column having the day and the second column having the time - it could just be a straight list of all events. You then create a scatter plot with the first column as the X axis and the second as the Y axis.

To do it as a scatter plot you might need to use numbers to represent the days (e.g. Monday = 1, Tuesday = 2) and use 24-hour time (e.g. 3pm = 15), though I did some quick playing around and it seemed to work using day names instead of numbers.