plot titles (2003 SP3)

Topic

New Reply

I am able to use a cell reference for a plot title.
Going a step further, is it possible to concatenate multiple cell entries into one plot tile (using &, I guess)?
I made a couple of attempts that didn’t work…thought I’d ask.

Reply | Quote

Replies

An easy way is to concatenate many things into a cell and then use the cell reference as the title

Steve

Reply | Quote

Steve,

That has been my workaround and it works fine…

Thanks,

Tom

Reply | Quote

Unless you want to use VBA, you have to do it that way. The only kind of formula you can enter in a title box, or in a text box on a chart, is a direct cell reference. Expressions aren’t allowed.

Reply | Quote

You can define a name that refers to a cell and use that defined name as the source for a title. If you then edit the name to refer to a formula, the title should reflect the results of the formula. It’s not a supported method as far as I know, but I haven’t had a problem with it (yet).

Reply | Quote

Yep, that works. Thanks!

Reply | Quote