Chart Title

[LDanix]

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?

[Roadie]

Yes for the Chart Title, but No for the Sheetname.

[SPDavern]

The chart title is easy: Select the title, then move the cursor to the formula bar and enter = and the cell address.

One way to link a cell and a sheet name or chart name is to use the Change worksheet event and/or the Calculate worksheet event with VBA. If the value of the cell changes then rename the chart with the new value.

Regards,
Sean

[R.VENKATARAMAN]

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 <LDanix@discussions.microsoft.com> wrote in message
news:4605EF37-117B-4DF3-95D9-296B0E3EC3A1@microsoft.com...
> 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]

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