• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Link chart with format controls .......

Hi jskushawah,


It can be done in many ways.


Could you please specify which control(check box, combobox, scrollbar etc) you want to link to and what exactly you are trying to achieve?


Moreover, why don't you think of uploading a sample file in order to have a better visualization of your data? To do the same please follow the link

http://chandoo.org/forums/topic/posting-a-sample-workbook


Best Regards,

Kaushik
 
Hi jskushawah,


Would request you to please feel free to play with different keywords at the top right section (google custom search) of this page. Because, the forum might have experienced lot of such similar kind of posts earlier. Hence, doing that you may land up with, perhaps, the exact solution of your problem


However, for your reference, following is an article written by chandoo on option button on March 2011.


http://chandoo.org/wp/2011/03/16/analytical-charts-tutorial/
 
Jskushawah


In Excel Form Controls don't link to charts

They link to a cell


The cell can then be used to control a window to your data typically achieved by using a Combination of Offset() or Index(Match()) functions to retrieve the data

As the Form Control changes

The link cell changes

This forces the lookup window to move and and a new set of data is retrieved


Have a read of:

http://chandoo.org/wp/2011/03/30/form-controls/

and

http://chandoo.org/wp/2010/11/04/analysing-large-tables/
 
I am getting a huge response from chandoo.org, thanks for all who are drivers of this site, like all excel ninjas this site is also awesome..
 
You must log in or register to reply here.
Back
Top