Need Excel Help - Pivot Table, Charts.

[Opozit]

Hi all. New member and excel newbie here. Recently i came across 2 excel worksheets with lots of data and i want to find Total Value of inventory, and number of materials (not quantity but kind of materials) for each material owner. I want show the results (total value and kind of material) in a single graph using bar and line.

I want to accomplish this using these formulas and tools only:
· trim (to remove spaces and errors for vlookup)
· vlookup
· pivot table
· graph and its secondary line

Thanks a lot. Really appreciate it.
Opozit