Chart Title change with Drop Down Selection

M

Marty Girvan

I created a drop down menu that changes the data in my chart. For example Money is a category and then Stocks are a category. When you click stocks itgives you a chart of all the stocks and money associated. If you use the drop down and select money, it changes the chart to all your money you have in the bank. This is a relatively easy deal, but for the life of me, I cannot get the title to change automatically with the drop down selection. I am looking for a tutorial or some info on how to change the title at the top of the chart, automatically with with the use of my drop down menu I created. Thanks for looking.

Marty
 
I

isabelle

hi,

select the chart and add a text box with the drawing toolbar
then go to the formula bar and type: = Sheet1!$G$12 and validate.
the text contained in G12 is added to the chart.

isabelle

Le 2014-09-18 16:53, Marty Girvan a écrit :
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2010: How to display PivotChart Report Filter Lables on the graph 2
Using Drop Down Menu for Macro 6
Pivot Table 1
Access Combination Chart Types Access 2010 0
Data Validation and drop-down list using IF, AND and what else? 8
VLookup not working - missing entries or not returning correct values 1
Drop down list from index/match formula 1
How can I use the drop down cell selection in a formula? 1

Top