learningexcelVBA
New Member
- Joined
- Feb 26, 2010
- Messages
- 1
Hi,
Me is a Newbie looking for some Excel Guru help please!!
I downloaded a file which is a chart that uses a dropdown list to show the detail etc, called "Charts Custom Control". Im sure you know what it is and where it came from.
My problem is i want to use this type of function for a chart on another workbook, but i want to use the headings as the dropdown list to return the values for my chart. 1 have 8 heading, with a range that will continue to grow, what am i doing wrong to use this function in my own workbook?
Attached the file so you can see.
E.g. dropdown box uses the name to return the row values but i want to use the column names (Exam A , B, C, D,) to return the Column values in my graph. Any help please!!
Me is a Newbie looking for some Excel Guru help please!!
I downloaded a file which is a chart that uses a dropdown list to show the detail etc, called "Charts Custom Control". Im sure you know what it is and where it came from.
My problem is i want to use this type of function for a chart on another workbook, but i want to use the headings as the dropdown list to return the values for my chart. 1 have 8 heading, with a range that will continue to grow, what am i doing wrong to use this function in my own workbook?
Attached the file so you can see.
E.g. dropdown box uses the name to return the row values but i want to use the column names (Exam A , B, C, D,) to return the Column values in my graph. Any help please!!