View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Holger Gerths Holger Gerths is offline
external usenet poster
 
Posts: 29
Default How do I use excel names with INDIRECT with charts

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.