I have 1 year worth of data, and the data is recorded every hour therefore I have 8760 entries worth of data. I want to graph this data by per day (every hour) but I don't want to do this 365 times. I know I can do this with VBA but I don't know how. basically, I want VBA to have a small for-loop so it can do this 365 times without me having to select the cells to be graph.
data is arrange in 2 columns, the first one has the date and time and the second one has the data to be graph. and of course the first row contains the titles.
I have been trying this for 2 days now and I can't figure this out any help will be appreciated.