Graph with help of Data Validation

[Gaurang Mhatre]

Hi Friends,


Need help in below query.

I want to make a graph where if I choose a month the graph should come as per the month selected. For eg if choose month Apr’13 then the graph should show data from Jan till Apr’13.

Attached is the excel to give you clear picture.

Also, I want the format of the month to remain the same in excel ie “Jan’14” since it would be easy to understand during graph. Is it possible??

Thanks in advance for your help!


Regards,
Gaurang

 

[Smallman]

Hi Gaurang

I had a look at your file. I would not recommend putting your data validation list in the 10,000th column just to get it the list out of the way. Keep your validation lists close to your source data or set up a sheet originally titled "Lists" where you store this sort of data openly.

Onto your problem. This dynamic range

=OFFSET(Filter!$C$8,0,0,MATCH(Filter!$D$4,Filter!$C$8:$C$19,0),1)

I called it 'Test', tagged it to your chart, then fixed up your validation list and the attached is the result.

Take care

Smallman

 

[Gaurang Mhatre]

Hi Smallman,

Thanks alot for your help..
Will work on it ..and will let you know if there is any query..
Thanks once again for taking out your precious time.!

Cheers!

 

[Smallman]

Hi @Gaurang

You are most welcome. Will catch you next time.

Smallman

 

[Gaurang Mhatre]

Hi Smallman,

In data labels it is coming as month instead of count. How to show count coz i have tried data labels but months are appearing on bar graph.


Regards,
Gaurang.

 

[Smallman]

Hi Gaurang

Sorry about that. I didn't even notice and now it seems as clear as day after you pointed it out. Here is an update of the file.

Take care

Smallman

 

[Gaurang Mhatre]

Thanks buddy.
One more question, how did u tag "test" with graph since im unable to do so.
Sorry to bother you much with my queries.

Thanks again in advance!

Regards,
Gaurang

 

[Smallman]

Hi Gaurang

Right click on your graph - Select Data - Now click Edit. After the exclamation mark put the dynamic named range. See below




Hope this helps

Take care

Smallman

 

[Gaurang Mhatre]

Thanks buddy....Its working...
Hats off to u

God bless u!
Regards,
Gaurang

 

[Gaurang Mhatre]

Hi Smallman,

Is there any way where if i select month the count(table) should reflect as per the month selected. For eg if i select Oct'13 then the table should show data from Jan'13 to Oct'13 and rest months blank...just like you have done it for graph can we do it for table?
Because now when u select any month, graph changes but the table details doesnt like one shown in below

So is there any method where both the graph and table details changes.

Attached is the excel to give you clear picture

Thanks in advance.

Regards,
Gaurang.

 

[Gaurang Mhatre]

hi small man,

how can i show comparison of 2014 vs 2013 with help of above trick u made
attached is the file for your reference
Regards,
Gaurang