Chart Title
 

Is it possible to refer back to a cell for part or all of the Chart Title?
Also, is the same possible when naming worksheets?

righlcick chart-click sorucedata. choose series-,in the existing series go
to the line<name click the icon and click the cell where the name is
located hit enter and click ok . now see the chart. is the new title shown?
you can also write a vba

reg sheetname you can add this code statement in vba
activesheet.name=range("I3")
I3 is cell where the name is located.




LDanix wrote in message
...
Is it possible to refer back to a cell for part or all of the Chart Title?
Also, is the same possible when naming worksheets?

Hi,

You can link all of the chart title to a cell.
Click the chart title and then in the formula bar enter =
now click the cell with the chart title in it and press enter.
This works for data labels as well.

Cheers
Andy

LDanix wrote:
Is it possible to refer back to a cell for part or all of the Chart Title?
Also, is the same possible when naming worksheets?

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info