XY Scatter graph issues

Hi excel gurus,

I am trying to create a scatter graph on excel 2010 and these are the issues I am facing:

(1) Data labels - For the data labels I can use http://www.appspro.com/Utilities/ChartLabeler.htm however, I don’t have administrative rights on my school's laptop and require an alternative option

(2) Data layout – I know that I will need helper columns to create the output I am trying to achieve. I am having difficulty creating these helper columns.

(3) X Axis how do I get the days on the x axis?


I have hand drawn the graphic output (sorry I am not a good drawer) I want to achieve using a sample set of data (both files are attached below).

your help is appreciated!

Thank you Andy!

Andy I was successfully able to create a chart using your example, however, I have one little problem
I have a lot of data points between 12 - 3 AM and it's making the data labels difficult to read.. is there a way to increase the space in the y axis?
you can also refer to the picture to understand my question better. aa.PNG

http://www.excelforum.com/excel-prog...ta-labels.html

Also posted under macros to see if a hide macro can be created... I am open to new suggestions as well. Thanks!

Thanks for your help Andy, really appreciate it!