VBA: Link Chart Title to Drop Down Menu
 

What is the code used to grab the title of a chart from a drop dow
menu?

For example I choose "Adams County" from the drop down menu. I hit th
go button, the data appears i need a chart for. I hit create chart.
It makes the chart but I need it to automattically include "Adam
County" from the drop down menu as the chart's title.

Any help is appreciated.

Thanks.:

--
Message posted from http://www.ExcelForum.com

Link Chart Title to Drop Down Menu
 

Hi
try
- select the chart title box
- hit F2 or click directly in the formula bar
- enter the equation sign '=' and select this cell

--
Regards
Frank Kabel
Frankfurt, Germany

"toddanderson1 " schrieb
im Newsbeitrag ...
What is the code used to grab the title of a chart from a drop down
menu?

For example I choose "Adams County" from the drop down menu. I hit
the
go button, the data appears i need a chart for. I hit create chart.
It makes the chart but I need it to automattically include "Adams
County" from the drop down menu as the chart's title.

Any help is appreciated.

Thanks.:)


---
Message posted from http://www.ExcelForum.com/

VBA: Link Chart Title to Drop Down Menu
 

I actually need the name from the dropdown menu. The name doesn'
appear in a cell. It's not possible to = and then select a name fro
the drop down menu.




Thanks for your help .:

--
Message posted from http://www.ExcelForum.com

VBA: Link Chart Title to Drop Down Menu
 

Hi
so you're not using 'Data - Validation' to create this combo box. I
would suggest you link your drop down to a cell (you can hide this
cell) and link this cell to the chart title.
Without this you'll need VBA

--
Regards
Frank Kabel
Frankfurt, Germany

"toddanderson1 " schrieb
im Newsbeitrag ...
I actually need the name from the dropdown menu. The name doesn't
appear in a cell. It's not possible to = and then select a name from
the drop down menu.




Thanks for your help .:)


---
Message posted from http://www.ExcelForum.com/