Search titles only
Install the app
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
Reply to thread
[QUOTE="Flemming, post: 3853184"] Hi Maybe you can help me out. I have a classic sales table... Jan Feb Mar etc. David 20 21 23 James 18 22 17 Sam 21 25 20 Jane 23 24 22 I would like to create a dropdown where I select months... i.e. February I'd then like to have two charts 1) showing the sales persons and just the figures for selection (here February) 2) showing the sales persons and all months... that beeing January to selection (here February) I'd like the charts to be dynamic, so when I select February in the dropdown, at it returns 2 to a cell then the charts can pickup on that month number.. Can that be done?? how? I have tryed using named ranges like this Feb header is in cell G4 I can create a named ranged to contain Februaries figures =OFFSET(Sheet1!$G$4;0;0;COUNTA(Sheet1!$G:$G)-1;1) using that formular or the named range in the chart does not seem to work for me. Any help on this issue? Demo files, guide or friendly helpers? Thanks for you time Flemming [/QUOTE]