Making fancy automatic graph

Hi everybody,

I'm making up some fancy graphs that could be used for the following up of a project and I'm quite stuck...
In the attachment of this mail you can find the current situation.

What I want to become with the aid of following field:
Project Month: June '14
==> This field should become a 'Trigger' to make a distinction between the already realised time (=PAST, <= June '14 in full lines) and the upcoming timing (Forecast, > June '14 in broken lines --)

Furthermore I would like to see only the number of this month
(so not all the numbers of the others months).

In the end this process should be automated based on the input of the table.

Can anybody help me with this?

Thanks by advance,

Gabriël

AttachmentSize
2013_11_11_Excel Grundlage für Auswertungen_GKAV3.xlsx150.8 KB