Chart Title

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
Back
Top