I am using Excell 2000
I need to create of year's worth of several different charts that all come
from basically the same data. What I would like to do is put a year's worth
of charts (let say chart "A" from Jan thru Dec) on one tab and Chart "B" from
Jan - Dec on another tab.

I want to create a hyperlink at the top of the tab (in the first row) by
month. Ex: Jan, Feb, March, Arpril etc. So when I click on the month cell
it will take me to the chart for that month. I think I need to name each
chart so that I can go to the exact chart, but I do not know how to do that.
Can anyone help me or suggest a better way to accomplish my goal.

Aurora

You can name the cell at the top left of each chart, then create a
hyperlink to that named cell. There are instruction for naming a cell he

http://www.contextures.com/xlNames01.html

Aurora wrote:
I am using Excell 2000
I need to create of year's worth of several different charts that all come
from basically the same data. What I would like to do is put a year's worth
of charts (let say chart "A" from Jan thru Dec) on one tab and Chart "B" from
Jan - Dec on another tab.

I want to create a hyperlink at the top of the tab (in the first row) by
month. Ex: Jan, Feb, March, Arpril etc. So when I click on the month cell
it will take me to the chart for that month. I think I need to name each
chart so that I can go to the exact chart, but I do not know how to do that.
Can anyone help me or suggest a better way to accomplish my goal.

Aurora


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Debra - Thank you for your help. I now can do it.

"Debra Dalgleish" wrote:

You can name the cell at the top left of each chart, then create a
hyperlink to that named cell. There are instruction for naming a cell he

http://www.contextures.com/xlNames01.html

Aurora wrote:
I am using Excell 2000
I need to create of year's worth of several different charts that all come
from basically the same data. What I would like to do is put a year's worth
of charts (let say chart "A" from Jan thru Dec) on one tab and Chart "B" from
Jan - Dec on another tab.

I want to create a hyperlink at the top of the tab (in the first row) by
month. Ex: Jan, Feb, March, Arpril etc. So when I click on the month cell
it will take me to the chart for that month. I think I need to name each
chart so that I can go to the exact chart, but I do not know how to do that.
Can anyone help me or suggest a better way to accomplish my goal.

Aurora


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html