View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
JonR JonR is offline
external usenet poster
 
Posts: 82
Default Make chart title based on a cell?

Thanks for the shortcut tlosgyl3! I'm always looking for the quickest &
easiest way to do things (comes from being lazy). ;-)
--


JonR


"tlosgyl3" wrote:


Great tip JonR - solved a problem I had been struggling with. However I
have found you don't need to draw the box - select the Chart, type
=(worksheet name and cell reference) in the formual bar and Ecel will
automatically make the box for you.

I formatted my text in the worksheet in which I placed my Chart Titles
and it worked really well.

tlosgyl3


--
tlosgyl3
------------------------------------------------------------------------
tlosgyl3's Profile: http://www.excelforum.com/member.php...o&userid=28074
View this thread: http://www.excelforum.com/showthread...hreadid=556897