Excel Macros, PLEASE HELP!

[excelmacrouser]

Hello all, i'm new to this forum, so could someone please help me! i'm doing a project for university which involves me having to create macros in excel.
Here is the problem, i have 10 links on the left side of my worksheet. which i need to assign macros to, these macros have to link to various charts, objects etc which are kept in additional worksheets in the same file. anyway i can easily assign the macro to go to another worksheet to display that chart, but how do i assign the macro so that once clicked the chart APPEARS in the current worksheet, so the chart sits to the right of the links, and then when a new link is clicked, the next chart is inserted in place of the old chart.
please somebody help me, because i'm sure this will end up being an easy problem! i'm just not that well experienced with excel.
thank you everybody.

[Rowan Drummond]

I would have all the charts created on the one sheet, one on top of the
other. Then your macros just have to hide all charts and unhide the one
relevant to the link something like:

With Sheets("Sheet1")
.ChartObjects.Visible = False
.ChartObjects("Chart 1").Visible = True
End With

Hope this helps
Rowan

excelmacrouser wrote:
> Hello all, i'm new to this forum, so could someone please help me! i'm
> doing a project for university which involves me having to create
> macros in excel.
> Here is the problem, i have 10 links on the left side of my worksheet.
> which i need to assign macros to, these macros have to link to various
> charts, objects etc which are kept in additional worksheets in the same
> file. anyway i can easily assign the macro to go to another worksheet to
> display that chart, but how do i assign the macro so that once clicked
> the chart APPEARS in the current worksheet, so the chart sits to the
> right of the links, and then when a new link is clicked, the next chart
> is inserted in place of the old chart.
> please somebody help me, because i'm sure this will end up being an
> easy problem! i'm just not that well experienced with excel.
> thank you everybody.
>
>
>