Creating Chart from multiple Pivot tables

Ubaid ur Rahman 

That's better to do with DAX. First, create Date table in your model (to simplify could be done within Power Pivot clicking on New Date table) and link it one-to-many with your Range table.

Next add two measures

Vendor Distinct Count :=
DISTINCTCOUNT ( Range[Vendor] )

and

Running Year Distinct Count:=CALCULATE (
    [Vendor Distinct Count],
    DATESINPERIOD ( 'Calendar'[Date], MAX ( 'Calendar'[Date] ), -1, YEAR )
)

and build Pivot Table from data model using measures, connect existing slicers to that Pivot Table.

Result is as

It like this

but very depends on which kind of chart you'd like to have.