Pivot Chart Running Total - Removing Current Year Future Total

Hello,

What I am trying to do is to have a comparison of previous years data to the current years up to the current month (Data not available for future months). Using pivot charts and running total this produces a continuous flat line where data is not available in future months.

The Data is a large amount of transactions therefore a pivot chart will allow for changing the department or item. I have attached an example of the problem which I am trying to resolve. Currently I am selecting the points and formatting to remove them.

Any assistance would be greatly appreciated

Thanks!

Example.xlsx

Points in the graph which are in the future such as August -December for 2013. This I do not wish to be shown as the data is yet to become available.

I say removed really I should have said hidden formatting for no marker or no line for them points.

Is there no way to set values to NA() or "" so they won't show after current date?

I have also got powerpivot if this would allow me to do this

Thanks