Posted: Fri Oct 21, 2005 8:36 am Post subject: Excel problem
I'm trying to display the value of a cell in a chart title bar. Easy enough using the code =Sheet1!Y10 for example. But i want this value surrounded by text in the title so it updates itself. i can't find a way round of mixing text with a formula, have searched all over but nothing gives a clue. i'm guessing you have to do a bit of visual basic. as soon as you put text, be it surrounded by speech marks (" or ') the cell is deemed to be text not a formula. Any ideas?
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum