simple chart question

#1 11-22-2005, 12:30 PM

I know there must be a simple way to do this.. I'm just not all that good at
excel.

I have a pre-created chart. I want to put that chart on a sheet and, when
the user clicks a "show chart" link, in another sheet in the same workbook,
simply have that chart display. How can I do that?

Thanks a lot

#2 11-22-2005, 12:40 PM

Hi,

Jon Peltier has information on hyperlinks and charts.
http://peltiertech.com/Excel/Hyperlinks.html

Cheers
Andy

Roney wrote:
> I know there must be a simple way to do this.. I'm just not all that good at
> excel.
>
> I have a pre-created chart. I want to put that chart on a sheet and, when
> the user clicks a "show chart" link, in another sheet in the same workbook,
> simply have that chart display. How can I do that?
>
> Thanks a lot

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

#3 11-22-2005, 12:50 PM

Exactly what I needed! Thanks Andy

"Andy Pope" wrote:

> Hi,
>
> Jon Peltier has information on hyperlinks and charts.
> http://peltiertech.com/Excel/Hyperlinks.html
>
> Cheers
> Andy
>
> Roney wrote:
> > I know there must be a simple way to do this.. I'm just not all that good at
> > excel.
> >
> > I have a pre-created chart. I want to put that chart on a sheet and, when
> > the user clicks a "show chart" link, in another sheet in the same workbook,
> > simply have that chart display. How can I do that?
> >
> > Thanks a lot
>
> --
>
> Andy Pope, Microsoft MVP - Excel
> http://www.andypope.info
>

#4 11-22-2005, 04:10 PM

Andy, this worked great for spreadsheet 1. Then, I made spreadsheet 2, as a
copy of 1, but with different data. Now, when I click the hyperlink in
spreadsheet 2, it takes me to a completly different place in the workbook. I
have tried deleting and recreating the link. The link dialog has the correct
references. It just doesn't work. It's weird. Spreadsheet 1 still works fine.

Any thoughts?

"Andy Pope" wrote:

> Hi,
>
> Jon Peltier has information on hyperlinks and charts.
> http://peltiertech.com/Excel/Hyperlinks.html
>
> Cheers
> Andy
>
> Roney wrote:
> > I know there must be a simple way to do this.. I'm just not all that good at
> > excel.
> >
> > I have a pre-created chart. I want to put that chart on a sheet and, when
> > the user clicks a "show chart" link, in another sheet in the same workbook,
> > simply have that chart display. How can I do that?
> >
> > Thanks a lot
>
> --
>
> Andy Pope, Microsoft MVP - Excel
> http://www.andypope.info
>

#5 11-23-2005, 07:30 AM

What method of hyperlinking did you use?
Where should the hyperlink be taking you and where does it actually take
you?
If you where to create a new workbook with the same links does the
problem persist?

Roney wrote:
> Andy, this worked great for spreadsheet 1. Then, I made spreadsheet 2, as a
> copy of 1, but with different data. Now, when I click the hyperlink in
> spreadsheet 2, it takes me to a completly different place in the workbook. I
> have tried deleting and recreating the link. The link dialog has the correct
> references. It just doesn't work. It's weird. Spreadsheet 1 still works fine.
>
> Any thoughts?
>
>
> "Andy Pope" wrote:
>
>
>>Hi,
>>
>>Jon Peltier has information on hyperlinks and charts.
>>http://peltiertech.com/Excel/Hyperlinks.html
>>
>>Cheers
>>Andy
>>
>>Roney wrote:
>>
>>>I know there must be a simple way to do this.. I'm just not all that good at
>>>excel.
>>>
>>>I have a pre-created chart. I want to put that chart on a sheet and, when
>>>the user clicks a "show chart" link, in another sheet in the same workbook,
>>>simply have that chart display. How can I do that?
>>>
>>>Thanks a lot
>>
>>--
>>
>>Andy Pope, Microsoft MVP - Excel
>>http://www.andypope.info
>>

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

#6 11-23-2005, 11:10 AM

Without being able to offer any explaination, I was able to fix this. At one
point I had this spreadsheet open with two windows (window menu, new window).
I closed window 1 and saved it with window 2 open. I know of no way to "undo"
that. I noticed that, in the broken spreadsheet, whenever I opened it the
name was "spreadsheet_name.xls;2" signifying it though it was opening window
2, though there was in fact only one window. I opened a new workbook, copied
the sheets from the old to the new, saved the new using the old name, and
that fixed the links. Why, I have no idea.

Thanks for you help Andy.

"Andy Pope" wrote:

> What method of hyperlinking did you use?
> Where should the hyperlink be taking you and where does it actually take
> you?
> If you where to create a new workbook with the same links does the
> problem persist?
>
> Roney wrote:
> > Andy, this worked great for spreadsheet 1. Then, I made spreadsheet 2, as a
> > copy of 1, but with different data. Now, when I click the hyperlink in
> > spreadsheet 2, it takes me to a completly different place in the workbook. I
> > have tried deleting and recreating the link. The link dialog has the correct
> > references. It just doesn't work. It's weird. Spreadsheet 1 still works fine.
> >
> > Any thoughts?
> >
> >
> > "Andy Pope" wrote:
> >
> >
> >>Hi,
> >>
> >>Jon Peltier has information on hyperlinks and charts.
> >>http://peltiertech.com/Excel/Hyperlinks.html
> >>
> >>Cheers
> >>Andy
> >>
> >>Roney wrote:
> >>
> >>>I know there must be a simple way to do this.. I'm just not all that good at
> >>>excel.
> >>>
> >>>I have a pre-created chart. I want to put that chart on a sheet and, when
> >>>the user clicks a "show chart" link, in another sheet in the same workbook,
> >>>simply have that chart display. How can I do that?
> >>>
> >>>Thanks a lot
> >>
> >>--
> >>
> >>Andy Pope, Microsoft MVP - Excel
> >>http://www.andypope.info
> >>
>
> --
>
> Andy Pope, Microsoft MVP - Excel
> http://www.andypope.info
>

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)