Hey there!
Am trying to make a dynamic title - that is a title that depends on a cell e.g. "Trading rule: ABI > z ...." where z is a number written in another cell (so z should be a cell reference... but that is not possible seeing as I am not writing a formula?) Any suggestions on how to fix this problem?
if you are talking about a chart title then the simple way is to put a formula in a cell that refers to your z cell and then link your title to that cell. to link the title click on the edge of the title text box then type = in the formula bar and select the formula cell then press enter
Josie
if at first you don't succeed try doing it the way your wife told you to
Thanks! But really it is just some words in a cell (don't know how to explain?)... I need a cell saying "Trading rule: ABI > z" but I want the z to depend on another cell?
="Trading rule: ABI > "&A1
for instance. if you need the number formatted then you can add in the TEXT function
="Trading rule: ABI > "&TEXT(A1,"$#,##0")
Now it works, thank you so much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks