Results 1 to 6 of 6
  1. #1
    3 Star Lounger
    Join Date
    Aug 2003
    Location
    Voorhees, New Jersey
    Posts
    200
    Thanks
    0
    Thanked 0 Times in 0 Posts

    plot titles (2003 SP3)

    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.

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: plot titles (2003 SP3)

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

    Steve

  3. #3
    3 Star Lounger
    Join Date
    Aug 2003
    Location
    Voorhees, New Jersey
    Posts
    200
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: plot titles (2003 SP3)

    Steve,

    That has been my workaround and it works fine...

    Thanks,

    Tom

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: plot titles (2003 SP3)

    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.

  5. #5
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: plot titles (2003 SP3)

    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).
    Regards,
    Rory

    Microsoft MVP - Excel

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: plot titles (2003 SP3)

    Yep, that works. Thanks!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •