Hi!

Im currently working on a report showing backlog in a production enviroment, and have run into a big gap between what i want to do, and what im able to do.

What i got is a 4 sheet report. Sheet 1 (data) is used to input date and current backlog in various processes manually The input is done on irregular bases(sometimes once a week, sometimes more frequent). Sheet 2 (sums) calculates total backlog related to each product at input date.

What i want to do is make sheet 3 (comparison) show 2 tables with backlog, where i set start date and end date for both. This means that the table size must adopt to my input dates.

Finally i want these to tables to show in 1 chart as overlay, so i can visually compare 2 timeslots. (Example jan and feb 2013, or jan 2012 and jan 2013)

Ive made an example workbook to try to explain what i want to do.

Attachment 212431

can anyone help with this, or point me in the right direction?