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.
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.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
