I'm looking for a Dynamic means of populating a bar chart.

Cloumn A (Rows 2-200) Has the Names (Y Axis) of each Item and Cloumn B (Rows
2-200) (X Axis) has the Number Values. My problem is twofold... One, every
week the Y axis list can grow or shrink and Two, I only want to show those
that have an X Axis value that is greater than five. Anything less than or
equal to five I would like to have hidden from showing in the chart.

Is it possible to have some sort of way or formula that can make this
possible in a chart or in pivot table?

Thanks in Advance.