creating a chart from a userform

I have a dynamic table on a worksheet that shows in

col A name of player
col B Date
Col C Course
Col D Course Par
Cols E-V individual hole scores

what I am wanting to do is create a userform which uses drop down boxes to select the player and the course an option button to select a hole and when command button is clicked produces a chart showing date and scores for selected hole. This could be in another worksheet or the origional userform or a new userform. Would this be possible?
james