+ Reply to Thread
Results 1 to 2 of 2

Populate Chart Title from Cell Value - VBA?

  1. #1
    Registered User
    Join Date
    11-17-2014
    Location
    SF Bay Area, CA
    MS-Off Ver
    Mac 2011
    Posts
    3

    Populate Chart Title from Cell Value - VBA?

    I'm guessing this is going to be a VBA function, but I'd like to take the value of a cell and insert it in as part of a chart title. This will be applied to a template used by different users, and instead of updating each chart's title, it would be great if they could just enter their name in one cell and have it reflected in all the chart titles. The name entered will not be the entire chart title, just added to the existing title. Can this be done? Working with Mac Excel 2011.

    Thanks,
    Rusty

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,025

    Re: Populate Chart Title from Cell Value - VBA?

    Yes... and No. You have to assemble the title in a cell and then reference that cell. See attached.
    Attached Files Attached Files
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] cell reference in chart title
    By vizzkid in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-20-2013, 04:43 AM
  2. [SOLVED] Chart title referenced from a cell
    By tlacloche in forum Excel Charting & Pivots
    Replies: 58
    Last Post: 04-11-2013, 04:33 PM
  3. Replies: 1
    Last Post: 06-28-2006, 01:25 PM
  4. [SOLVED] Chart title = cell contects
    By Dkso in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 08-27-2005, 09:05 AM
  5. Pasting Objects into Chart title and Axis title
    By Sam in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-06-2005, 04:05 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1