Create chart over a year data

[hanif]

Hi All,

I have a range of data that holds values for each hour over a year. I need to create a line chart to shows values against that hour. i.e my x-axis should be hour 1 to hour 8760 (total number of hours in a year) and my y-axis should be the value in that hour. Is there a quick way to do this?

I have uploaded the data to see how they like. I really appreciate if you could help me.

Thanks,

[ufopilot]

This will be a large chart.

[José Augusto]

Hi
I think you should have only two columns. One of the columns will have values of x and other measured values for that x.
In new sheet use in A2

Please Login or Register  to view this content.

and In A3 and drag down

Please Login or Register  to view this content.

In B2 use and drag down

Please Login or Register  to view this content.

Format A2:A8761 with custom format "mm-dd.hh"
See if this helps you.

[ufopilot]

I think I misunderstood... I re-read the post and also see that you have the correct answer.
Sorry

[hanif]

Thanks a lot Jose, It clearly gave me an idea. Thank you both for your help