Referencing worksheet CODENAME in a chart object.

Hi all,

I have an excel chart (generated by the Chart Wizard) that references the
worksheet NAME. For example, when i right click on chart, and select 'Source
Data' i see the 'Data Range' reference the worksheet NAME as follows:

='Main Menu'!$D$13:$D$14,'Main Menu'!$E$13:$E$14

But the 'Main Menu' worksheet has a CODE NAME of of "Main". I've tried
numerous permutations but i just cannot get this chart's Data Range to
reference the worksheet CODE NAME instead.

Can anyone help?

Thanks

It isn't designed to use the code name, so you can stop trying.

--
Regards,
Tom Ogilvy

"Bing" <[email protected]> wrote in message
news:[email protected]...
> Hi all,
>
> I have an excel chart (generated by the Chart Wizard) that references the
> worksheet NAME. For example, when i right click on chart, and select
'Source
> Data' i see the 'Data Range' reference the worksheet NAME as follows:
>
> ='Main Menu'!$D$13:$D$14,'Main Menu'!$E$13:$E$14
>
> But the 'Main Menu' worksheet has a CODE NAME of of "Main". I've tried
> numerous permutations but i just cannot get this chart's Data Range to
> reference the worksheet CODE NAME instead.
>
> Can anyone help?
>
> Thanks
>
>

I would not use the code name main, only because it is a reserved workd in a
lot of programming languages. The program will enter at the main procedure.
shtMain would be a better choice. That having been said try this

=shtMain.Range($D$13:$D$14), shtMain.range($E$13:$E$14)

HTH

"Bing" wrote:

> Hi all,
>
> I have an excel chart (generated by the Chart Wizard) that references the
> worksheet NAME. For example, when i right click on chart, and select 'Source
> Data' i see the 'Data Range' reference the worksheet NAME as follows:
>
> ='Main Menu'!$D$13:$D$14,'Main Menu'!$E$13:$E$14
>
> But the 'Main Menu' worksheet has a CODE NAME of of "Main". I've tried
> numerous permutations but i just cannot get this chart's Data Range to
> reference the worksheet CODE NAME instead.
>
> Can anyone help?
>
> Thanks
>
>