Hi There, I have a 4 week trend graph that I would like to make more interactive. I want to have a "from" and "to" drop down lists that viewers can pick whichever weeks they want to see and the chart will update accordingly. Any help is appreciated
Below is an example of what my data looks like
<tbody>
</tbody><colgroup><col><col span="5"></colgroup>
Below is an example of what my data looks like| A | B | C | D | E | |
| WK1 | 76.9% | 81.3% | 63.9% | 80.3% | 72.8% |
| WK2 | 85.2% | 87.1% | 80.1% | 80.1% | 65.9% |
| WK3 | 62.4% | 72.5% | 62.2% | 50.0% | 63.4% |
| WK4 | 76.2% | 72.8% | 75.2% | 84.7% | 59.2% |
| WK5 | 75.7% | 69.4% | 76.2% | 85.8% | 82.3% |
| WK6 | 79.7% | 73.9% | 77.1% | 83.8% | 62.4% |
| WK7 | 76.9% | 81.3% | 63.9% | 80.3% | 72.8% |
| WK8 | 85.2% | 87.1% | 80.1% | 80.1% | 65.9% |
| WK9 | 62.4% | 72.5% | 62.2% | 50.0% | 63.4% |
| WK10 | 76.2% | 72.8% | 75.2% | 84.7% | 59.2% |
| WK11 | 75.7% | 69.4% | 76.2% | 85.8% | 82.3% |
| WK12 | 79.7% | 73.9% | 77.1% | 83.8% | 62.4% |
| WK13 | 76.9% | 81.3% | 63.9% | 80.3% | 72.8% |
| WK14 | 85.2% | 87.1% | 80.1% | 80.1% | 65.9% |
| WK15 | 62.4% | 72.5% | 62.2% | 50.0% | 63.4% |
| WK16 | 76.2% | 72.8% | 75.2% | 84.7% | 59.2% |
| WK17 | 75.7% | 69.4% | 76.2% | 85.8% | 82.3% |
| WK18 | 79.7% | 73.9% | 77.1% | 83.8% | 62.4% |
| WK19 | 76.9% | 81.3% | 63.9% | 80.3% | 72.8% |
| WK20 | 85.2% | 87.1% | 80.1% | 80.1% | 65.9% |
| WK21 | 62.4% | 72.5% | 62.2% | 50.0% | 63.4% |
| WK22 | 76.2% | 72.8% | 75.2% | 84.7% | 59.2% |
| WK23 | 75.7% | 69.4% | 76.2% | 85.8% | 82.3% |
| WK24 | 79.7% | 73.9% | 77.1% | 83.8% | 62.4% |
| WK25 | 76.9% | 81.3% | 63.9% | 80.3% | 72.8% |
| WK26 | 85.2% | 87.1% | 80.1% | 80.1% | 65.9% |
| WK27 | 62.4% | 72.5% | 62.2% | 50.0% | 63.4% |
| WK28 | 76.2% | 72.8% | 75.2% | 84.7% | 59.2% |
| WK29 | 75.7% | 69.4% | 76.2% | 85.8% | 82.3% |
| WK30 | 79.7% | 73.9% | 77.1% | 83.8% | 62.4% |
| WK31 | 76.9% | 81.3% | 63.9% | 80.3% | 72.8% |
| WK32 | 85.2% | 87.1% | 80.1% | 80.1% | 65.9% |
| WK33 | 62.4% | 72.5% | 62.2% | 50.0% | 63.4% |
| WK34 | 76.2% | 72.8% | 75.2% | 84.7% | 59.2% |
| WK35 | 75.7% | 69.4% | 76.2% | 85.8% | 82.3% |
| WK36 | 79.7% | 73.9% | 77.1% | 83.8% | 62.4% |
| WK37 | 76.9% | 81.3% | 63.9% | 80.3% | 72.8% |
| WK38 | 85.2% | 87.1% | 80.1% | 80.1% | 65.9% |
| WK39 | 62.4% | 72.5% | 62.2% | 50.0% | 63.4% |
| WK40 | 76.2% | 72.8% | 75.2% | 84.7% | 59.2% |
| WK41 | 75.7% | 69.4% | 76.2% | 85.8% | 82.3% |
| WK42 | 79.7% | 73.9% | 77.1% | 83.8% | 62.4% |
| WK43 | 79.7% | 73.9% | 77.1% | 83.8% | 62.4% |
| WK44 | 76.9% | 81.3% | 63.9% | 80.3% | 72.8% |
| WK45 | 85.2% | 87.1% | 80.1% | 80.1% | 65.9% |
| WK46 | 62.4% | 72.5% | 62.2% | 50.0% | 63.4% |
| WK47 | 76.2% | 72.8% | 75.2% | 84.7% | 59.2% |
| WK48 | 75.7% | 69.4% | 76.2% | 85.8% | 82.3% |
| WK49 | 79.7% | 73.9% | 77.1% | 83.8% | 62.4% |
| WK50 | 76.2% | 72.8% | 75.2% | 84.7% | 59.2% |
| WK51 | 75.7% | 69.4% | 76.2% | 85.8% | 82.3% |
| WK52 | 79.7% | 73.9% | 77.1% | 83.8% | 62.4% |
<tbody>
</tbody><colgroup><col><col span="5"></colgroup>
