Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 8
Default Dynamic drop-down menus with PivotCharts

Hi!

The data I have can be categorized for example in two categories;
category X and Y (+ time)
The problem however is that I would like to have some kind of dynamic
drop-down menu for my second option (category Y) which changes based
on the choice of X.

The problem is that right now, I have 20 X items, but let's say 1000 Y
items, so to go through the whole list of 1000 is a bit tedious when
making selections. So I was thinking, that a much more elegant
solution would be to have the content of the Y menu change based on my
choice of X, thus narrowing the list to about 50 (if the Y's are
evenly distributed/connected to the different X's)

To me it sounds like a simple piece of code, but can it be done?
Examples?

BR,
Josip
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating Drop-down menus with subset drop-down menus Benjamin Excel Worksheet Functions 4 June 8th 09 11:27 PM
Dynamic drop-down menus with PivotCharts [email protected] Charts and Charting in Excel 6 August 21st 08 01:17 AM
drop down menus Ewing25 Excel Programming 2 April 30th 08 05:35 PM
Dynamic menus Tobie Excel Programming 3 October 17th 06 09:28 AM
Drop down menus Please help Excel Discussion (Misc queries) 1 January 29th 05 07:05 PM


All times are GMT +1. The time now is 11:39 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"