wikiproject Cricket/Graphs

Templates

• Need to ask someone who has the sample spreadsheet to email it, excel can't be uploaded on commons. eg YellowMonkey, who has emailed it to Sarastro1
  • Sample per the five-innings average in Ernie Toshack with the Australian cricket team in England in 1948 and other season forks of bios
  • Per ten-innings average in Douglas Jardine among many other standard biographies

• Can be used for Tests, ODI, Twenty20, FC, anything

Instructions

• Open up to the datasheet page as an example
• First column is year of the innings, or month in the case of a season
• Second column for runs in innings
• 3rd col mark 1 if not out.
• 4th col is total runs for last 10/5 innings as desired for running average
• 5th col is total outs for last 10/5 innings per above, using the sum function of 10 or 5 subtract the sum of ones in the not out column
• 6th col is divide to get running average of last 10/5 innings

Graph rendering

Old excel

My old excel computer doesn't work at the moment, so can't write down the graph technique for it

New excel (2009 onwards)

Cumbersome....

• Select the whole data area and click on the chart icon and select 2D column. There will be multicolumns everywhere. It's auto so you can't butt in immediately
• Right click on graph and go to "select data"
  • The horizontal axis labels are by default 1 2 3 etc, so click on edit and then drag down the year column, to switch it to years
  • Then delete the data series for not out, year, total runs, total outs, keeping only runs and average
• Right click on x-axis and "format axis" and then "alignment" on the LHS and then rotate the text by 270 degrees
• Because the chart thing is rigid to begin with, both the runs and average are shown as bars.
  • Right click on the average data series and select "change series chart type" and switch to line with no data points.
  • Colour in columns with red by "format data series" and "fill" red. For the line, use "line color" blue
  • Insert text box and type in title
  • Copy the chart to Paint, and then using the paintbrush, add appropriately colored blue circular dots of the same tint above the not outs
    • Save as PNG

Note: Adjust colour as desired, eg in a season's graph, red bars for Test innings and pink for FC