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

[6StringJazzer]

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.