PDA

View Full Version : creating a chart from a userform



shkey775
12-27-2011, 12:48 AM
Hi All

I am working on a small project that will enable a golfer (namly my mate Bill) to keep his scores for different courses and dates and then display them as a chart either round by round or hole by hole

What I would like to do ideally is create a chart from a userform useing drop down boxes for names and courses and checkboxes for 1 or more holes to be displayed in a line or bar chart
The source data is in a dynamic table which is updated after every round of golf

I have attached a worksheet with sample data on it

Cn anyone give me some pointers please
Regards James

Bob Phillips
12-27-2011, 04:54 AM
Try this for a starter

shkey775
12-27-2011, 11:17 PM
That is Fantastic Thankyou

This will give me a starting point to work from
Once again Thankyou and a Happy New Year
James