How do I use excel names with INDIRECT with charts

[Holger Gerths]

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.

 

[Tushar Mehta]

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

--
Regards,

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

 

[Holger Gerths]

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.