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'
Bookmarks