How do I use excel names with INDIRECT with charts

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Holger Gerths - 12 Jul 2006 16:12 GMT

Hello,

I want to create a Chart that does not directly reference cell-ranges (i.e.
A1:A6),
but excel-names that make the reference sheet-independent.
My aim is to be able to copy one chart to other worksheets, which have their
dataareas at the same places like the source-sheet.

Problem: This works fine in cells but not in charts
Excel name definition:
=INDIRECT("R3C2";0):INDIRECT("R3C5";0)

Any idea about this?

Thanks in advance,
Holger.

Reply to this Message

Tushar Mehta - 16 Jul 2006 12:44 GMT

You have to include the sheet name in the final formula that you want XL to
use.

Signature

Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

> Hello,
>
[quoted text clipped - 12 lines]
> Thanks in advance,
> Holger.

Reply to this Message

Holger Gerths - 29 Jul 2006 13:25 GMT

Hello,

can you give me an example?
I want to copy a chart from one sheet to another without making changes in
chart-references, but moving these references to the destination chart.

Thanks,
Holger.

> You have to include the sheet name in the final formula that you want XL
> to
[quoted text clipped - 18 lines]
>> Thanks in advance,
>> Holger.

Reply to this Message