PC Review


Reply
Thread Tools Rate Thread

Dynamic drop-down menus with PivotCharts

 
 
Josip.2000@gmail.com
Guest
Posts: n/a
 
      6th Jun 2008
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 With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating Drop-down menus with subset drop-down menus Benjamin Microsoft Excel Worksheet Functions 4 8th Jun 2009 11:27 PM
Dynamic drop-down menus with PivotCharts Josip.2000@gmail.com Microsoft Excel Charting 1 6th Jun 2008 04:45 PM
Drop down menus and popup menus not working properly =?Utf-8?B?TWlrZSBNSWxhbm8=?= Windows XP General 3 7th Nov 2005 07:12 PM
pop up menus and drop down menus disappear, task bar missing, HELP bob Windows XP General 3 23rd Dec 2003 04:38 PM
Drop Down Menus - lost short menus Dave Windows XP Internet Explorer 1 31st Jul 2003 01:47 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:21 PM.