I have a simple graph which shows graphically the current situation of various projects i.e if complete 1 and if not 0. This is divided by department and project. Therefore the intranet project for example is complete in all dept so I have assigned 1 and the graph shows (Project's at bottom of the graph) that for all depts project is complete.
Right what i want to do is forecast the situation in a months time. I.e If i know a project will be complete in a month I can assign a value to this and it will show in a different colour (like a stacked graph) so say red equals done,blue equals forecast compete in a month.
I can send the excel sheet, I expect this is so simple that Ive made it complicated. God help me