I have a file with alot of measurment series, on sheet "Sammanst?llning". I want to compare each series as seperate lines in a line diagram on
sheet "Diagram". Each series is framed by a thick border, within each series there is a column for date and measurment. Each series start and end date
is different. And between some series the measurments are taken on differnt date intervals.
I would like to sort the series so they line up between start dates, to be able to compare each series in a line diagram with a single.
This could be done by manually dragging the series to line them up, but this would take a lot of time since there are 34 measurement series, varying in length with a couple of thousand rows. This method would also not solve the issue of some series having measurement point taken at different dates.
Do you smart folks have any sorting function or macro that would be able to align all these series, to be able to combine them in a single diagram for ease of comparison?
I'll attach the workbook (with most of the rows removed) along with a figure trying to describe the problem.