I have created a simple bar chart of works in excel. it has resource names and how many on the left and when they are working to the right. What I would like to do is:

1. select a resource via an input box so the user can choose which resource he wants.
2. based on the selection, I would then like to filter the information from the "bar chart" and produce a simple histogram from that information.


Now I could use specialist software to do this, but I would like to use excel I am using 2010.

I am new to VBA etc.. so be gentle.

Many thanks

Armchairandy.