lets say in sheet1 we have the following values

A1="NAMES" B1="SCORE"
A2="FRANK" B2="10"
A3="JACK" B3="20"
A4="JOE" B4="30"

When i click the command button in userform1 then the chart should be dispayed for the above data in the same userform. the problem is...

How do I achieve it???? :-(

I tried using the microsoft chart control but it asks me to set a connection to a query or any other database. i don't want to use this. i have gone through the microsoft help but didn't get any answer. is there any other way?