Re: How do I change the y-axis on an Excel chart from numbers towords. This will plot everything as zero values, since they are all text. You can fake it using one of these approaches: http://peltiertech.com/Excel/Charts/Y_CategoryAxis.html. http://peltiertech.com/Excel/Charts/DotPlot.html. - Jon.
First you must keep in mind that all ears of corn have an even number of rows, never an odd number. All average ears have between 12 and 20 rows. Still, it's difficult to tell at a glance whether an ear has 14, 16, 18, or 20 rows.
Estimating Corn Yields ïµ Count ears in 1/1000 th acre ïµ Count # of kernel rows per ear on every fifth ear and average ïµ Count # of kernels/row on same ears, average âDo not count kernels that are less than half size ïµ Estimated yield = (ear number x row number x kernel number per row)/90.