print a league performance graph

**brucieboy1966** · 11-10-2007, 02:47 PM

I run a fantasy footie league..there are 39 temas in total (1-39)...i keep a record of what position each team is ,each week..we are in the 11th week..

I have listed 2 teams' positions for the last 11 weeks,on the attached sheet

what i want to do,is be able to type any team number and to have a graph come up on sheet 2 showing how that team has peformed so far..hopefully using the example i have used on the attached file

I can do each graph manually,but i want to look at each team by typing the team number

**protonLeah** · 11-10-2007, 07:21 PM

Your attachment is only a 458 byte shortcut, you did not zip the .xls file itself.

**oldchippy** · 11-10-2007, 07:28 PM

brucieboy1966,

To post a zipped example, go to “My Documents” or wherever you have your file stored, right-click and “Send to > Compressed file”, then attach this zipped file to your post.

**brucieboy1966** · 11-10-2007, 09:02 PM

sorry for the mistake..I hopefully have put the right file on..

I have inserted the graph,i want to use..i can do each one separately,but i want to be able to view a team's graph,just by typing the number...thanks for any help

**protonLeah** · 11-12-2007, 12:05 AM

I have mod'd your workbook adding radio buttons for the two teams with data and inserted a row for week numbers. Selecting a radio/option button will call the macro that will delete the current chart, if any, and create a new one for the selected team. The macro may have a few unused lines of code that I didn't clean up, but it works.

**brucieboy1966** · 11-12-2007, 09:52 PM

great work Protonleah....I have now put all 39 teams onto the sheet..could you help me out further,as follows,please

(1) every week, i append the league position for each team,so could you program it to show all weeks that are on the sheet,at any time...there are 11 so far,but the chart only shows 10..it usually ends up with about 40 weeks by the end of the season in May..

(2) If possible,could you amend the chart to have a blue background with yellow line,with a black border as shown on (footie1..attached)..I find this easier on the eye

Thanks again for your great help,

**protonLeah** · 11-13-2007, 03:34 AM

o.k. Try this one.

**brucieboy1966** · 11-13-2007, 01:42 PM

excellent work !!!....I owe you a beer...I have forwarded it onto all the managers,they are impressed..it's about time I joined the modern world of charts etc..I have been running a league for about 15 years now,this helps a lot,cheers..if i need any tweaks I will get back to you,if that is ok..Bruce