+ Reply to Thread
Results 1 to 6 of 6

Chart Titles

  1. #1
    Forum Contributor
    Join Date
    06-21-2010
    Location
    -
    MS-Off Ver
    Excel 2010
    Posts
    1,211

    Chart Titles

    I have a faux 'Menu System' set up in a worksheet (see attached sample). The cell selected determines the graph displayed.

    I want to add a Chart Title, based on the user selection, for example if user selects a Sub Option from Column C, then the graph for the Sub Option is displayed. How can I make my chart title read 'Option, Sub Option'?

    If the user clicks cell C4, I want my chart title to read 'Option 2, Sub Option 2'
    If the user clicks cell C21, I want my chart title to read 'Option 4, Sub Option 3'
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    04-30-2012
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    547

    Re: Chart Titles

    Let the chart title refer to a specific cell and then save the desired chart title in that cell.

    The value of that cell can probably be set with a simple change event macro, but to write that, I'd have to see the actual setup with the drop-down menus.
    Like a post? Click the star below it!

  3. #3
    Forum Expert Palmetto's Avatar
    Join Date
    04-04-2007
    Location
    South Eastern, USA
    MS-Off Ver
    XP, 2007, 2010
    Posts
    3,978

    Re: Chart Titles

    You should use Data Validation lists to select Options and sub-options, probably using dependent lists

    Using two input cells, we can join the selections into a text string and then edit the title box in the chart to point to the cell where we have done this.

    See attached - very basic example.
    The chart is not dynamic, but the title is (using two drop down lists).


    Excel Help_840527.xlsx
    Palmetto

    Do you know . . . ?

    You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.

  4. #4
    Forum Contributor
    Join Date
    06-21-2010
    Location
    -
    MS-Off Ver
    Excel 2010
    Posts
    1,211

    Re: Chart Titles

    npammcpp and Palmetto,

    I figured out a dynamic way to achieve this, so all is working as required now, so many thanks for your input... greatly appreciated.

  5. #5
    Forum Expert Palmetto's Avatar
    Join Date
    04-04-2007
    Location
    South Eastern, USA
    MS-Off Ver
    XP, 2007, 2010
    Posts
    3,978

    Re: Chart Titles

    Was your solution something different than what was offered?
    If so, why not post your solution for the benefit of others who find this thread?

  6. #6
    Forum Contributor
    Join Date
    06-21-2010
    Location
    -
    MS-Off Ver
    Excel 2010
    Posts
    1,211

    Re: Chart Titles

    Palmetto,

    Apologies, yes, I used the approach of referencing a particular cell which is updated dynamically based on various users selections. This then updates the chart title, so in effect it is doing exactly the same thing as the sample you kindly provided only using multiple cells the user clicks in rather than drop down menus.

+ 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