Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop Down Menu Title | Excel Worksheet Functions | |||
Chart Title Link to Data Table | Charts and Charting in Excel | |||
How to link a drop down menu to another one? | Excel Worksheet Functions | |||
link chart title? | Charts and Charting in Excel | |||
Link To Drop Down Menu | Excel Worksheet Functions |