Free £25 Bet!
Free £200 Bet - Register on Saturday or Sunday
Free £25 Bet!

In association with Sports-Punter Free Bets Odds Comparison BetHelp Limso

We are the Official Forum of FreeBetting.net & FCBet.com


Sports News Sports Stats Live Scores OddsChecker Place Bets Suggest a Site


Go Back   The Punters Lounge - The World's Best Betting Forum > Systems, Strategy and General Betting Help > Punters Tools & General Betting Help Forum

Punters Tools & General Betting Help Forum Everyone has tools that use to help them bet. Match reports, odds comparison services, tipster services, betting calculators, selection software - discuss them here.

UK & Irish Football Forum | Western European Football Forum | UEFA Cup & Champions League Football Forum | International Football Forum | Eastern & Southern European Football Forum | Nordic & Scandinavian Football Forum | Non European Football Forum | At The Races Forum | At The Races Systems Forum | Other Sports Forum | USA Sports Forum | Fantasy & Fun Comps Forum | Free Bets Forum | Systems & Strategy Forum | Glory Hunter's Forum | Tipster's Challenge Forum | Daily Racing Comp Forum | Euro & Worldwide Comp Forum | Poker Tourneys Forum | Poker Strategy Forum | Poker Chat Forum | Poker Live Forum | Poker Challenges Forum | Poker Staking Forum | e-Sport Poker League Forum | Bookmakers & Exchanges Forum | Punter's Tools/Betting Help Forum | General Chat Forum | Tech & Gaming Forum | Sports Banter Forum | Live Sports Feeds Forum

Reply
 
Thread Tools Display Modes
Old 28-01-2007, 10:32   #1 (permalink)
Dedicated Punter
 
Dices's Avatar
 
Join Date: 18 Dec 2006
Location: Greece
Age: 39
Posts: 244
Default Excel Graphs, help needed

Hi,
I'm having a table with two colums of data, one shows the aver corners from last 4 matches before a game and the other the actual corners at the respectivly match. Something like this:

Av L4
Corners
7,13
7
7,38
10
7,63
14
7,88
13
8,00
9
8,25
8
8,25
14
8,25
12
8,38
8
8,38
11
8,38
7
8,38
12
8,63
10
8,63
14
8,75
19
8,88
14
8,88
7
8,88
5
8,88
10
9,00
12
9,00
16
9,00
11
9,00
3
9,00
10
9,00
8
9,00
8
9,00
11
9,13
7
9,13
7
9,13
12
9,13
6
9,25
8
9,25
11
9,25
8
9,38
9
9,38
12
9,38
15
9,38
15
9,50
14
9,50
4
9,50
16
9,50
13
9,50
8
9,50
10
9,50
10
9,50
11
9,50
7
9,63
11
9,63
12
9,63
8
9,63
9
9,63
4
9,63
11
9,75
14
9,75
7
9,75
8
9,75
12
9,88
13
9,88
5
9,88
8
9,88
7
10,00
13
10,00
11
10,00
9
10,00
9
10,00
9
10,00
6
10,00
11
10,13
11
10,13
17
10,13
9
10,13
8
10,25
18
10,25
6
10,25
20
10,25
14
10,25
12
10,25
9
10,38
7
10,38
11
10,38
20
10,38
8
10,50
9
10,50
16
10,50
8
10,50
16
10,50
15
10,50
16
10,63
18
10,63
3
10,63
16
10,63
14
10,63
5
10,75
7
10,75
10
10,75
11
10,75
11
10,75
6
10,75
13
10,88
18
10,88
5
10,88
6
10,88
13
10,88
13
11,00
5
11,00
10
11,00
8
11,00
10
11,13
10
11,25
6
11,25
10
11,25
11
11,25
12
11,25
19
11,25
7
11,25
13
11,25
15
11,25
13
11,38
12
11,38
6
11,38
17
11,50
11
11,50
5
11,50
4
11,63
10
11,63
14
11,63
9
11,63
4
11,63
13
11,75
11
11,75
11
11,75
7
11,75
11
11,75
10
11,75
12
11,75
12
11,75
8
11,88
13
12,00
14
12,00
4
12,13
7
12,13
20
12,13
9
12,25
8
12,25
9
12,38
11
12,38
14
12,38
19
12,50
9
12,50
13
12,63
14
12,63
15
12,63
10
12,75
11
12,88
14
12,88
9
13,00
11
13,00
5
13,13
7
13,50
17
14,25
5
14,38
13
15,63
12



I want to make a graph from this table with one axe (x) the Av L4, the other axe (z) the corners (...9,10,11,12...) and for data the corners.
For example if the graph will be from dots (and not lines,etc) at the axe x will be at the start the mark 7,13 with one dot at the point (7,13/7), later at some point at the begining the 8,25 mark and because there are 3 results at 8,25 (8 corners, 12 corners and 14 corners) there will be :
One dot at the point (8,25/8), one dot at (8,25/12) and another one at (8,25/14) etc. Hope i was clear enough.
I tried playing with pivot tables but with no succces.
You know what they say: A picture is like a thoushand words.

Can any given answer be send as an attachment?
Thanks
Dices is offline   Reply With Quote
Old 28-01-2007, 11:49   #2 (permalink)
God Punter
 
GotaFancy?'s Avatar
 
Join Date: 18 Jun 2005
Posts: 33,062
Awards Showcase
Tipsters Challenge Oscars Poker Monthly League Champion BPP 
Total Awards: 4
Default Re: Excel Graphs, help needed

I don't think a Pivot Table is what you are looking for ..... at a quick look, sounds like you are after a scatter graph?

GotaFancy? is offline   Reply With Quote
Old 28-01-2007, 14:51   #3 (permalink)
Dedicated Punter
 
Dices's Avatar
 
Join Date: 18 Dec 2006
Location: Greece
Age: 39
Posts: 244
Default Re: Excel Graphs, help needed

Thanks GotaFancy, this is what i want.
How did you get it ? This "scatter" graph is what i want , but how?
Dices is offline   Reply With Quote
Old 28-01-2007, 14:55   #4 (permalink)
God Punter