Hard to say, but it sounds like you need one pivottable and pivotTable
graph. Then when the company is selected, the graph will show that company.

Regards,
Tom Ogilvy


Karl_S wrote in message
...
I have a layout at the moment thats works well for up to
about 30-50 graphs but now have to do 200, in the same
spread sheet. currently the raw data is sorted
alphabeticaly over abiut 4 sheets and then colated in
another the data form the colated one is then graphed.
There are 200 graphs to be done, what i want to do is
create a sheet that is like an index and will allow me to
click look up a company and then click to go to its data
or graph. I think this would require a macro.

Any help would be much appreciated.(am using office 2000)