My spreadsheet has a list of all the suppliers (5438 of them) that were used during our last fiscal year where I would like know of a way to find the vendors with the greatest spike in Q4 spend.

I have a pivot table set up that lists all the vendors in column "A." Columns B = Q1 Spend, C = Q2 Spend, D = Q3 Spend, and E = Q4 Spend.

1. How do I filter out any suppliers that do not have spend across at least three financial quarters?
2. How do I go about setting up the appropriate chart?