Dynamic chart
 

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

Dynamic chart
 

Try use pivot chart
Data/Pivot Table/select Pivot Chart Report/Next/Next/Layout/
In row section put your names
In data section put all months
OK/Finish
Chart is created
Choose which moths you want to see in Data - pick ones you want to see on
the chart



Click yes if helped

--
Greatly appreciated
Eva


"Flemming" wrote:

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


.