Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
updating sheet by choice from drop down menu
I have a drop down menu with weeks to choose from in a sheet with some charts
& graphs. I want to update the charts & graphs with the info from the week that is chosen in the drop down menu (from other sheets in the workbook). Right now, I'm using dynamic names to update the charts and the drop down menu just changes the week that is displayed. Should I use VLookup or something else to accomplish this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
updating sheet by choice from drop down menu
Have a look at Stephen Bullen's scrollable chart. May do the trick.
http://www.oaltd.co.uk/Excel/Default.htm FunChrt7.zip Gord Dibben MS Excel MVP On Thu, 26 Jun 2008 08:56:02 -0700, kal4000 wrote: I have a drop down menu with weeks to choose from in a sheet with some charts & graphs. I want to update the charts & graphs with the info from the week that is chosen in the drop down menu (from other sheets in the workbook). Right now, I'm using dynamic names to update the charts and the drop down menu just changes the week that is displayed. Should I use VLookup or something else to accomplish this? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
updating sheet by choice from drop down menu
Thanks Gord. Stephen has some nice solutions.
"Gord Dibben" wrote: Have a look at Stephen Bullen's scrollable chart. May do the trick. http://www.oaltd.co.uk/Excel/Default.htm FunChrt7.zip Gord Dibben MS Excel MVP On Thu, 26 Jun 2008 08:56:02 -0700, kal4000 wrote: I have a drop down menu with weeks to choose from in a sheet with some charts & graphs. I want to update the charts & graphs with the info from the week that is chosen in the drop down menu (from other sheets in the workbook). Right now, I'm using dynamic names to update the charts and the drop down menu just changes the week that is displayed. Should I use VLookup or something else to accomplish this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting based on Drop Down choice | Excel Discussion (Misc queries) | |||
Use dd menu choice to filter input for next ddm, etc. | Excel Discussion (Misc queries) | |||
how to activate a drop down menu in spreed sheet with space bar? | Excel Discussion (Misc queries) | |||
How do I set up a drop down choice in a cell | Excel Discussion (Misc queries) | |||
Applying a formula to a drop menu choice | Excel Discussion (Misc queries) |