Need graph with only totals with certain names

[brent_milne]

I have a table with invoice no., names and totals on every row. I am looking for a way to produce a bar graph where I can compare invoices that have all names that I can select. For example.
InvNo.1 - Bob - 10
InvNo.1 - Fred - 15
InvNo.2 - Bob - 5
InvNo.2 - Fred - 10
InvNo.2 - Tom - 20

I was hoping to be able to select Bob, Fred and Tom and only return the totals where all 3 of those names appear for the same invoice. So it wouldn't return individual totals for InvNo.1 only InvNo.2. And if I selected Bob and Fred it would only return InvNo.1 and ignore the invoice with Tom. Is this possible? Would a pivot table be better suited for this and if so, how should I go about it. Thanks for any help.

[adhawan06]

Yes, What I feel Pivot is the best option for this...Simply you can select the InvNo. in Row detail and then take the value in Value field. By this, you will get Total Invoice No. wise. Then simply you can create chart.

You can also use slicer I believer this will perfectly fit here..

Thanks,
Anil