Creating an interactive Dynamic chart with dropdown lists

C

Chelsea11

New Member
Joined
Dec 3, 2014
Messages
2
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

[TABLE="width: 411"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[/TR]
[TR]
[TD]WK1[/TD]
[TD="align: right"]76.9%[/TD]
[TD="align: right"]81.3%[/TD]
[TD="align: right"]63.9%[/TD]
[TD="align: right"]80.3%[/TD]
[TD="align: right"]72.8%[/TD]
[/TR]
[TR]
[TD]WK2[/TD]
[TD="align: right"]85.2%[/TD]
[TD="align: right"]87.1%[/TD]
[TD="align: right"]80.1%[/TD]
[TD="align: right"]80.1%[/TD]
[TD="align: right"]65.9%[/TD]
[/TR]
[TR]
[TD]WK3[/TD]
[TD="align: right"]62.4%[/TD]
[TD="align: right"]72.5%[/TD]
[TD="align: right"]62.2%[/TD]
[TD="align: right"]50.0%[/TD]
[TD="align: right"]63.4%[/TD]
[/TR]
[TR]
[TD]WK4[/TD]
[TD="align: right"]76.2%[/TD]
[TD="align: right"]72.8%[/TD]
[TD="align: right"]75.2%[/TD]
[TD="align: right"]84.7%[/TD]
[TD="align: right"]59.2%[/TD]
[/TR]
[TR]
[TD]WK5[/TD]
[TD="align: right"]75.7%[/TD]
[TD="align: right"]69.4%[/TD]
[TD="align: right"]76.2%[/TD]
[TD="align: right"]85.8%[/TD]
[TD="align: right"]82.3%[/TD]
[/TR]
[TR]
[TD]WK6[/TD]
[TD="align: right"]79.7%[/TD]
[TD="align: right"]73.9%[/TD]
[TD="align: right"]77.1%[/TD]
[TD="align: right"]83.8%[/TD]
[TD="align: right"]62.4%[/TD]
[/TR]
[TR]
[TD]WK7[/TD]
[TD="align: right"]76.9%[/TD]
[TD="align: right"]81.3%[/TD]
[TD="align: right"]63.9%[/TD]
[TD="align: right"]80.3%[/TD]
[TD="align: right"]72.8%[/TD]
[/TR]
[TR]
[TD]WK8[/TD]
[TD="align: right"]85.2%[/TD]
[TD="align: right"]87.1%[/TD]
[TD="align: right"]80.1%[/TD]
[TD="align: right"]80.1%[/TD]
[TD="align: right"]65.9%[/TD]
[/TR]
[TR]
[TD]WK9[/TD]
[TD="align: right"]62.4%[/TD]
[TD="align: right"]72.5%[/TD]
[TD="align: right"]62.2%[/TD]
[TD="align: right"]50.0%[/TD]
[TD="align: right"]63.4%[/TD]
[/TR]
[TR]
[TD]WK10[/TD]
[TD="align: right"]76.2%[/TD]
[TD="align: right"]72.8%[/TD]
[TD="align: right"]75.2%[/TD]
[TD="align: right"]84.7%[/TD]
[TD="align: right"]59.2%[/TD]
[/TR]
[TR]
[TD]WK11[/TD]
[TD="align: right"]75.7%[/TD]
[TD="align: right"]69.4%[/TD]
[TD="align: right"]76.2%[/TD]
[TD="align: right"]85.8%[/TD]
[TD="align: right"]82.3%[/TD]
[/TR]
[TR]
[TD]WK12[/TD]
[TD="align: right"]79.7%[/TD]
[TD="align: right"]73.9%[/TD]
[TD="align: right"]77.1%[/TD]
[TD="align: right"]83.8%[/TD]
[TD="align: right"]62.4%[/TD]
[/TR]
[TR]
[TD]WK13[/TD]
[TD="align: right"]76.9%[/TD]
[TD="align: right"]81.3%[/TD]
[TD="align: right"]63.9%[/TD]
[TD="align: right"]80.3%[/TD]
[TD="align: right"]72.8%[/TD]
[/TR]
[TR]
[TD]WK14[/TD]
[TD="align: right"]85.2%[/TD]
[TD="align: right"]87.1%[/TD]
[TD="align: right"]80.1%[/TD]
[TD="align: right"]80.1%[/TD]
[TD="align: right"]65.9%[/TD]
[/TR]
[TR]
[TD]WK15[/TD]
[TD="align: right"]62.4%[/TD]
[TD="align: right"]72.5%[/TD]
[TD="align: right"]62.2%[/TD]
[TD="align: right"]50.0%[/TD]
[TD="align: right"]63.4%[/TD]
[/TR]
[TR]
[TD]WK16[/TD]
[TD="align: right"]76.2%[/TD]
[TD="align: right"]72.8%[/TD]
[TD="align: right"]75.2%[/TD]
[TD="align: right"]84.7%[/TD]
[TD="align: right"]59.2%[/TD]
[/TR]
[TR]
[TD]WK17[/TD]
[TD="align: right"]75.7%[/TD]
[TD="align: right"]69.4%[/TD]
[TD="align: right"]76.2%[/TD]
[TD="align: right"]85.8%[/TD]
[TD="align: right"]82.3%[/TD]
[/TR]
[TR]
[TD]WK18[/TD]
[TD="align: right"]79.7%[/TD]
[TD="align: right"]73.9%[/TD]
[TD="align: right"]77.1%[/TD]
[TD="align: right"]83.8%[/TD]
[TD="align: right"]62.4%[/TD]
[/TR]
[TR]
[TD]WK19[/TD]
[TD="align: right"]76.9%[/TD]
[TD="align: right"]81.3%[/TD]
[TD="align: right"]63.9%[/TD]
[TD="align: right"]80.3%[/TD]
[TD="align: right"]72.8%[/TD]
[/TR]
[TR]
[TD]WK20[/TD]
[TD="align: right"]85.2%[/TD]
[TD="align: right"]87.1%[/TD]
[TD="align: right"]80.1%[/TD]
[TD="align: right"]80.1%[/TD]
[TD="align: right"]65.9%[/TD]
[/TR]
[TR]
[TD]WK21[/TD]
[TD="align: right"]62.4%[/TD]
[TD="align: right"]72.5%[/TD]
[TD="align: right"]62.2%[/TD]
[TD="align: right"]50.0%[/TD]
[TD="align: right"]63.4%[/TD]
[/TR]
[TR]
[TD]WK22[/TD]
[TD="align: right"]76.2%[/TD]
[TD="align: right"]72.8%[/TD]
[TD="align: right"]75.2%[/TD]
[TD="align: right"]84.7%[/TD]
[TD="align: right"]59.2%[/TD]
[/TR]
[TR]
[TD]WK23[/TD]
[TD="align: right"]75.7%[/TD]
[TD="align: right"]69.4%[/TD]
[TD="align: right"]76.2%[/TD]
[TD="align: right"]85.8%[/TD]
[TD="align: right"]82.3%[/TD]
[/TR]
[TR]
[TD]WK24[/TD]
[TD="align: right"]79.7%[/TD]
[TD="align: right"]73.9%[/TD]
[TD="align: right"]77.1%[/TD]
[TD="align: right"]83.8%[/TD]
[TD="align: right"]62.4%[/TD]
[/TR]
[TR]
[TD]WK25[/TD]
[TD="align: right"]76.9%[/TD]
[TD="align: right"]81.3%[/TD]
[TD="align: right"]63.9%[/TD]
[TD="align: right"]80.3%[/TD]
[TD="align: right"]72.8%[/TD]
[/TR]
[TR]
[TD]WK26[/TD]
[TD="align: right"]85.2%[/TD]
[TD="align: right"]87.1%[/TD]
[TD="align: right"]80.1%[/TD]
[TD="align: right"]80.1%[/TD]
[TD="align: right"]65.9%[/TD]
[/TR]
[TR]
[TD]WK27[/TD]
[TD="align: right"]62.4%[/TD]
[TD="align: right"]72.5%[/TD]
[TD="align: right"]62.2%[/TD]
[TD="align: right"]50.0%[/TD]
[TD="align: right"]63.4%[/TD]
[/TR]
[TR]
[TD]WK28[/TD]
[TD="align: right"]76.2%[/TD]
[TD="align: right"]72.8%[/TD]
[TD="align: right"]75.2%[/TD]
[TD="align: right"]84.7%[/TD]
[TD="align: right"]59.2%[/TD]
[/TR]
[TR]
[TD]WK29[/TD]
[TD="align: right"]75.7%[/TD]
[TD="align: right"]69.4%[/TD]
[TD="align: right"]76.2%[/TD]
[TD="align: right"]85.8%[/TD]
[TD="align: right"]82.3%[/TD]
[/TR]
[TR]
[TD]WK30[/TD]
[TD="align: right"]79.7%[/TD]
[TD="align: right"]73.9%[/TD]
[TD="align: right"]77.1%[/TD]
[TD="align: right"]83.8%[/TD]
[TD="align: right"]62.4%[/TD]
[/TR]
[TR]
[TD]WK31[/TD]
[TD="align: right"]76.9%[/TD]
[TD="align: right"]81.3%[/TD]
[TD="align: right"]63.9%[/TD]
[TD="align: right"]80.3%[/TD]
[TD="align: right"]72.8%[/TD]
[/TR]
[TR]
[TD]WK32[/TD]
[TD="align: right"]85.2%[/TD]
[TD="align: right"]87.1%[/TD]
[TD="align: right"]80.1%[/TD]
[TD="align: right"]80.1%[/TD]
[TD="align: right"]65.9%[/TD]
[/TR]
[TR]
[TD]WK33[/TD]
[TD="align: right"]62.4%[/TD]
[TD="align: right"]72.5%[/TD]
[TD="align: right"]62.2%[/TD]
[TD="align: right"]50.0%[/TD]
[TD="align: right"]63.4%[/TD]
[/TR]
[TR]
[TD]WK34[/TD]
[TD="align: right"]76.2%[/TD]
[TD="align: right"]72.8%[/TD]
[TD="align: right"]75.2%[/TD]
[TD="align: right"]84.7%[/TD]
[TD="align: right"]59.2%[/TD]
[/TR]
[TR]
[TD]WK35[/TD]
[TD="align: right"]75.7%[/TD]
[TD="align: right"]69.4%[/TD]
[TD="align: right"]76.2%[/TD]
[TD="align: right"]85.8%[/TD]
[TD="align: right"]82.3%[/TD]
[/TR]
[TR]
[TD]WK36[/TD]
[TD="align: right"]79.7%[/TD]
[TD="align: right"]73.9%[/TD]
[TD="align: right"]77.1%[/TD]
[TD="align: right"]83.8%[/TD]
[TD="align: right"]62.4%[/TD]
[/TR]
[TR]
[TD]WK37[/TD]
[TD="align: right"]76.9%[/TD]
[TD="align: right"]81.3%[/TD]
[TD="align: right"]63.9%[/TD]
[TD="align: right"]80.3%[/TD]
[TD="align: right"]72.8%[/TD]
[/TR]
[TR]
[TD]WK38[/TD]
[TD="align: right"]85.2%[/TD]
[TD="align: right"]87.1%[/TD]
[TD="align: right"]80.1%[/TD]
[TD="align: right"]80.1%[/TD]
[TD="align: right"]65.9%[/TD]
[/TR]
[TR]
[TD]WK39[/TD]
[TD="align: right"]62.4%[/TD]
[TD="align: right"]72.5%[/TD]
[TD="align: right"]62.2%[/TD]
[TD="align: right"]50.0%[/TD]
[TD="align: right"]63.4%[/TD]
[/TR]
[TR]
[TD]WK40[/TD]
[TD="align: right"]76.2%[/TD]
[TD="align: right"]72.8%[/TD]
[TD="align: right"]75.2%[/TD]
[TD="align: right"]84.7%[/TD]
[TD="align: right"]59.2%[/TD]
[/TR]
[TR]
[TD]WK41[/TD]
[TD="align: right"]75.7%[/TD]
[TD="align: right"]69.4%[/TD]
[TD="align: right"]76.2%[/TD]
[TD="align: right"]85.8%[/TD]
[TD="align: right"]82.3%[/TD]
[/TR]
[TR]
[TD]WK42[/TD]
[TD="align: right"]79.7%[/TD]
[TD="align: right"]73.9%[/TD]
[TD="align: right"]77.1%[/TD]
[TD="align: right"]83.8%[/TD]
[TD="align: right"]62.4%[/TD]
[/TR]
[TR]
[TD]WK43[/TD]
[TD="align: right"]79.7%[/TD]
[TD="align: right"]73.9%[/TD]
[TD="align: right"]77.1%[/TD]
[TD="align: right"]83.8%[/TD]
[TD="align: right"]62.4%[/TD]
[/TR]
[TR]
[TD]WK44[/TD]
[TD="align: right"]76.9%[/TD]
[TD="align: right"]81.3%[/TD]
[TD="align: right"]63.9%[/TD]
[TD="align: right"]80.3%[/TD]
[TD="align: right"]72.8%[/TD]
[/TR]
[TR]
[TD]WK45[/TD]
[TD="align: right"]85.2%[/TD]
[TD="align: right"]87.1%[/TD]
[TD="align: right"]80.1%[/TD]
[TD="align: right"]80.1%[/TD]
[TD="align: right"]65.9%[/TD]
[/TR]
[TR]
[TD]WK46[/TD]
[TD="align: right"]62.4%[/TD]
[TD="align: right"]72.5%[/TD]
[TD="align: right"]62.2%[/TD]
[TD="align: right"]50.0%[/TD]
[TD="align: right"]63.4%[/TD]
[/TR]
[TR]
[TD]WK47[/TD]
[TD="align: right"]76.2%[/TD]
[TD="align: right"]72.8%[/TD]
[TD="align: right"]75.2%[/TD]
[TD="align: right"]84.7%[/TD]
[TD="align: right"]59.2%[/TD]
[/TR]
[TR]
[TD]WK48[/TD]
[TD="align: right"]75.7%[/TD]
[TD="align: right"]69.4%[/TD]
[TD="align: right"]76.2%[/TD]
[TD="align: right"]85.8%[/TD]
[TD="align: right"]82.3%[/TD]
[/TR]
[TR]
[TD]WK49[/TD]
[TD="align: right"]79.7%[/TD]
[TD="align: right"]73.9%[/TD]
[TD="align: right"]77.1%[/TD]
[TD="align: right"]83.8%[/TD]
[TD="align: right"]62.4%[/TD]
[/TR]
[TR]
[TD]WK50[/TD]
[TD="align: right"]76.2%[/TD]
[TD="align: right"]72.8%[/TD]
[TD="align: right"]75.2%[/TD]
[TD="align: right"]84.7%[/TD]
[TD="align: right"]59.2%[/TD]
[/TR]
[TR]
[TD]WK51[/TD]
[TD="align: right"]75.7%[/TD]
[TD="align: right"]69.4%[/TD]
[TD="align: right"]76.2%[/TD]
[TD="align: right"]85.8%[/TD]
[TD="align: right"]82.3%[/TD]
[/TR]
[TR]
[TD]WK52[/TD]
[TD="align: right"]79.7%[/TD]
[TD="align: right"]73.9%[/TD]
[TD="align: right"]77.1%[/TD]
[TD="align: right"]83.8%[/TD]
[TD="align: right"]62.4%[/TD]
[/TR]
</tbody><colgroup><col><col span="5"></colgroup>[/TABLE]
 

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.
Sort by date Sort by votes
You must log in or register to reply here.

Similar threads

D
  • Question Question
Populating a Table based on drop down boxes
Replies
6
Views
400
DavidWT87
D
T
  • Question Question
VBA Chart generator - Help
Replies
1
Views
594
tjrobo19
T
H
  • Question Question
NEED HELP: Countif tie breaker with multiple tie breaker criteria
Replies
1
Views
2K
DRSteele
DRSteele
P
  • Question Question
help to complete a Holley Jet calculation using VLOOKUP
Replies
0
Views
2K
portcity05
P
R
  • Question Question
lookup on calculated value not exact in list
Replies
5
Views
919
starkc69
S

Forum statistics

Threads
1,223,234
Messages
6,170,891
Members
452,366
Latest member
TePunaBloke

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top