Populate Graph data per data validation list

Hello:

Please refer to attached sheet.

I have sheets called Graphdata and Graph.

By selecting the catogory from drop down list in Sheet "Graph" Cell A7, i want to populate the Graphdata to create the graph.

Please help with this.

Thanks

Riz

G'day

Hmmm with 430 posts you should be nearly up there with the excel guru. Me I'm out of touch and starting to get back in the swing of things.

So here is my two cents worth. If this isn't what you like please explain more.