• 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.

about dynamic Dashboard ....

J

jskushawah

New Member
I have four charts named Area, Region, City and Country. these are in sheet1 A1, A2, A3 and A4 cells, now i want in sheet2 Cell D1, when i select "Area", chart "area" should appear in cell B4, and when I Select in sheet2 cell D1 = "region" from drop down, chart "region" should appear in cell B4, how i link them ? please suggest???
 
If your following the technique at Chandoo's other post at: http://chandoo.org/wp/2008/11/05/select-show-one-chart-from-many/


The Named Formula getChart should be:

Code: 
=IF('Sheet 2'!$D$1="Area",INDIRECT("'Sheet 1'!A1"),IF('Sheet 2'!$D$1="Region",INDIRECT("'Sheet 2'!A2"),IF('Sheet 2'!$D$1="City",INDIRECT("'Sheet 2'!A3"),INDIRECT("'Sheet 1'!A4"))))
 
You must log in or register to reply here.
Back
Top