How to mimic range and chart activity using VBA Excel

How to mimic range and chart activity using VBA Excel

The basic data set looks like this:
FIG 1
What a pre-decessor did with the data set is to make it linear by copying
all the data, i.e. saturday -> data, sunday -> data
Like this:
FIG 2
Using this format, he was able to generate a graph like this:
FIG 3
Now, I have started to automate this document, where now, I have got to
the stage of automating Fig 1.
My question is, by looking at the graph, is there a way to skip FIG 2 and
just generate the graph using the data in FIG 1?
I have spent a couple of hours thinking about this and I cant seem to
think of a solution.
I was thinking along the lines of creating a data range with, 00:00, 01:00
..... and the day data, iterating that for all the days then combining the
range to make a mega range, but I can't see how that will work.
Can anyone push me in the right direction to solve this problem?
Thanks
Chris