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/