+ Reply to Thread
Results 1 to 6 of 6

How do I use a named range as my chart title?

  1. #1
    Forum Contributor
    Join Date
    06-11-2009
    Location
    Cape Town
    MS-Off Ver
    Microsoft 365
    Posts
    825

    How do I use a named range as my chart title?

    I have a range name that changes and I want to apply this name to the Title above my chart. I would like to use a formula like: =Region?
    Thanks in advance

  2. #2
    Valued Forum Contributor jwright650's Avatar
    Join Date
    12-10-2010
    Location
    Va, USA
    MS-Off Ver
    Excel 2003, Excel 2010
    Posts
    606

    Re: How do I use a named range as my chart title?

    Did you try to add quotes around the named range
    ie.
    ="Region"
    Life is like a roll of toilet paper. The closer it gets to the end, the faster it goes.
    John Wright

  3. #3
    Forum Contributor
    Join Date
    06-11-2009
    Location
    Cape Town
    MS-Off Ver
    Microsoft 365
    Posts
    825

    Re: How do I use a named range as my chart title?

    Yes, but that does not work?

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    51,995

    Re: How do I use a named range as my chart title?

    You need to add this to the "formula" bar after you click on the title area
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  5. #5
    Forum Contributor
    Join Date
    06-11-2009
    Location
    Cape Town
    MS-Off Ver
    Microsoft 365
    Posts
    825

    Re: How do I use a named range as my chart title?

    I inserted a text box, clicked inside the chart to create an empty text box. I then typed the equal sign in the formula bar and clicked the cell that contained the named range. This works.

  6. #6
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    51,995

    Re: How do I use a named range as my chart title?

    glad you got it figured out

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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