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? |
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? |
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? |
All times are GMT +1. The time now is 11:17 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com