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?