Creating a graph in Excel to track scores and events along the way....

[brendan344]

Hi guys,

What im actually looking for is a way to track cricket scores and graphically show where wickets were lost along the way. Where:

'x' Axis - Overs
'y' Axis - Runs
and wickets represented at the point where they fell - eg 2.5 overs, 25 runs

This is normally called a Worm Chart and i've seen them produced in excel, but have no ideas on how to recreate.

To give an example how this should look -

http://www.mcmullan.net/jfa/articles/artic01a.html


(One Day Cricket Match Run Rate)



I've been trying to do this in Excel 07 & its been driving me mad. Any pointers would be gratefully appreciated.

[brendan344]

Wow - 83 views and no-one knows how to do it...