Thread: Setting the Chart name as the text from a cell.
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
mpeplow[_13_] mpeplow[_13_] is offline
external usenet poster
  
Posts: 1
Default Setting the Chart name as the text from a cell.

Idea - Not Solution

Change
ActiveChart.ChartTitle.Parent.Name = "=Sheet1!R1C" & C

to
ActiveChart.ChartTitle.Parent.Name = Sheet1!R1C.text & " " & C


--
mpeplow
------------------------------------------------------------------------
mpeplow's Profile: http://www.excelforum.com/member.php...o&userid=34812
View this thread: http://www.excelforum.com/showthread...hreadid=562177

Reply With QuoteReply With Quote