Cross links [tables, charts, dropdown box]

[Dag]

Actually, the subj.

I have 4 tables with the same fields (except the first one) and 4 corresponding charts. I need one drop-down box together with (or near to) the charts for filtering data in all tables by one click / choice. Charts gona change their display values also. Hope that it was clear.

Any link? Any resource or idea? Thanks in advance.

 

[Akashwani]

Hi,

Take a look here and type Chart into the search box....

http://www.youtube.com/user/ExcelIsFun#g/u

You may want to check out MrExcel as well....

http://www.youtube.com/user/bjele123


Good luck

Ak

 

[Dag]

It is not the answer. I am subscribed there already. If you did post exact link - it would be the help then.

 

[Akashwani]

Hi,

I'm not sure what it is you want to do, so all I can do is point you in the direction of expert help.

Maybe this video can guide you...
http://www.youtube.com/watch?v=M9hhUVljTx4

http://peltiertech.com/Excel/Charts/Dynamics.html

Ak

 

[Dag]

The first link is about nothing (you excuse me) I mean in my question. I have 4 (four) filtered proper Excel tables but need to control all their filters by one combo-box. The second link has one page but they are working with one table only. I tried some play with that but result is still nothing. Maybe now it will be more clear.

Excel 2010<table style="border: 1px solid rgb(255, 255, 255); background-color: rgb(255, 255, 255); border-collapse: collapse;" cellpadding="2.5px" rules="all"><colgroup><col style="background-color: rgb(218, 231, 245);" width="25px"><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead><tr style="background-color: rgb(218, 231, 245); text-align: center; color: rgb(22, 17, 32);"><th>
</th><th>A</th><th>B</th><th>C</th><th>D</th><th>E</th><th>F</th><th>G</th><th>H</th><th>I</th><th>J</th><th>K</th></tr></thead><tbody><tr><td style="color: rgb(22, 17, 32); text-align: center;">1</td><td style="font-weight: bold;">Sales</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td></tr><tr><td style="color: rgb(22, 17, 32); text-align: center;">2</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td></tr><tr><td style="color: rgb(22, 17, 32); text-align: center;">3</td><td style="border-right: 1px solid black; border-bottom: 1px solid black; font-weight: bold;">Andrea</td><td>G. A</td><td>G. B</td><td>G. C</td><td>G. D</td><td>
</td><td style="border-right: 1px solid black; border-bottom: 1px solid black; font-weight: bold;">Lisa</td><td>G. A</td><td>G. B</td><td>G. C</td><td>G. D</td></tr><tr><td style="color: rgb(22, 17, 32); text-align: center;">4</td><td style="border-top: 1px solid black; border-right: 1px solid black; font-style: italic;">Q. 1</td><td style="border-top: 1px solid black; border-left: 1px solid black; text-align: center;">10</td><td style="border-top: 1px solid black; text-align: center;">20</td><td style="border-top: 1px solid black; text-align: center;">30</td><td style="border-top: 1px solid black; text-align: center;">40</td><td>
</td><td style="border-top: 1px solid black; border-right: 1px solid black; font-style: italic;">Q. 1</td><td style="border-top: 1px solid black; border-left: 1px solid black; text-align: center;">9</td><td style="border-top: 1px solid black; text-align: center;">12</td><td style="border-top: 1px solid black; text-align: center;">24</td><td style="border-top: 1px solid black; text-align: center;">44</td></tr><tr><td style="color: rgb(22, 17, 32); text-align: center;">5</td><td style="border-right: 1px solid black; font-style: italic;">Q. 2</td><td style="border-left: 1px solid black; text-align: center;">20</td><td style="text-align: center;">30</td><td style="text-align: center;">40</td><td style="text-align: center;">50</td><td>
</td><td style="border-right: 1px solid black; font-style: italic;">Q. 2</td><td style="border-left: 1px solid black; text-align: center;">19</td><td style="text-align: center;">22</td><td style="text-align: center;">34</td><td style="text-align: center;">54</td></tr><tr><td style="color: rgb(22, 17, 32); text-align: center;">6</td><td style="border-right: 1px solid black; font-style: italic;">Q. 3</td><td style="border-left: 1px solid black; text-align: center;">30</td><td style="text-align: center;">40</td><td style="text-align: center;">50</td><td style="text-align: center;">60</td><td>
</td><td style="border-right: 1px solid black; font-style: italic;">Q. 3</td><td style="border-left: 1px solid black; text-align: center;">29</td><td style="text-align: center;">32</td><td style="text-align: center;">44</td><td style="text-align: center;">64</td></tr><tr><td style="color: rgb(22, 17, 32); text-align: center;">7</td><td style="border-right: 1px solid black; font-style: italic;">Q. 4</td><td style="border-left: 1px solid black; text-align: center;">40</td><td style="text-align: center;">50</td><td style="text-align: center;">60</td><td style="text-align: center;">70</td><td>
</td><td style="border-right: 1px solid black; font-style: italic;">Q. 4</td><td style="border-left: 1px solid black; text-align: center;">39</td><td style="text-align: center;">42</td><td style="text-align: center;">54</td><td style="text-align: center;">74</td></tr><tr><td style="color: rgb(22, 17, 32); text-align: center;">8</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td></tr><tr><td style="color: rgb(22, 17, 32); text-align: center;">9</td><td style="border-right: 1px solid black; border-bottom: 1px solid black; font-weight: bold;">Mary</td><td>G. A</td><td>G. B</td><td>G. C</td><td>G. D</td><td>
</td><td style="border-right: 1px solid black; border-bottom: 1px solid black; font-weight: bold;">Jane</td><td>G. A</td><td>G. B</td><td>G. C</td><td>G. D</td></tr><tr><td style="color: rgb(22, 17, 32); text-align: center;">10</td><td style="border-top: 1px solid black; border-right: 1px solid black; font-style: italic;">Q. 1</td><td style="border-top: 1px solid black; border-left: 1px solid black; text-align: center;">8</td><td style="border-top: 1px solid black; text-align: center;">18</td><td style="border-top: 1px solid black; text-align: center;">33</td><td style="border-top: 1px solid black; text-align: center;">35</td><td>
</td><td style="border-top: 1px solid black; border-right: 1px solid black; font-style: italic;">Q. 1</td><td style="border-top: 1px solid black; border-left: 1px solid black; text-align: center;">12</td><td style="border-top: 1px solid black; text-align: center;">29</td><td style="border-top: 1px solid black; text-align: center;">28</td><td style="border-top: 1px solid black; text-align: center;">39</td></tr><tr><td style="color: rgb(22, 17, 32); text-align: center;">11</td><td style="border-right: 1px solid black; font-style: italic;">Q. 2</td><td style="border-left: 1px solid black; text-align: center;">18</td><td style="text-align: center;">28</td><td style="text-align: center;">43</td><td style="text-align: center;">45</td><td>
</td><td style="border-right: 1px solid black; font-style: italic;">Q. 2</td><td style="border-left: 1px solid black; text-align: center;">22</td><td style="text-align: center;">39</td><td style="text-align: center;">38</td><td style="text-align: center;">49</td></tr><tr><td style="color: rgb(22, 17, 32); text-align: center;">12</td><td style="border-right: 1px solid black; font-style: italic;">Q. 3</td><td style="border-left: 1px solid black; text-align: center;">28</td><td style="text-align: center;">38</td><td style="text-align: center;">53</td><td style="text-align: center;">55</td><td>
</td><td style="border-right: 1px solid black; font-style: italic;">Q. 3</td><td style="border-left: 1px solid black; text-align: center;">32</td><td style="text-align: center;">49</td><td style="text-align: center;">48</td><td style="text-align: center;">59</td></tr><tr><td style="color: rgb(22, 17, 32); text-align: center;">13</td><td style="border-right: 1px solid black; font-style: italic;">Q. 4</td><td style="border-left: 1px solid black; text-align: center;">38</td><td style="text-align: center;">48</td><td style="text-align: center;">63</td><td style="text-align: center;">65</td><td>
</td><td style="border-right: 1px solid black; font-style: italic;">Q. 4</td><td style="border-left: 1px solid black; text-align: center;">42</td><td style="text-align: center;">59</td><td style="text-align: center;">58</td><td style="text-align: center;">69</td></tr></tbody></table>

Sheet1​

 

[Akashwani]

Hi,

I'm sorry that I'm unable to solve this problem for you, have a look here...

http://chandoo.org/wp/2009/10/15/dynamic-chart-data-series/

By the way how did you manage to post your table and chart data on here?

Ak

 

[Dag]

No problemo: thank you for try. I'll checkout the last link. About posting:

Guidelines for posting
http://www.mrexcel.com/forum/showthread.php?t=127080

Von Pookie's HTML Maker FAQ
http://www.mrexcel.com/forum/showthread.php?t=89356

Chart is simple image posted by using HTML as:
<pre><img src="http:\\online.address.of.your.image"></pre>

 

[Akashwani]

Hey,

I've done some G**gling and a Dynamic Dashboard is what I think you require...

http://chandoo.org/wp/2010/03/16/excel-dashboard-tutorial-1/

http://www.youtube.com/watch?v=A3A6kjJl4A4
http://www.youtube.com/watch?v=V9GMCS-WjyI&feature=related
http://www.youtube.com/watch?v=FBZhBwz-PHg&feature=related

Good luck I hope you find your solution.

Ak