Chart Titles

  • Thread starter Thread starter Steven
  • Start date Start date
S

Steven

Is there a way to reference the contents of a range name
for a Chart Title? My chart name can change and I would
prefer to reference a name range vs typing it in every
time.

Thanks,

Steven.
 
Hi Steven,

Yes, select the charttitle and then on the formula bar type in the named
range, something like =book1.xls!namedrange

or for a simple cell link, whilst in the formula bar click the cell you
want to link to.
Is there a way to reference the contents of a range name
for a Chart Title? My chart name can change and I would
prefer to reference a name range vs typing it in every
time.

Thanks,

Steven.
Click to expand...

--

Cheers
Andy

http://www.andypope.info
 
Back
Top