Chart Title change with Drop Down Selection

  • Thread starter Thread starter Marty Girvan
  • Start date Start date
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
 
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 :
 
Back
Top