Name a chart for hyperlinking

[Aurora]

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]

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 here:

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

[Aurora]

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 here:
>
> 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
>
>