Hi Everyone,
First post of here and hoping that after a while I too may be able to return the favour one day as my knowledge of excel increase so my thanks in advance.
I am trying to produce a line graph which plots energy consumption over a 12 month period.
I have recieved a spreadsheet for the energy company which record the usage every half hour for every day of the year. This is displayed as below:
DATE 0030 0100 0130 0200 0230 0300 0330 0400
01/07/2011 44.8 44.8 44.4 44.2 44 43.8 44 44
02/07/2011 41.4 41.8 41.6 41.6 41.8 41.4 41.6 41.8
03/07/2011 41.4 42.8 42 41.2 41.8 41.8 41.4 41.4
04/07/2011 41 41.4 42.4 41.2 41 41 40.6 40.6
05/07/2011 41.8 41.4 41.8 41.4 41.6 41.8 41.4 41.4
06/07/2011 43.8 43.4 43.4 43.4 43 43.6 43.2 43.8
07/07/2011 44.4 44.6 44.2 44.6 44.6 45.4 44.6 44.6
08/07/2011 44.2 44.6 44.2 44.6 44.8 44.2 44.6 44.4
As you can see every day is on a seperate line and includes 48 seperate readings (only small bit of data displayed), as you can there is a huge amount of data for the whole year.
However, when i try to plot this on a graph it wants to plot a different line for every day, what I would like to do is plot a continous line for the whole year, plotting every half hour point for every day.
How would I go about doing this?
Any advise or tips would be greatly apprecited. Apologies in advance if i have not explained myself very well above.
Regards
Gareth
Bookmarks