linked list

[lezawang]

Hi
I have a table like the one below. What I want, I want to create dynamic chart that show one grade at a time. So if a user select A then the percentage of A will appear as below and then the chat will show A and its %. I am thinking that could be done with data validation but I not sure how to do that. I appreciate your help. Thanks

grade [a] percent [10%] <<---- so use will select from a list A, B or F and then excel will put the % based on the table below



[TABLE="class: grid, width: 200"]
<tbody>[TR]
[TD]grade[/TD]
[TD]percent[/TD]
[/TR]
[TR]
[TD]a[/TD]
[TD]10%[/TD]
[/TR]
[TR]
[TD]c[/TD]
[TD]50%[/TD]
[/TR]
[TR]
[TD]f[/TD]
[TD]40%[/TD]
[/TR]
</tbody>[/TABLE]

 

[Yongle]

Here is one method
- when value in D2 changes, value in E2 automatically changed and chart is automatically updated if you do this....

1. Put your data above in cells A1 to D4

2. Cell D2 has data validation (Allow List with source =A2:A4 )
3. Cell E2 has formula
=VLOOKUP(D2,A2:B4,2,0)

4. Format cell E2 as percentage

5. Select range D2:E2 and Insert \ chart