lezawang
Well-known Member
- Joined
- Mar 27, 2016
- Messages
- 1,805
- Office Version
- 2016
- Platform
- Windows
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
<tbody>
</tbody>
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
grade | percent |
a | 10% |
c | 50% |
f | 40% |
<tbody>
</tbody>