Date + time on X-axis, value on Y-axis

[d_abbatelli]

Ok, my data looks like this:

01/01/2013 00:00 12345.78
01/01/2013 01:00 98765.43

... and so on, for about 20.000 lines (is 3 years and a half of logging every hour, but I will can split it into years).

I want to plot this data in a chart with double X axis, one for the month and one of the week number.
I achieved something quite close with a line chart and the x-axis formatted for date, with units of one month, but then it plots a line for every day, while I want one for every hour.

Also, I don't know how to plot the week number on an extra axis.
I don't know anything about Visual Basic, so I would like if someone could explain me how to achieve that through the menus.

Thank you

[Andy Pope]

you will have to use xy-scatter as the Date axis will only go to Day level.

You may need to create your own axis labels, using data labels from dummy series, if the default axis labelling is not suitable.