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)

Depending on your version of Excel and your operating system
I think you may have a problem with 200 graphs and hyperlinks.
Be prepared to separate them into different workbooks.
If you have sheets that are related i.e. graph on one, and data
on another you would want to group them with the ctrl key
and then move them to another workbook with Edit,
move or copy. Specifically if you have Win 98, I think you
may have a problem, with Win 2000 or Win 2002 probably not.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"pancho" wrote in message ...
I think you better solve that using HYPERLINKs on a
spreadsheet, using Bookmarks to the data or graphs you
want to select, but this have an awful side: the user need
to locate always the same page for the graph and data
index.
or you can add a user form constructing a list with the
names of the graphs then you can code the CLICK event for
that listbox, where you can locate the proper graph or
data.


Francisco Mariscal
fcomariscal at hotmail dot com



-----Original 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)
.

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)