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. Simplest and Least Accurate Method The simplest and least accurate method is to select an ear or ears that represent the average ear size in the field. Count the number of kernels per ear and multiply by 0.300 to get a very rough yield estimate. To determine number of corn kernels per ear, multiply number of rows on an ear by number of kernels in a row. Do not count kernels near the tip that are less than half the size of kernels midway up the ear. Table 1. Multipliers based on ears per acre and kernel size to calculate expected yield. Determine the number of kernels per ear and multiply that number by the correct multiplier to make a yield estimate. Ears/ Acre Kernel Size Kernels per Bushel